| 1 |
call mtr.add_suppression("InnoDB: Table `test`\\.`t1` (has an unreadable root page|does not exist.*is trying to rename)"); |
| 2 |
call mtr.add_suppression("InnoDB: The page \\[page id: space=[1-9][0-9]*, page number=[1-9][0-9]*\\] in file '.*test.t1(new)?\\.ibd' cannot be decrypted; key_version=1"); |
| 3 |
call mtr.add_suppression("InnoDB: Recovery failed to read page"); |
| 4 |
call mtr.add_suppression("Couldn't load plugins from 'file_key_management"); |
| 5 |
call mtr.add_suppression("InnoDB: Tablespace for table \`test\`.\`t1\` is set as discarded\\."); |
| 6 |
call mtr.add_suppression("InnoDB: Failed to read page 3 from file '.*test/t1\\.ibd'"); |
| 7 |
call mtr.add_suppression("InnoDB: File '.*test/t1\\.ibd' is corrupted"); |
| 8 |
call mtr.add_suppression("Table `test`\\.`t1` is corrupted"); |
| 9 |
call mtr.add_suppression("InnoDB: Cannot delete tablespace .* because it is not found in the tablespace memory cache"); |
| 10 |
call mtr.add_suppression("InnoDB: ALTER TABLE `test`\\.`t1` DISCARD TABLESPACE failed to find tablespace"); |
| 11 |
call mtr.add_suppression("\\[ERROR\\] InnoDB: Cannot decrypt \\[page id: space="); |
| 12 |
# restart: --plugin-load-add=file_key_management --file-key-management --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt |
| 13 |
CREATE TABLE t1 (pk INT PRIMARY KEY, f VARCHAR(8)) ENGINE=InnoDB |
| 14 |
ENCRYPTED=YES ENCRYPTION_KEY_ID=4; |
| 15 |
INSERT INTO t1 VALUES (1,'foo'),(2,'bar'); |
| 16 |
# restart: --plugin-load-add=file_key_management --file-key-management --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys3.txt |
| 17 |
SELECT * FROM t1; |
| 18 |
ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 19 |
SHOW WARNINGS; |
| 20 |
Level Code Message |
| 21 |
Error 1877 Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 22 |
ALTER TABLE t1 ENGINE=InnoDB; |
| 23 |
ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 24 |
SHOW WARNINGS; |
| 25 |
Level Code Message |
| 26 |
Error 1877 Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 27 |
OPTIMIZE TABLE t1; |
| 28 |
Table Op Msg_type Msg_text |
| 29 |
test.t1 optimize Error Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 30 |
test.t1 optimize error Corrupt |
| 31 |
SHOW WARNINGS; |
| 32 |
Level Code Message |
| 33 |
CHECK TABLE t1; |
| 34 |
Table Op Msg_type Msg_text |
| 35 |
test.t1 check Error Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 36 |
test.t1 check error Corrupt |
| 37 |
SHOW WARNINGS; |
| 38 |
Level Code Message |
| 39 |
# restart: --plugin-load-add=file_key_management --file-key-management --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt |
| 40 |
FLUSH TABLES t1 FOR EXPORT; |
| 41 |
backup: t1 |
| 42 |
UNLOCK TABLES; |
| 43 |
# restart: --plugin-load-add=file_key_management --file-key-management --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys3.txt |
| 44 |
ALTER TABLE t1 DISCARD TABLESPACE; |
| 45 |
ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 46 |
DROP TABLE t1; |
| 47 |
CREATE TABLE t1 (pk INT PRIMARY KEY, f VARCHAR(8)) ENGINE=InnoDB |
| 48 |
ENCRYPTED=YES ENCRYPTION_KEY_ID=4; |
| 49 |
ALTER TABLE t1 DISCARD TABLESPACE; |
| 50 |
restore: t1 .ibd and .cfg files |
| 51 |
# restart: --plugin-load-add=file_key_management --file-key-management --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt |
| 52 |
ALTER TABLE t1 DISCARD TABLESPACE; |
| 53 |
Warnings: |
| 54 |
Warning 1812 Tablespace is missing for table 'test/t1' |
| 55 |
restore: t1 .ibd and .cfg files |
| 56 |
ALTER TABLE t1 IMPORT TABLESPACE; |
| 57 |
SHOW CREATE TABLE t1; |
| 58 |
Table Create Table |
| 59 |
t1 CREATE TABLE `t1` ( |
| 60 |
`pk` int(11) NOT NULL, |
| 61 |
`f` varchar(8) DEFAULT NULL, |
| 62 |
PRIMARY KEY (`pk`) |
| 63 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `ENCRYPTED`=YES `ENCRYPTION_KEY_ID`=4 |
| 64 |
# restart: --innodb-encrypt-tables --plugin-load-add=file_key_management --file-key-management --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys3.txt |
| 65 |
RENAME TABLE t1 TO t1new; |
| 66 |
ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 67 |
ALTER TABLE t1 RENAME TO t1new; |
| 68 |
ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate. |
| 69 |
DROP TABLE t1; |