Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.22-13
-
None
Description
I'm using Data Masking Plugin to mask some data in a database via UPDATE statements.
Just few UPDATE commands are enough to have percona server crash.
Step to reproduce:
1) load dictionaries
select gen_dictionary_drop('lorem'); select gen_dictionary_drop('address'); select gen_dictionary_drop('zip'); select gen_dictionary_drop('location'); select gen_dictionary_drop('vat'); select gen_dictionary_drop('client'); select gen_dictionary_drop('item'); select gen_dictionary_drop('supplier'); select gen_dictionary_drop('name'); select gen_dictionary_drop('surname'); select gen_dictionary_drop('username');
2) execute updates against a table
UPDATE `client` SET `address` = gen_dictionary('address'); UPDATE `client` SET `client_desc` = gen_dictionary('client'); UPDATE `client` SET `location` = gen_dictionary('location'); UPDATE `client` SET `client_short_name` = gen_dictionary('lorem'); UPDATE `client` SET `VAT_number` = gen_dictionary('vat'); UPDATE `client` SET `cap` = gen_dictionary('zip');
3) Percona MySQL crases
mysql> UPDATE `client` SET `address` = gen_dictionary('address');
UPDATE `client` SET `location` = gen_dictionary('location');
UPDATE `client` SET `client_short_name` = gen_dictionary('lorem');
UPDATE `client` SET `VAT_number` = gen_dictionary('vat');
UPDATE `client` SET `cap` = gen_dictionary('zip');ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> UPDATE `client` SET `client_desc` = gen_dictionary('client');
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR:
Can't connect to the server
Log on the server:
2021-02-09T10:31:49.987345Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-13) starting as process 18415 2021-02-09T10:31:49.998087Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-02-09T10:31:51.032141Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2021-02-09T10:31:51.364911Z 0 [ERROR] [MY-013180] [Server] Function 'keyring_file' already exists. 2021-02-09T10:31:51.365492Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'keyring_file' with soname 'keyring_file.so'. 2021-02-09T10:31:51.369361Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2021-02-09T10:31:51.401424Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2021-02-09T10:31:51.411997Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
Attachments
Issue Links
- relates to
-
-
- Done
-
