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

encryption.innodb_encryption_filekeys failed in buildbot with Unknown column 'ENCRYPTION_SHCEME' (but should have failed with timeout)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.2
    • N/A
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/1848/steps/mtr/logs/stdio

      encryption.innodb_encryption_filekeys 'cbc,innodb' w2 [ fail ]
              Test ended at 2018-03-09 16:56:34
       
      CURRENT_TEST: encryption.innodb_encryption_filekeys
      mysqltest: At line 85: query 'SELECT NAME,ENCRYPTION_SHCEME,MIN_KEY_VERSION, ROTATING_OR_FLUSHING FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION' failed: 1054: Unknown column 'ENCRYPTION_SHCEME' in 'field list'
       
      The result from queries just before the failure was:
      < snip >
      CREATE TABLE t3 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=NO;
      CREATE TABLE t4 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=4;
      SET GLOBAL innodb_encrypt_tables = on;
      # Wait max 10 min for key encryption threads to encrypt required all spaces
      # Success!
      SELECT COUNT(1) FROM t1;
      COUNT(1)
      10
      SELECT COUNT(1) FROM t2;
      COUNT(1)
      10
      SELECT COUNT(1) FROM t3;
      COUNT(1)
      10
      SELECT COUNT(1) FROM t4;
      COUNT(1)
      10
      SET GLOBAL innodb_encrypt_tables = off;
      # Wait max 10 min for key encryption threads to decrypt all required spaces
      SELECT NAME,ENCRYPTION_SHCEME,MIN_KEY_VERSION, ROTATING_OR_FLUSHING FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION;
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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