Debian Codegraph @

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

raw
1 --echo #
2 --echo # 35289234 - Can't disable encryption once redo log encryption is enabled
3 --echo #
4
5 --source include/no_valgrind_without_big.inc
6 --source include/have_innodb_max_16k.inc
7
8 --disable_query_log
9 call mtr.add_suppression("\\[Warning\\] .* Ignoring tablespace .* because it could not be opened");
10 call mtr.add_suppression("\\[Error\\] .* Encryption can't find master key, please check the keyring plugin is loaded.");
11 call mtr.add_suppression("\\[ERROR\\] .* Failed to find tablespace for table `\.\.*`\.`\.\.*` in the cache.");
12 call mtr.add_suppression("\\[ERROR\\] .* Operating system error number 2 in a file operation.");
13 call mtr.add_suppression("\\[ERROR\\] .* The error means the system cannot find the path specified.");
14 call mtr.add_suppression("\\[ERROR\\] .* Could not find a valid tablespace file for");
15 call mtr.add_suppression("\\[ERROR\\] .* If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.");
16 call mtr.add_suppression("\\[ERROR\\] .* Can't set redo log files to be encrypted.");
17 --enable_query_log
18
19 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
20
21 SHOW CREATE TABLE t1;
22
23 INSERT INTO t1 VALUES(0, "aaaaa");
24 INSERT INTO t1 VALUES(1, "bbbbb");
25 INSERT INTO t1 VALUES(2, "ccccc");
26 INSERT INTO t1 VALUES(3, "ddddd");
27 INSERT INTO t1 VALUES(4, "eeeee");
28 INSERT INTO t1 VALUES(5, "fffff");
29 INSERT INTO t1 VALUES(6, "ggggg");
30 INSERT INTO t1 VALUES(7, "hhhhh");
31 INSERT INTO t1 VALUES(8, "iiiii");
32 INSERT INTO t1 VALUES(9, "jjjjj");
33 INSERT INTO t1 select * from t1;
34 INSERT INTO t1 select * from t1;
35 INSERT INTO t1 select * from t1;
36 INSERT INTO t1 select * from t1;
37 INSERT INTO t1 select * from t1;
38 INSERT INTO t1 select * from t1;
39
40 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
41
42 SET GLOBAL innodb_redo_log_encrypt=OFF;
43 --source include/shutdown_innodb_clean.inc
44
45 #Remove the key ring file
46 --remove_file $MYSQL_TMP_DIR/mysecret_keyring1
47
48
49 # Restart with no encryption
50 let $restart_parameters = restart:--innodb_redo_log_encrypt=OFF;
51 --source include/start_mysqld.inc
52
53 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
54 DROP TABLE t1;
55
56 --let $restart_parameters = restart:
57 --source include/restart_mysqld.inc
58