Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30712

binlog_encryption.encrypted_master sometimes fails with ER_NOT_KEYFILE error

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            angelique.sklavounos Angelique Sklavounos (Inactive)
            angelique.sklavounos Angelique Sklavounos (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.