Debian Codegraph @

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

raw
1 # InnoDB transparent encryption on redo log and undo log
2 # This test case will test basic encryption support with
3 # concuurent execution and
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('Error in Log_event::read_log_event()');
10 --enable_query_log
11
12 # Create a table with encryption, should fail since keyring is not
13 # loaded
14
15 let $old_innodb_file_per_table = `SELECT @@innodb_file_per_table`;
16 let $old_innodb_redo_log_encrypt = `SELECT @@innodb_redo_log_encrypt`;
17 let $START_PAGE_SIZE= `select @@innodb_page_size`;
18 let $LOG_CAPACITY= `select @@innodb_redo_log_capacity`;
19 let $MYSQLD_BASEDIR= `select @@basedir`;
20
21 let SEARCH_FILE= $MYSQL_TMP_DIR/encrypt_log_output.err;
22
23 # Test that the output appears.
24 let $restart_parameters = restart: --no-console --log-error=$SEARCH_FILE ;
25 --replace_result $SEARCH_FILE ERROR_LOG_FILE
26 --source include/restart_mysqld.inc
27
28 SELECT @@global.innodb_redo_log_encrypt ;
29 SET GLOBAL innodb_redo_log_encrypt = 1;
30 SET GLOBAL innodb_undo_log_encrypt = 1;
31
32 --let $wait_condition=SELECT @@global.innodb_redo_log_encrypt = 0
33 --source include/wait_condition.inc
34
35 --error ER_SP_DOES_NOT_EXIST
36 UNINSTALL PLUGIN keyring_file;
37
38 # Create Non encrypt table with innodb_redo_log_encrypt=ON
39 CREATE TABLE tne_1(c1 INT, c2 varchar(2000)) ENGINE = InnoDB;
40 INSERT INTO tne_1 VALUES (1,REPEAT('a',1990)),(2,REPEAT('b',1990)),(100,REPEAT('c',1990));
41 SELECT c1,LEFT(c2,10) FROM tne_1;
42 DROP TABLE tne_1;
43 --echo # Stop the MTR default DB server
44 --source include/shutdown_mysqld.inc
45
46 # Grep for message in server error log
47 let SEARCH_PATTERN=Can\'t set redo log files to be encrypted;
48 --source include/search_pattern.inc
49
50 # Create path for ibdata* & undo* files both DBs
51 --mkdir $MYSQL_TMP_DIR/innodb_undo_data_dir
52 --mkdir $MYSQL_TMP_DIR/datadir
53 # Set path for --datadir
54 let $MYSQLD_DATADIR_1 = $MYSQL_TMP_DIR/datadir/data;
55 # Set path for undo* files.
56 let $MYSQLD_UNDO_DATADIR = $MYSQL_TMP_DIR/innodb_undo_data_dir;
57 let BOOTSTRAP_SQL=$MYSQL_TMP_DIR/boot.sql;
58 --echo # create bootstrap file
59 write_file $BOOTSTRAP_SQL;
60 CREATE DATABASE test;
61 EOF
62
63 --echo # Prepare new datadir
64 let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_page_size=$START_PAGE_SIZE --innodb_undo_directory=$MYSQLD_UNDO_DATADIR --basedir=$MYSQLD_BASEDIR --datadir=$MYSQLD_DATADIR_1 --init-file=$BOOTSTRAP_SQL --secure-file-priv="" --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT </dev/null>>$MYSQLTEST_VARDIR/tmp/bootstrap2.log 2>&1;
65
66 --echo # Run the bootstrap command with keyring
67 --exec $NEW_CMD
68
69 --echo # Starting server with keyring plugin
70 --let $restart_parameters=restart: --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_page_size=$START_PAGE_SIZE --innodb_undo_directory=$MYSQLD_UNDO_DATADIR --datadir=$MYSQLD_DATADIR_1 --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT
71 --replace_regex /\.dll/.so/
72 --source include/start_mysqld_no_echo.inc
73
74
75
76 SELECT @@global.innodb_redo_log_encrypt;
77 SET GLOBAL innodb_redo_log_encrypt = 1;
78 SELECT @@global.innodb_undo_log_encrypt;
79 SET GLOBAL innodb_undo_log_encrypt = 1;
80 SELECT @@global.innodb_undo_log_encrypt;
81 --replace_regex /\.dll/.so/
82 --error ER_UDF_EXISTS
83 eval INSTALL PLUGIN keyring_file SONAME '$KEYRING_PLUGIN';
84
85 SET GLOBAL innodb_redo_log_encrypt = 0;
86 SELECT @@global.innodb_redo_log_encrypt;
87 SET GLOBAL innodb_undo_log_encrypt = 0;
88 SELECT @@global.innodb_undo_log_encrypt;
89 --replace_regex /\.dll/.so/
90 --error ER_UDF_EXISTS
91 eval INSTALL PLUGIN keyring_file SONAME '$KEYRING_PLUGIN';
92
93 --disable_warnings
94 DROP TABLE IF EXISTS t1;
95 DROP DATABASE IF EXISTS tde_db;
96 CREATE DATABASE tde_db;
97 USE tde_db;
98 --enable_warnings
99
100 let $innodb_file_per_table = `SELECT @@innodb_file_per_table`;
101
102 # Create a table with encryption
103 CREATE TABLE tde_db.t_encrypt(c2 INT NOT NULL PRIMARY KEY,
104 c3 LONGBLOB
105 ) ENCRYPTION="Y" ENGINE = InnoDB;
106
107 CREATE TABLE tde_db.t_non_encrypt(c2 INT NOT NULL PRIMARY KEY,
108 c3 LONGBLOB
109 ) ENGINE = InnoDB;
110
111
112 DELIMITER |;
113 CREATE PROCEDURE tde_db.populate_table_set_redo_encrypt(IN table_name VARCHAR(50))
114 begin
115 declare i int default 1;
116 declare has_error int default 0;
117 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
118 while (i <= 2000) DO
119
120 SET @sql_text = CONCAT('INSERT INTO ',table_name, '(c2,c3) VALUES (' , i,',' ,'CONCAT(REPEAT("a",6*512*512)))');
121 PREPARE stmt FROM @sql_text;
122 EXECUTE stmt;
123 set i = i + 1;
124 IF i%10 = 0 THEN SET GLOBAL innodb_redo_log_encrypt = 1;
125 END IF;
126 IF i%20 = 0 THEN SET GLOBAL innodb_redo_log_encrypt = 0;
127 END IF;
128 IF i%15 = 0 THEN SET GLOBAL innodb_undo_log_encrypt = 1;
129 END IF;
130 IF i%30 = 0 THEN SET GLOBAL innodb_undo_log_encrypt = 0;
131 END IF;
132
133 end while;
134 end|
135 CREATE PROCEDURE tde_db.update_table(IN table_name VARCHAR(50))
136 begin
137 declare i int default 1;
138 declare has_error int default 0;
139 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
140 while (i <= 2000) DO
141 SET @sql_text = CONCAT('UPDATE ',table_name, ' SET c2 = c2 * -1 ORDER BY RAND() LIMIT 2');
142 PREPARE stmt FROM @sql_text;
143 EXECUTE stmt;
144 set i = i + 1;
145 end while;
146 end|
147 CREATE PROCEDURE tde_db.delete_table(IN table_name VARCHAR(50))
148 begin
149 declare i int default 1;
150 declare has_error int default 0;
151 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
152 while (i <= 2000) DO
153 SET @sql_text = CONCAT('DELETE FROM ',table_name, ' ORDER BY RAND() LIMIT 2');
154 PREPARE stmt FROM @sql_text;
155 EXECUTE stmt;
156 set i = i + 1;
157 end while;
158 end|
159 CREATE PROCEDURE tde_db.transaction_table(IN table_name VARCHAR(50))
160 begin
161 declare i int default 1;
162 declare iflag int default -1;
163 declare has_error int default 0;
164 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
165 SET i = 3000;
166 START TRANSACTION;
167 while (i <= 9000) DO
168 SET @sql_text = CONCAT('INSERT INTO ',table_name, '(c2,c3) VALUES (' , i,',' ,'CONCAT(REPEAT("a",6*512*512)))');
169 PREPARE stmt FROM @sql_text;
170 EXECUTE stmt;
171 SET @sql_text = CONCAT('UPDATE ',table_name, ' SET c2 = c2 * -1 ORDER BY RAND() LIMIT 2');
172 PREPARE stmt FROM @sql_text;
173 EXECUTE stmt;
174 set i = i + 1;
175 IF i%10 = 0 THEN SET GLOBAL innodb_redo_log_encrypt = 1;
176 END IF;
177 IF i%20 = 0 THEN SET GLOBAL innodb_redo_log_encrypt = 0;
178 END IF;
179 IF i%15 = 0 THEN SET GLOBAL innodb_undo_log_encrypt = 1;
180 END IF;
181 IF i%30 = 0 THEN SET GLOBAL innodb_undo_log_encrypt = 0;
182 END IF;
183
184 IF i%10 = 0 THEN
185 SET @sql_text = CONCAT('DELETE FROM ',table_name, ' ORDER BY RAND() LIMIT 2');
186 PREPARE stmt FROM @sql_text;
187 EXECUTE stmt;
188 START TRANSACTION;
189 SET iflag = -1 * iflag;
190 END IF;
191 IF i%9 = 0 THEN
192 IF iflag < 0 THEN
193 COMMIT;
194 ELSE
195 ROLLBACK;
196 END IF;
197 END IF;
198 end while;
199 end|
200 CREATE PROCEDURE tde_db.create_table_rotate_key()
201 begin
202 declare i int default 1;
203 declare has_error int default 0;
204 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
205 while (i <= 2000) DO
206
207 IF i%10 = 0 THEN
208 SET @sql_text = CONCAT('CREATE TABLE ',CONCAT('tde_db.t_non_encrypt_',encrypt,'_',i),' (c1 INT) ' ,' ENGINE=InnoDB');
209 ELSE
210 SET @sql_text = CONCAT('CREATE TABLE ',CONCAT('tde_db.t_encrypt_',encrypt,'_',i),' (c1 INT) ENCRYPTION="Y"' ,' ENGINE=InnoDB');
211 END IF;
212 PREPARE stmt FROM @sql_text;
213 EXECUTE stmt;
214 DEALLOCATE PREPARE stmt;
215 ALTER INSTANCE ROTATE INNODB MASTER KEY;
216 set i = i + 1;
217 end while;
218 end|
219 CREATE PROCEDURE tde_db.query_table(IN table_name VARCHAR(50))
220 begin
221 declare i int default 1;
222 declare has_error int default 0;
223 DECLARE CONTINUE HANDLER FOR 1062 SET has_error = 1;
224 while (i <= 2000) DO
225 SET @sql_text = CONCAT('SELECT * FROM ',table_name, ' ORDER BY RAND() LIMIT 2');
226 PREPARE stmt FROM @sql_text;
227 EXECUTE stmt;
228 set i = i + 1;
229 end while;
230 end|
231 DELIMITER ;|
232
233 --echo # In connection con1 - Running insert with redo_log_encrypt variable
234 connect (con1,localhost,root,,);
235 send call tde_db.populate_table_set_redo_encrypt('tde_db.t_encrypt');
236
237 --echo # In connection con2 - Running insert on non encrypt table
238 connect (con2,localhost,root,,);
239 send call tde_db.populate_table_set_redo_encrypt('tde_db.t_non_encrypt');
240
241
242 --connection default
243 --sleep 3
244 --echo # Starting server with keyring plugin
245 let $restart_parameters = restart: --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_page_size=$START_PAGE_SIZE --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT --innodb_undo_directory=$MYSQLD_UNDO_DATADIR --datadir=$MYSQLD_DATADIR_1;
246 --sleep 3
247 --let $_server_id= `SELECT @@server_id`
248 --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/mysqld.$_server_id.expect
249 --exec echo "$restart_parameters" > $_expect_file_name
250 --shutdown_server 0
251 --source include/wait_until_disconnected.inc
252 --enable_reconnect
253 --source include/wait_until_connected_again.inc
254 --disable_reconnect
255
256
257 --disconnect con1
258 --disconnect con2
259 --connection default
260
261 --replace_column 1 #
262 SELECT COUNT(*)>0 FROM tde_db.t_encrypt;
263 --replace_column 1 #
264 SELECT COUNT(*)>0 FROM tde_db.t_non_encrypt;
265
266 DELETE FROM tde_db.t_encrypt;
267 DELETE FROM tde_db.t_non_encrypt;
268
269 --echo # In connection con1 - Running insert with redo_log_encrypt variable
270 connect (con1,localhost,root,,);
271 send call tde_db.populate_table_set_redo_encrypt('tde_db.t_encrypt');
272
273 --echo # In connection con2 - Running insert on non encrypt table
274 connect (con2,localhost,root,,);
275 send call tde_db.populate_table_set_redo_encrypt('tde_db.t_non_encrypt');
276
277 --echo # In connection con3 - Running update on encrypt
278 connect (con3,localhost,root,,);
279 send call tde_db.table_update('tde_db.t_encrypt');
280 --echo # In connection con4 - Running update non encrypt
281 connect (con4,localhost,root,,);
282 send call tde_db.table_update('tde_db.t_non_encrypt');
283 --echo # In connection con5 - Running delete on encrypt
284 connect (con5,localhost,root,,);
285 send call tde_db.table_delete('tde_db.t_encrypt');
286 --echo # In connection con6 - Running delete on non encrypt
287 connect (con6,localhost,root,,);
288 send call tde_db.table_delete('tde_db.t_non_encrypt');
289 --echo # In connection con7 - Running transaction on encrypt
290 connect (con7,localhost,root,,);
291 send call tde_db.transaction_table('tde_db.t_encrypt');
292 --echo # In connection con8 - Running transaction on non encrypt
293 connect (con8,localhost,root,,);
294 send call tde_db.transaction_table('tde_db.t_non_encrypt');
295 --echo # In connection con9 - Running create encrypt and non encrypt table with rotate key
296 connect (con9,localhost,root,,);
297 send call tde_db.create_table_rotate_key();
298 --echo # In connection con10 - Running query on encrypt table
299 connect (con10,localhost,root,,);
300 send call tde_db.query_table('tde_db.t_encrypt');
301 --echo # In connection con11 - Running query on non encrypt table
302 connect (con11,localhost,root,,);
303 send call tde_db.query_table('tde_db.t_non_encrypt');
304
305 --connection default
306 --sleep 20
307 --echo # Starting server with keyring plugin
308 let $restart_parameters = restart: --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_page_size=$START_PAGE_SIZE --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT --innodb_undo_directory=$MYSQLD_UNDO_DATADIR --datadir=$MYSQLD_DATADIR_1;
309 --let $_server_id= `SELECT @@server_id`
310 --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/mysqld.$_server_id.expect
311 --exec echo "$restart_parameters" > $_expect_file_name
312 --shutdown_server 0
313 --source include/wait_until_disconnected.inc
314 --enable_reconnect
315 --source include/wait_until_connected_again.inc
316 --disable_reconnect
317
318 --disconnect con1
319 --disconnect con2
320 --disconnect con3
321 --disconnect con4
322 --disconnect con5
323 --disconnect con6
324 --disconnect con7
325 --disconnect con8
326 --disconnect con9
327 --disconnect con10
328 --disconnect con11
329
330 --connection default
331 --replace_column 1 #
332 SELECT COUNT(*) > 1 FROM tde_db.t_encrypt;
333 --replace_column 1 #
334 SELECT COUNT(*) > 1 FROM tde_db.t_non_encrypt;
335
336 # Run some load insert retart
337 --echo # In connection con1 - Running insert with redo_log_encrypt variable
338 connect (con1,localhost,root,,);
339 send call tde_db.populate_table_set_redo_encrypt('tde_db.t_encrypt');
340
341 --echo # In connection con2 - Running insert on non encrypt table
342 connect (con2,localhost,root,,);
343 send call tde_db.populate_table_set_redo_encrypt('tde_db.t_non_encrypt');
344
345 --sleep 2
346 --disconnect con1
347 --disconnect con2
348 --connection default
349 DROP DATABASE tde_db;
350
351 # restart the server with MTR default
352 --let $restart_parameters=
353 --source include/restart_mysqld.inc
354
355 --echo #
356 --echo # Cleanup
357 --echo #
358 --remove_file $MYSQLTEST_VARDIR/tmp/bootstrap2.log
359 --remove_file $MYSQL_TMP_DIR/mysecret_keyring
360 --remove_file $BOOTSTRAP_SQL
361 --remove_file $SEARCH_FILE
362 --force-rmdir $MYSQL_TMP_DIR/datadir
363 --force-rmdir $MYSQL_TMP_DIR/innodb_undo_data_dir
364
365 --disable_query_log
366 eval SET GLOBAL innodb_file_per_table=$old_innodb_file_per_table;
367 eval SET GLOBAL innodb_redo_log_encrypt=$old_innodb_redo_log_encrypt;
368 --enable_query_log
369