Debian Codegraph @

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

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