Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5166

Rotated key encryption MTR omissions

    XMLWordPrintable

    Details

      Description

      181216 17:11:17 [ 36%] innodb.innodb_scrub_background           w3 [ fail ]
              Test ended at 2018-12-16 17:11:17
      
      Result file '/tmp/results/PS/mysql-test/suite/innodb/r/innodb_scrub_background.result' doesn't exist.
      Either create a result file or disable check-testcases and run the test case. Use --nocheck-testcases option to disable check-testcases.
      
      181216 17:32:29 [ 59%] innodb.innodb_scrub                      w2 [ fail ]
              Test ended at 2018-12-16 17:32:29
      
      CURRENT_TEST: innodb.innodb_scrub
      --- /tmp/results/PS/mysql-test/suite/innodb/r/innodb_scrub.result	2018-12-16 18:08:17.000000000 +0300
      +++ /tmp/results/PS/mysql-test/var/2/log/innodb_scrub.reject	2018-12-16 20:32:28.888252470 +0300
      @@ -1,6 +1,12 @@
       select * from performance_schema.global_status
       where variable_name like 'innodb_scrub_background%';
       VARIABLE_NAME	VARIABLE_VALUE
      +Innodb_scrub_background_page_reorganizations	0
      +Innodb_scrub_background_page_splits	0
      +Innodb_scrub_background_page_split_failures_underflow	0
      +Innodb_scrub_background_page_split_failures_out_of_filespace	0
      +Innodb_scrub_background_page_split_failures_missing_index	0
      +Innodb_scrub_background_page_split_failures_unknown	0
       # FIXME: Add index(b) to each table; ensure that undo logs are scrubbed.
       # see MDEV-8139 for details
       create table delete_3 (
      @@ -119,4 +125,8 @@
       drop table delete_0, delete_rollback_delete_0, insert_rollback_0;
       show variables like 'innodb_%scrub_data%';
       Variable_name	Value
      +innodb_background_scrub_data_check_interval	3600
      +innodb_background_scrub_data_compressed	OFF
      +innodb_background_scrub_data_interval	604800
      +innodb_background_scrub_data_uncompressed	OFF
       innodb_immediate_scrub_data_uncompressed	ON
      
      mysqltest: Result content mismatch
      
      181216 20:03:01 [ 61%] main.all_persisted_variables             w3 [ fail ]
              Test ended at 2018-12-16 20:03:01
      
      CURRENT_TEST: main.all_persisted_variables
      mysqltest: At line 80: Query 'SET GLOBAL $var_name = @@global.$var_name' failed with wrong error 1231: 'Variable 'innodb_default_encryption_key_id' can't be set to the value of '0'', should have failed with any of '0,1238,1210' errors.
      
      The result from queries just before the failure was:
      ***********************************************************************
      * Run only on debug build,non-windows as few server variables are not
      * available on all platforms.
      ***********************************************************************
      ***************************************************************
      * 0. Verify that variables present in performance_schema.global
      * variables are actually global variables and can be set using
      * SET GLOBAL
      ***************************************************************
      CREATE TABLE global_vars (id INT PRIMARY KEY AUTO_INCREMENT, var_name VARCHAR(64), var_value VARCHAR(1024));
      INSERT INTO global_vars (var_name, var_value) SELECT * FROM
      performance_schema.global_variables WHERE variable_name NOT IN
      ('innodb_monitor_enable',
      'innodb_monitor_disable',
      'innodb_monitor_reset',
      'innodb_monitor_reset_all',
      'rbr_exec_mode');
      safe_process[10039]: Child process: 10040, exit: 1
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              zsolt.parragi Zsolt Parragi
              Reporter:
              laurynas.biveinis Laurynas Biveinis (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: