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

encryption.innodb_encryption_discard_import failed in buildbot, error 192 'Table encrypted but decryption failed, sporadic

    XMLWordPrintable

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/6973/steps/test/logs/stdio

      encryption.innodb_encryption_discard_import 'innodb' w1 [ fail ]
              Test ended at 2017-10-11 09:02:47
       
      CURRENT_TEST: encryption.innodb_encryption_discard_import
      mysqltest: At line 113: query 'SELECT COUNT(1) FROM t3' failed: 1296: Got error 192 'Table encrypted but decryption failed. This could be because correct encryption management plugin is not loaded, used encryption key is not available or encryption method does not match.' from InnoDB
       
      The result from queries just before the failure was:
      < snip >
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      ALTER TABLE t3 ENGINE InnoDB;
      SHOW CREATE TABLE t3;
      Table	Create Table
      t3	CREATE TABLE `t3` (
        `id` int(11) NOT NULL,
        `a` varchar(255) DEFAULT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED `encrypted`=yes
      # Restarting server
      # Done restarting server
      # Verify that tables are still usable
      SELECT COUNT(1) FROM t1;
      COUNT(1)
      10000
      SELECT COUNT(1) FROM t2;
      COUNT(1)
      10000
      SELECT COUNT(1) FROM t3;
      

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.