Debian Codegraph @

mysql-test/suite/encryption/r/innodb-missing-key.result

raw
1 call mtr.add_suppression("InnoDB: Table `test`\\.`t1` has an unreadable root page");
2 call mtr.add_suppression("InnoDB: The page \\[page id: space=[1-9][0-9]*, page number=[1-9][0-9]*\\] in file '.*test.t[123]\\.ibd' cannot be decrypted\\.");
3 call mtr.add_suppression("InnoDB: Recovery failed to read page");
4 call mtr.add_suppression("InnoDB: Encrypted page \\[page id: space=[1-9][0-9]*, page number=[1-9][0-9]*\\] in file .*test.t[12].ibd looks corrupted; key_version=1");
5 call mtr.add_suppression("InnoDB: Failed to read page 3 from file '.*test/t1\\.ibd'");
6 call mtr.add_suppression("InnoDB: File '.*test/t1\\.ibd' is corrupted");
7 call mtr.add_suppression("Table `test`\\.`t1` is corrupted");
8 # Start server with keys2.txt
9 # restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt
10 CREATE TABLE t1(a int not null primary key auto_increment, b varchar(128)) engine=innodb ENCRYPTED=YES ENCRYPTION_KEY_ID=19;
11 CREATE TABLE t2(a int not null primary key auto_increment, b varchar(128)) engine=innodb ENCRYPTED=YES ENCRYPTION_KEY_ID=1;
12 CREATE TABLE t3(a int not null primary key auto_increment, b varchar(128)) engine=innodb ENCRYPTED=NO;
13 INSERT INTO t1(b) VALUES ('thisissecredmessage');
14 INSERT INTO t1(b) SELECT b FROM t1;
15 INSERT INTO t1(b) SELECT b FROM t1;
16 INSERT INTO t1(b) SELECT b FROM t1;
17 INSERT INTO t1(b) SELECT b FROM t1;
18 INSERT INTO t1(b) SELECT b FROM t1;
19 INSERT INTO t1(b) SELECT b FROM t1;
20 INSERT INTO t1(b) SELECT b FROM t1;
21 INSERT INTO t1(b) SELECT b FROM t1;
22 INSERT INTO t1(b) SELECT b FROM t1;
23 INSERT INTO t1(b) SELECT b FROM t1;
24 INSERT INTO t1(b) SELECT b FROM t1;
25 INSERT INTO t2 SELECT * FROM t1;
26 INSERT INTO t3 SELECT * FROM t1;
27
28 # Restart server with keys3.txt
29 # restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys3.txt
30 set global innodb_encryption_rotate_key_age = 1;
31 use test;
32 CREATE TABLE t4(a int not null primary key auto_increment, b varchar(128)) engine=innodb ENCRYPTED=YES ENCRYPTION_KEY_ID=1;
33 SELECT SLEEP(5);
34 SLEEP(5)
35 0
36 SELECT COUNT(1) FROM t3;
37 COUNT(1)
38 2048
39 SELECT COUNT(1) FROM t2;
40 COUNT(1)
41 2048
42 SELECT COUNT(1) FROM t2,t1 where t2.a = t1.a;
43 ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate.
44 SELECT COUNT(1) FROM t1 where b = 'ab';
45 ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate.
46 SELECT COUNT(1) FROM t1;
47 ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate.
48
49 # Start server with keys2.txt
50 # restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt
51 SELECT COUNT(1) FROM t1;
52 COUNT(1)
53 2048
54 SELECT COUNT(1) FROM t2;
55 COUNT(1)
56 2048
57 SELECT COUNT(1) FROM t3;
58 COUNT(1)
59 2048
60 DROP TABLE t1, t2, t3;