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

        1. mysqld.1.err.9
          1.87 MB
          Angelique Sklavounos
        2. mysqld.2.err.9
          422 kB
          Angelique Sklavounos

        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.