Debian Codegraph @

mysql-test/suite/innodb_undo/t/encrypt_explicit.test

raw
1 --echo #
2 --echo # wl9508: Show that explicit and implicit undo tablespaces can be encrypted.
3 --echo #
4
5 --source include/have_innodb_16k.inc
6
7 let $MYSQLD_BASEDIR= `select @@basedir`;
8 let $MYSQLD_OLD_DATADIR = `select @@datadir`;
9
10 use test;
11 CREATE table tab1(c1 int);
12
13 --mkdir $MYSQL_TMP_DIR/log_encrypt_dir1
14
15 let $MYSQLD_DATADIR1 = $MYSQL_TMP_DIR/log_encrypt_dir1;
16
17 let BOOTSTRAP_SQL=$MYSQL_TMP_DIR/boot.sql;
18
19 --echo # create bootstrap file
20 write_file $BOOTSTRAP_SQL;
21 CREATE DATABASE test;
22 EOF
23
24 --echo # Stop the MTR default DB server
25 --source include/shutdown_mysqld.inc
26
27 let NEW_CMD = $MYSQLD --no-defaults --initialize-insecure --basedir=$MYSQLD_BASEDIR --datadir=$MYSQLD_DATADIR1 --init-file=$BOOTSTRAP_SQL --secure-file-priv="" </dev/null>>$MYSQLTEST_VARDIR/tmp/bootstrap1.log 2>&1;
28
29 --echo # Run the bootstrap command of datadir1
30 --exec $NEW_CMD
31
32 --let $restart_parameters="restart: --log_error_verbosity=3 --datadir=$MYSQLD_DATADIR1 --early-plugin-load="keyring_file=$KEYRING_PLUGIN" $KEYRING_PLUGIN_OPT --keyring_file_data=$MYSQL_TMP_DIR/my_keyfile --innodb_undo_log_encrypt=1 --innodb_redo_log_encrypt=1"
33 --source include/start_mysqld_no_echo.inc
34
35 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
36 SELECT @@datadir;
37
38 --replace_result $MYSQL_TMP_DIR key_file
39 SHOW VARIABLES LIKE 'keyring_file%';
40
41 SELECT @@innodb_undo_log_encrypt;
42
43 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
44 CREATE DATABASE nath;
45 use nath;
46 CREATE TABLE tab2(c1 int , c2 varchar(10)) Engine=InnoDB ENCRYPTION='Y';
47 INSERT INTO tab2 VALUES(2, 'VISH');
48 CREATE INDEX ix2 ON tab2(c2) ;
49
50 # Assertion failure: space_id == page_get_space_id(buf_block_get_frame(block))
51 # during wl9508 testing
52 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
53
54 # Check ALTER and DROP with encrypt undo tablespaces
55 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
56 let $inactive_undo_space = undo_003;
57 source include/wait_until_undo_space_is_empty.inc;
58
59 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
60 let $inactive_undo_space = undo_004;
61 source include/wait_until_undo_space_is_empty.inc;
62
63 DELETE FROM tab2;
64 DROP UNDO TABLESPACE undo_003;
65 DROP UNDO TABLESPACE undo_004;
66 DROP TABLE tab2;
67 DROP DATABASE nath;
68
69 --echo # Stop the encrypt server
70 --let $shutdown_server_timeout= 300
71 --source include/shutdown_mysqld.inc
72
73 # Restart with MTR default server
74 --let $wait_counter= 3000
75 --replace_result $MYSQLD_OLD_DATADIR OLD_DATADIR
76 --let $restart_parameters="restart: --datadir=$MYSQLD_OLD_DATADIR"
77 --source include/start_mysqld.inc
78
79 --replace_result $MYSQLD_OLD_DATADIR MYSQLD_OLD_DATADIR
80 SELECT @@datadir;
81
82 use test;
83
84 # clean up
85 DROP TABLE tab1;
86 --remove_file $MYSQL_TMP_DIR/my_keyfile
87 --remove_file $MYSQLTEST_VARDIR/tmp/bootstrap1.log
88 --force-rmdir $MYSQL_TMP_DIR/log_encrypt_dir1
89
90 --echo #
91 --echo # bug#29006275 : ENCRYPTION MASTER KEY IS GENERATED WITH BLANK UUID
92 --echo #
93
94 LET $MYSQL_DATA_DIR = `select @@datadir`;
95
96 --echo # Stop the non-encrypted server
97 --source include/shutdown_mysqld.inc
98
99 let NEW_CMD = $MYSQLD --no-defaults --initialize-insecure --basedir=$MYSQLD_BASEDIR --datadir=$MYSQLD_DATADIR1 --init-file=$BOOTSTRAP_SQL --secure-file-priv="" </dev/null>>$MYSQLTEST_VARDIR/tmp/bootstrap2.log 2>&1;
100
101 --echo # Run the bootstrap command of datadir1
102 --exec $NEW_CMD
103
104 --let $restart_parameters="restart: --log_error_verbosity=3 --datadir=$MYSQLD_DATADIR1 --early-plugin-load="keyring_file=$KEYRING_PLUGIN" $KEYRING_PLUGIN_OPT --keyring_file_data=$MYSQL_TMP_DIR/my_keyfile --innodb_undo_log_encrypt=1"
105 --source include/start_mysqld_no_echo.inc
106
107 --echo # Show that a master key with a blank Server UUID is not used.
108 SELECT * FROM performance_schema.keyring_keys where KEY_ID='INNODBKey--1';
109
110 --echo # Stop the encrypted server
111 --source include/shutdown_mysqld.inc
112
113 # Restart with MTR default server
114 --let $wait_counter= 3000
115 --replace_result $MYSQLD_OLD_DATADIR OLD_DATADIR
116 --let $restart_parameters="restart:"
117 --source include/start_mysqld.inc
118
119 --remove_file $MYSQL_TMP_DIR/my_keyfile
120 --remove_file $MYSQL_TMP_DIR/boot.sql
121 --remove_file $MYSQLTEST_VARDIR/tmp/bootstrap2.log
122 --force-rmdir $MYSQL_TMP_DIR/log_encrypt_dir1