[MDEV-30712] binlog_encryption.encrypted_master sometimes fails with ER_NOT_KEYFILE error Created: 2023-02-22  Updated: 2023-05-01

Status: Open
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 10.11, 11.0, 11.1
Fix Version/s: 10.11, 11.0, 11.1

Type: Bug Priority: Major
Reporter: Angelique Sklavounos (Inactive) Assignee: Angelique Sklavounos (Inactive)
Resolution: Unresolved Votes: 0
Labels: None

Attachments: File mysqld.1.err.9     File mysqld.2.err.9    

 Description   

11.0 2b13ae1a3

binlog_encryption.encrypted_master 'ctr,innodb,mix' w3 [ fail ]
        Test ended at 2023-02-21 11:58:45
 
CURRENT_TEST: binlog_encryption.encrypted_master
mysqltest: In included file "/home/buildbot/aarch64-fedora-36/build/mysql-test/suite/binlog_encryption/testdata.inc": 
included from /home/buildbot/aarch64-fedora-36/build/mysql-test/suite/binlog_encryption/encrypted_master.test at line 78:
At line 182: query 'UPDATE view_name_to_encrypt SET blob_column_name_to_encrypt = 
COLUMN_CREATE('dyncol1_name_to_encrypt',func_name_to_encrypt(0))
' failed: ER_NOT_KEYFILE (1034): Index for table 'innodb_table_name_to_encrypt' is corrupt; try to repair it
 
The result from queries just before the failure was:
< snip >
COMMIT;
END
$$
INSERT INTO myisam_table_name_to_encrypt
SELECT NULL, 'char_literal_to_encrypt', NULL, 'text_to_encrypt';
INSERT INTO myisam_table_name_to_encrypt (char_column_name_to_encrypt) 
SELECT char_column_name_to_encrypt FROM myisam_table_name_to_encrypt;
INSERT INTO myisam_table_name_to_encrypt (char_column_name_to_encrypt) 
SELECT char_column_name_to_encrypt FROM myisam_table_name_to_encrypt;
INSERT INTO myisam_table_name_to_encrypt (char_column_name_to_encrypt) 
SELECT char_column_name_to_encrypt FROM myisam_table_name_to_encrypt;
CALL proc_name_to_encrypt('file_name_to_encrypt',@useless_var_to_encrypt);
TRUNCATE TABLE aria_table_name_to_encrypt;
LOAD DATA INFILE 'file_name_to_encrypt' INTO TABLE aria_table_name_to_encrypt
(enum_column_name_to_encrypt);
LOAD DATA LOCAL INFILE '<DATADIR>/database_name_to_encrypt/file_name_to_encrypt' 
INTO TABLE aria_table_name_to_encrypt (enum_column_name_to_encrypt);
UPDATE view_name_to_encrypt SET blob_column_name_to_encrypt = 
COLUMN_CREATE('dyncol1_name_to_encrypt',func_name_to_encrypt(0))
;

Seems to mostly happen on ppc64le platforms.


Generated at Thu Feb 08 10:18:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.