Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2
-
None
Description
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;
|