Debian Codegraph @

mysql-test/suite/innodb/r/log_encrypt_kill.result

raw
1 # restart: --no-console --log-error=ERROR_LOG_FILE
2 SELECT @@global.innodb_redo_log_encrypt ;
3 @@global.innodb_redo_log_encrypt
4 0
5 SET GLOBAL innodb_redo_log_encrypt = 1;
6 SET GLOBAL innodb_undo_log_encrypt = 1;
7 UNINSTALL PLUGIN keyring_file;
8 ERROR 42000: PLUGIN keyring_file does not exist
9 CREATE TABLE tne_1(c1 INT, c2 varchar(2000)) ENGINE = InnoDB;
10 INSERT INTO tne_1 VALUES (1,REPEAT('a',1990)),(2,REPEAT('b',1990)),(100,REPEAT('c',1990));
11 SELECT c1,LEFT(c2,10) FROM tne_1;
12 c1 LEFT(c2,10)
13 1 aaaaaaaaaa
14 2 bbbbbbbbbb
15 100 cccccccccc
16 DROP TABLE tne_1;
17 # Stop the MTR default DB server
18 Pattern "Can\'t set redo log files to be encrypted" found
19 # create bootstrap file
20 # Prepare new datadir
21 # Run the bootstrap command with keyring
22 # Starting server with keyring plugin
23 SELECT @@global.innodb_redo_log_encrypt;
24 @@global.innodb_redo_log_encrypt
25 0
26 SET GLOBAL innodb_redo_log_encrypt = 1;
27 SELECT @@global.innodb_undo_log_encrypt;
28 @@global.innodb_undo_log_encrypt
29 0
30 SET GLOBAL innodb_undo_log_encrypt = 1;
31 SELECT @@global.innodb_undo_log_encrypt;
32 @@global.innodb_undo_log_encrypt
33 1
34 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
35 ERROR HY000: Function 'keyring_file' already exists
36 SET GLOBAL innodb_redo_log_encrypt = 0;
37 SELECT @@global.innodb_redo_log_encrypt;
38 @@global.innodb_redo_log_encrypt
39 0
40 SET GLOBAL innodb_undo_log_encrypt = 0;
41 SELECT @@global.innodb_undo_log_encrypt;
42 @@global.innodb_undo_log_encrypt
43 0
44 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
45 ERROR HY000: Function 'keyring_file' already exists
46 DROP TABLE IF EXISTS t1;
47 DROP DATABASE IF EXISTS tde_db;
48 CREATE DATABASE tde_db;
49 USE tde_db;
50 CREATE TABLE tde_db.t_encrypt(c2 INT NOT NULL PRIMARY KEY,
51 c3 LONGBLOB
52 ) ENCRYPTION="Y" ENGINE = InnoDB;
53 CREATE TABLE tde_db.t_non_encrypt(c2 INT NOT NULL PRIMARY KEY,
54 c3 LONGBLOB
55 ) ENGINE = InnoDB;
56 CREATE PROCEDURE tde_db.populate_table_set_redo_encrypt(IN table_name VARCHAR(50))
57 begin
58 declare i int default 1;
59 declare has_error int default 0;
60 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
61 while (i <= 2000) DO
62 SET @sql_text = CONCAT('INSERT INTO ',table_name, '(c2,c3) VALUES (' , i,',' ,'CONCAT(REPEAT("a",6*512*512)))');
63 PREPARE stmt FROM @sql_text;
64 EXECUTE stmt;
65 set i = i + 1;
66 IF i%10 = 0 THEN SET GLOBAL innodb_redo_log_encrypt = 1;
67 END IF;
68 IF i%20 = 0 THEN SET GLOBAL innodb_redo_log_encrypt = 0;
69 END IF;
70 IF i%15 = 0 THEN SET GLOBAL innodb_undo_log_encrypt = 1;
71 END IF;
72 IF i%30 = 0 THEN SET GLOBAL innodb_undo_log_encrypt = 0;
73 END IF;
74 end while;
75 end|
76 CREATE PROCEDURE tde_db.update_table(IN table_name VARCHAR(50))
77 begin
78 declare i int default 1;
79 declare has_error int default 0;
80 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
81 while (i <= 2000) DO
82 SET @sql_text = CONCAT('UPDATE ',table_name, ' SET c2 = c2 * -1 ORDER BY RAND() LIMIT 2');
83 PREPARE stmt FROM @sql_text;
84 EXECUTE stmt;
85 set i = i + 1;
86 end while;
87 end|
88 CREATE PROCEDURE tde_db.delete_table(IN table_name VARCHAR(50))
89 begin
90 declare i int default 1;
91 declare has_error int default 0;
92 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
93 while (i <= 2000) DO
94 SET @sql_text = CONCAT('DELETE FROM ',table_name, ' ORDER BY RAND() LIMIT 2');
95 PREPARE stmt FROM @sql_text;
96 EXECUTE stmt;
97 set i = i + 1;
98 end while;
99 end|
100 CREATE PROCEDURE tde_db.transaction_table(IN table_name VARCHAR(50))
101 begin
102 declare i int default 1;
103 declare iflag int default -1;
104 declare has_error int default 0;
105 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
106 SET i = 3000;
107 START TRANSACTION;
108 while (i <= 9000) DO
109 SET @sql_text = CONCAT('INSERT INTO ',table_name, '(c2,c3) VALUES (' , i,',' ,'CONCAT(REPEAT("a",6*512*512)))');
110 PREPARE stmt FROM @sql_text;
111 EXECUTE stmt;
112 SET @sql_text = CONCAT('UPDATE ',table_name, ' SET c2 = c2 * -1 ORDER BY RAND() LIMIT 2');
113 PREPARE stmt FROM @sql_text;
114 EXECUTE stmt;
115 set i = i + 1;
116 IF i%10 = 0 THEN SET GLOBAL innodb_redo_log_encrypt = 1;
117 END IF;
118 IF i%20 = 0 THEN SET GLOBAL innodb_redo_log_encrypt = 0;
119 END IF;
120 IF i%15 = 0 THEN SET GLOBAL innodb_undo_log_encrypt = 1;
121 END IF;
122 IF i%30 = 0 THEN SET GLOBAL innodb_undo_log_encrypt = 0;
123 END IF;
124 IF i%10 = 0 THEN
125 SET @sql_text = CONCAT('DELETE FROM ',table_name, ' ORDER BY RAND() LIMIT 2');
126 PREPARE stmt FROM @sql_text;
127 EXECUTE stmt;
128 START TRANSACTION;
129 SET iflag = -1 * iflag;
130 END IF;
131 IF i%9 = 0 THEN
132 IF iflag < 0 THEN
133 COMMIT;
134 ELSE
135 ROLLBACK;
136 END IF;
137 END IF;
138 end while;
139 end|
140 CREATE PROCEDURE tde_db.create_table_rotate_key()
141 begin
142 declare i int default 1;
143 declare has_error int default 0;
144 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
145 while (i <= 2000) DO
146 IF i%10 = 0 THEN
147 SET @sql_text = CONCAT('CREATE TABLE ',CONCAT('tde_db.t_non_encrypt_',encrypt,'_',i),' (c1 INT) ' ,' ENGINE=InnoDB');
148 ELSE
149 SET @sql_text = CONCAT('CREATE TABLE ',CONCAT('tde_db.t_encrypt_',encrypt,'_',i),' (c1 INT) ENCRYPTION="Y"' ,' ENGINE=InnoDB');
150 END IF;
151 PREPARE stmt FROM @sql_text;
152 EXECUTE stmt;
153 DEALLOCATE PREPARE stmt;
154 ALTER INSTANCE ROTATE INNODB MASTER KEY;
155 set i = i + 1;
156 end while;
157 end|
158 CREATE PROCEDURE tde_db.query_table(IN table_name VARCHAR(50))
159 begin
160 declare i int default 1;
161 declare has_error int default 0;
162 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
163 while (i <= 2000) DO
164 SET @sql_text = CONCAT('SELECT * FROM ',table_name, ' ORDER BY RAND() LIMIT 2');
165 PREPARE stmt FROM @sql_text;
166 EXECUTE stmt;
167 set i = i + 1;
168 end while;
169 end|
170 # In connection con1 - Running insert with redo_log_encrypt variable
171 call tde_db.populate_table_set_redo_encrypt('tde_db.t_encrypt');
172 # In connection con2 - Running insert on non encrypt table
173 call tde_db.populate_table_set_redo_encrypt('tde_db.t_non_encrypt');
174 # Starting server with keyring plugin
175 SELECT COUNT(*)>0 FROM tde_db.t_encrypt;
176 COUNT(*)>0
177 #
178 SELECT COUNT(*)>0 FROM tde_db.t_non_encrypt;
179 COUNT(*)>0
180 #
181 DELETE FROM tde_db.t_encrypt;
182 DELETE FROM tde_db.t_non_encrypt;
183 # In connection con1 - Running insert with redo_log_encrypt variable
184 call tde_db.populate_table_set_redo_encrypt('tde_db.t_encrypt');
185 # In connection con2 - Running insert on non encrypt table
186 call tde_db.populate_table_set_redo_encrypt('tde_db.t_non_encrypt');
187 # In connection con3 - Running update on encrypt
188 call tde_db.table_update('tde_db.t_encrypt');
189 # In connection con4 - Running update non encrypt
190 call tde_db.table_update('tde_db.t_non_encrypt');
191 # In connection con5 - Running delete on encrypt
192 call tde_db.table_delete('tde_db.t_encrypt');
193 # In connection con6 - Running delete on non encrypt
194 call tde_db.table_delete('tde_db.t_non_encrypt');
195 # In connection con7 - Running transaction on encrypt
196 call tde_db.transaction_table('tde_db.t_encrypt');
197 # In connection con8 - Running transaction on non encrypt
198 call tde_db.transaction_table('tde_db.t_non_encrypt');
199 # In connection con9 - Running create encrypt and non encrypt table with rotate key
200 call tde_db.create_table_rotate_key();
201 # In connection con10 - Running query on encrypt table
202 call tde_db.query_table('tde_db.t_encrypt');
203 # In connection con11 - Running query on non encrypt table
204 call tde_db.query_table('tde_db.t_non_encrypt');
205 # Starting server with keyring plugin
206 SELECT COUNT(*) > 1 FROM tde_db.t_encrypt;
207 COUNT(*) > 1
208 #
209 SELECT COUNT(*) > 1 FROM tde_db.t_non_encrypt;
210 COUNT(*) > 1
211 #
212 # In connection con1 - Running insert with redo_log_encrypt variable
213 call tde_db.populate_table_set_redo_encrypt('tde_db.t_encrypt');
214 # In connection con2 - Running insert on non encrypt table
215 call tde_db.populate_table_set_redo_encrypt('tde_db.t_non_encrypt');
216 DROP DATABASE tde_db;
217 # restart
218 #
219 # Cleanup
220 #