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

InnoDB skips the tablespace in rotation list

    XMLWordPrintable

    Details

      Description

      In two cases, InnoDB unnecessary skips the tablespaces from the rotation list.
      case 1: All tablespace are unencrypted tables but it needs encryption (crypt_data initialization)
      case 2: Changing innodb_encrypt_tables when background thread iterates through one
      of the tablespace in rotation list.

      The following test case can repeat the scenario for Case 1 :

      -- source include/have_innodb.inc
      -- source include/not_embedded.inc
      -- source include/have_example_key_management_plugin.inc
       
      set global innodb_encrypt_tables=0;
      CREATE TABLE t1 (f1 INT, f2 VARCHAR(256))engine=innodb;
      INSERT INTO t1 VALUES(1, 'MariaDB'), (2, 'Robot'), (3, 'Science');
      INSERT INTO t1 SELECT * FROM t1;
       
      CREATE TABLE t2(f1 INT, f2 VARCHAR(256))engine=innodb;
      INSERT INTO t2 SELECT * FROM t1;
       
      let $restart_parameters=--innodb_encrypt_tables=1;
      --source include/restart_mysqld.inc
       
      set global innodb_encrypt_tables=1;
       
      SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
      NAME
      innodb_system
       
      SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
      NAME
      drop table t2, t1;
      
      

      case 2: As of now, I found out by reading the code. I can write the clumsy test case to repeat it. I will post the test case soon.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: