Debian Codegraph @

mysql-test/suite/innodb/t/missing_redologs.test

raw
1 --source include/have_innodb_max_16k.inc
2 --source include/not_asan.inc
3 --source include/not_valgrind.inc
4
5 --echo #
6 --echo # Bug #29820184 REDO LOGS MAY SILENTLY BE IGNORED WHEN ENCRYPTED TABLE
7 --echo # CANNOT BE DECRYPTED.
8 --echo #
9
10 CREATE TABLE t1(
11 a INT NOT NULL PRIMARY KEY,
12 c CHAR(200),
13 b BLOB,
14 INDEX(b(10))) ENGINE=innodb ROW_FORMAT=compressed ENCRYPTION='Y';
15
16 CREATE TABLE t2(
17 a INT NOT NULL PRIMARY KEY,
18 c CHAR(200),
19 b BLOB,
20 INDEX(b(10))) ENGINE=innodb ROW_FORMAT=compressed ENCRYPTION='Y';
21
22 CREATE TABLE t3(
23 a INT NOT NULL PRIMARY KEY,
24 c CHAR(200),
25 b BLOB,
26 INDEX(b(10))) ENGINE=innodb ENCRYPTION='Y';
27
28 CREATE TABLE t4(
29 a INT NOT NULL PRIMARY KEY,
30 c CHAR(200),
31 b BLOB,
32 INDEX(b(10))) ENGINE=innodb ENCRYPTION='Y';
33
34 --source include/restart_mysqld.inc
35
36 --source include/no_checkpoint_start.inc
37
38 --disable_query_log
39 --let $i = 20
40 BEGIN;
41 WHILE ($i)
42 {
43 eval INSERT INTO t1(a,c,b) VALUES ($i, REPEAT('secret1',20), REPEAT('secret2',6000));
44 dec $i;
45 }
46 --enable_query_log
47
48 INSERT INTO t2 SELECT * FROM t1;
49 INSERT INTO t3 SELECT * FROM t1;
50 INSERT INTO t4 SELECT * FROM t1;
51 COMMIT;
52
53 # If checkpoint happens we will skip this test.
54 # If no checkpoint happens, InnoDB refuses to
55 # start as used encryption key is not found.
56
57 SET GLOBAL innodb_flush_log_at_trx_commit=1;
58 BEGIN;
59 UPDATE t1 SET c = REPEAT('secret3', 20);
60 UPDATE t2 SET c = REPEAT('secret4', 20);
61 UPDATE t3 set c = REPEAT('secret4', 20);
62 UPDATE t4 set c = REPEAT('secret4', 20);
63 INSERT INTO t1 (a,c,b) VALUES (21, REPEAT('secret5',20), REPEAT('secret6',6000));
64 INSERT INTO t2 (a,c,b) VALUES (21, REPEAT('secret7',20), REPEAT('secret8',6000));
65 INSERT into t3 (a,c,b) VALUES (21, REPEAT('secret9',20), REPEAT('secre10',6000));
66 INSERT into t4 (a,c,b) VALUES (21, REPEAT('secre11',20), REPEAT('secre12',6000));
67 COMMIT;
68
69 let $cleanup= drop TABLE t1,t2,t3,t4;
70 --let CLEANUP_IF_CHECKPOINT= $cleanup; --skip 'Unexpected checkpoint happened';
71 --source include/no_checkpoint_end.inc
72
73 --echo # Restart mysqld without keyring plugin
74
75 --error 1,2
76 --exec $MYSQLD_CMD
77
78 --echo # Restart mysqld with keyring plugin
79 --let $restart_parameters=restart:
80 --source include/start_mysqld_no_echo.inc
81
82 drop TABLE t1,t2,t3,t4;