Debian Codegraph @

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

raw
1 ################################################################################
2 # Test script to test UNDO tablespace encryption setting to be displayed in
3 # INFORMATION_SCHEMA.INNODB_TABLESPACES.
4 ################################################################################
5
6 --source include/have_debug.inc
7
8 # Note:
9 # Due to encrypt options used below its not possible to return to clean
10 # state: create and use separate datadir for this test
11
12 --echo #
13 --echo # Bug #31467626 : SERVER CRASH OBSERVED AT ROTATE_INNODB_MASTER_KEY
14 --echo #
15
16 let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err;
17 let $MYSQL_DATA_DIR = `select @@datadir`;
18
19 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
20
21 --let $INNODB_FILE_PER_TABLE= `SELECT @@innodb_file_per_table`
22 --let $PAGE_SIZE= `select @@innodb_page_size`
23 --let $LOG_SIZE= `select @@innodb_redo_log_capacity`
24
25 --let $MYSQL_ENC_DATADIR= $MYSQL_TMP_DIR/undo_tablespace_encrypt_dir
26 --mkdir $MYSQL_ENC_DATADIR
27
28 --let $BOOTSTRAP_LOG= $MYSQL_TMP_DIR/bootstrap_encrypt.log
29
30 --let $BOOTSTRAP_SQL= $MYSQL_TMP_DIR/boot.sql
31 --write_file $BOOTSTRAP_SQL
32 CREATE DATABASE test;
33 EOF
34
35 --source include/shutdown_mysqld.inc
36 --source include/wait_until_disconnected.inc
37
38 --let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --innodb_redo_log_capacity=$LOG_SIZE --innodb_page_size=$PAGE_SIZE --datadir=$MYSQL_ENC_DATADIR --init-file=$BOOTSTRAP_SQL --secure-file-priv="" >>$BOOTSTRAP_LOG 2>&1
39 --exec $NEW_CMD
40
41 --echo ###############################################################################
42 --echo # With keyring plugin and innodb_undo_log_encrypt=ON
43 --echo ###############################################################################
44 --let $restart_parameters="restart: --datadir=$MYSQL_ENC_DATADIR --log_error_verbosity=3 --early-plugin-load="keyring_file=$KEYRING_PLUGIN" $KEYRING_PLUGIN_OPT --keyring_file_data=$MYSQL_TMP_DIR/my_keyfile --innodb_undo_log_encrypt=ON --log-error=$MYSQLTEST_VARDIR/log/mysqld.1.err "
45 --source include/start_mysqld_no_echo.inc
46
47 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
48
49 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
50 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
51 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
52 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
53
54 CREATE DATABASE crypt;
55 DROP PROCEDURE IF EXISTS crypt.rotate_and_truncate;
56 DELIMITER |;
57 CREATE PROCEDURE crypt.rotate_and_truncate(IN start BIGINT)
58 BEGIN
59 SET @idx = start;
60 SET global innodb_undo_log_encrypt=ON;
61 WHILE (@idx > 0) DO
62 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
63 ALTER UNDO TABLESPACE undo_004 SET ACTIVE;
64 ALTER INSTANCE ROTATE INNODB MASTER KEY;
65 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
66 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
67 SET @idx = @idx - 1;
68 END WHILE;
69 END|
70 DELIMITER ;|
71
72 call crypt.rotate_and_truncate(50);
73
74 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
75 ALTER UNDO TABLESPACE undo_004 SET ACTIVE;
76
77 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
78
79 --echo #
80 --echo # Make sure the rotation code recovers when
81 --echo # one of the tables cannot be rotated.
82 --echo #
83 SET SESSION DEBUG="+d,ib_encryption_rotate_skip";
84 ALTER INSTANCE ROTATE INNODB MASTER KEY;
85 SET SESSION DEBUG="-d,ib_encryption_rotate_skip";
86 let SEARCH_PATTERN = ib_encryption_rotate_skip;
87 --source include/search_pattern.inc
88
89 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
90
91 ALTER INSTANCE ROTATE INNODB MASTER KEY;
92 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
93
94 --echo #
95 --echo # Get the UNDO tablespaces ready to drop
96 --echo #
97 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
98 let $inactive_undo_space = undo_003;
99 source include/wait_until_undo_space_is_empty.inc;
100
101 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
102
103 --echo #
104 --echo # Be sure that undo tablespaces can be dropped when a concurrent
105 --echo # ENCRYPTION ROTATE is occurring
106 --echo #
107
108 --echo # Start and pause a ROTATE INNODB MASTER KEY in a second thread
109 connect (con2,localhost,root);
110 SET DEBUG_SYNC='ib_pause_encryption_rotate SIGNAL rotate_paused WAIT_FOR rotate_go';
111 # This ROTATE thread will get an exclusive backup lock and wait.
112 --send ALTER INSTANCE ROTATE INNODB MASTER KEY
113
114 connection default;
115 SET DEBUG_SYNC='now WAIT_FOR rotate_paused';
116
117 --echo # In a third thread, try to drop an undo tablespace
118 connect (con3,localhost,root);
119 # This command should wait for a shared backup lock
120 --send DROP UNDO TABLESPACE undo_003
121
122 --echo # In a fourth thread, try to set an undo tablespace inactive
123 --echo # which would cause the purge thread to truncate it.
124 connect (con4,localhost,root);
125 # This command should wait for a shared backup lock.
126 --send ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
127
128 --echo # Switch to the default thread and check that the DDL are waiting
129 connection default;
130 --sleep 2
131
132 # This log message should NOT be found because the thread is
133 # waiting on the ROTATE thread which has an exclusive backup lock
134 let SEARCH_PATTERN = Dropped undo tablespace 'undo_003';
135 --source include/search_pattern.inc
136
137 # This should show that 'undo_004 is still active.
138 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
139
140 --echo # Resume the ROTATE thread.
141 SET DEBUG_SYNC='now SIGNAL rotate_go';
142
143 --echo # Reap the other three threads.
144 connection con2;
145 --reap
146 connection con3;
147 --reap
148 connection con4;
149 --reap
150
151 --echo # Return to the default thread and disconnect the other three.
152 connection default;
153 disconnect con2;
154 disconnect con3;
155 disconnect con4;
156
157 --echo #
158 --echo # Cleanup
159 --echo #
160 let $inactive_undo_space = undo_004;
161 source include/wait_until_undo_space_is_empty.inc;
162 DROP UNDO TABLESPACE undo_004;
163 DROP PROCEDURE crypt.rotate_and_truncate;
164 DROP DATABASE crypt;
165
166 --echo # Reset to initial state
167 --let $restart_parameters="restart:"
168 --source include/restart_mysqld.inc
169
170 # Now these log message should be found.
171 # The 'Encryption' message should occur in the log before the 'Dropped' messages.
172 let SEARCH_PATTERN = The InnoDB Encryption Master Key has been rotated;
173 --source include/search_pattern.inc
174 let SEARCH_PATTERN = Dropped undo tablespace 'undo_003';
175 --source include/search_pattern.inc
176 let SEARCH_PATTERN = Dropped undo tablespace 'undo_004';
177 --source include/search_pattern.inc
178
179 --remove_file $MYSQL_TMP_DIR/my_keyfile
180 --remove_file $BOOTSTRAP_LOG
181 --remove_file $BOOTSTRAP_SQL
182 --force-rmdir $MYSQL_ENC_DATADIR