Debian Codegraph @

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

raw
1 ################################################################################
2 # InnoDB transparent tablespace data encryption for mysql tablespace.
3 # For mysql tablespace, this test will test
4 # 1 - Normal alter encryption
5 # - encryption='y' to encryption='n'
6 # - encryption='n' to encryption='y'
7 # 2 - Crash during altering mysql tablespace encryption
8 # - encryption='y' to encryption='n'
9 # - encryption='n' to encryption='y'
10 # 3 - Crash
11 # - just before encryption processing starts
12 # - just after encryption processing finishes
13 # 4 - Crash during master key rotation
14 # 5 - Privilege check
15 ################################################################################
16
17 --source include/big_test.inc
18 --source include/have_debug.inc
19 # Disable in valgrind because of timeout, cf. Bug#22760145
20 --source include/not_valgrind.inc
21 # Waiting time when (re)starting the server
22 --let $explicit_default_wait_counter=10000
23
24 --disable_query_log
25 call mtr.add_suppression("\\[Warning\\] \\[MY-013674\\] \\[InnoDB\\] Decrypting a page in doublewrite file failed: space_id=");
26 call mtr.add_suppression("\\[Warning\\] \\[MY-013675\\] \\[InnoDB\\] Encryption key missing: space_id=");
27 --enable_query_log
28
29 --echo
30 --echo #############################################################
31 --echo # TEST 1 : NORMAL ALTER ENCRYPT mysql TABLESPACE.
32 --echo #############################################################
33 --echo
34 --echo #########################################################################
35 --echo # RESTART 1 : WITH KEYRING PLUGIN
36 --echo #########################################################################
37 let $restart_parameters = restart: --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT;
38 --source include/restart_mysqld_no_echo.inc
39 SET debug='+d,skip_dd_table_access_check';
40
41 --echo # Initially, mysql should be unencrypted by default
42 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
43 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
44
45 ALTER TABLESPACE mysql ENCRYPTION='Y';
46 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
47 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
48
49 ALTER TABLESPACE mysql ENCRYPTION='N';
50 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
51 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
52
53 --echo
54 --echo #############################################################
55 --echo # TEST 2 : CRASH DURING ALTER ENCRYPT mysql TABLESPACE.
56 --echo #############################################################
57 --echo
58 --echo ############################################################
59 --echo # ALTER TABLESPACE 1 : Unencrypted => Encrypted #
60 --echo # (crash at page 10) #
61 --echo ############################################################
62 --echo # Set Encryption process to crash at page 10
63 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
64
65 --echo # Encrypt the tablespace. It will cause crash.
66 --source include/expect_crash.inc
67 --error 0,CR_SERVER_LOST,ER_INTERNAL_ERROR
68 ALTER TABLESPACE mysql ENCRYPTION='Y';
69 --echo # Restart after crash
70 --source include/start_mysqld_no_echo.inc
71 SET debug='+d,skip_dd_table_access_check';
72
73 --echo # Wait for Encryption processing to finish in background thread
74 let $wait_condition = SELECT ENCRYPTION = 'Y'
75 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
76 WHERE NAME='mysql';
77 --source include/wait_condition.inc
78
79 # Make sure ts file is updated with new records in table
80 set global innodb_buf_flush_list_now = 1;
81
82 --echo # After restart/recovery, check that Encryption was roll-forward
83 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
84 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
85
86 # Try to do encryption one more time (dummy). Should not do anything.
87 ALTER TABLESPACE mysql ENCRYPTION='Y';
88 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
89 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
90
91 --echo #########################################################################
92 --echo # RESTART 2 : WITH KEYRING PLUGIN
93 --echo #########################################################################
94 let $restart_parameters = restart: --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT;
95 --source include/restart_mysqld_no_echo.inc
96 SET debug='+d,skip_dd_table_access_check';
97
98 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
99 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
100
101 --echo ############################################################
102 --echo # ALTER TABLESPACE 2 : Encrypted => Unencrypted #
103 --echo # (crash at page 10) #
104 --echo ############################################################
105 --echo # Set Unencryption process to crash at page 10
106 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
107
108 --echo # Unencrypt the tablespace. It will cause crash.
109 --source include/expect_crash.inc
110 --error 0,CR_SERVER_LOST,ER_INTERNAL_ERROR
111 ALTER TABLESPACE mysql ENCRYPTION='N';
112 --echo # Restart after crash
113 --source include/start_mysqld_no_echo.inc
114 SET debug='+d,skip_dd_table_access_check';
115
116 --echo # Wait for Unencryption processing to finish in background thread
117 let $wait_condition = SELECT ENCRYPTION = 'N'
118 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
119 WHERE NAME='mysql';
120 --source include/wait_condition.inc
121
122 # Make sure ts file is updated with new records in table
123 set global innodb_buf_flush_list_now = 1;
124
125 --echo # After restart/recovery, check that Unencryption was roll-forward
126 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
127 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
128
129 # Try to do unencryption one more time (dummy). Should not do anything.
130 ALTER TABLESPACE mysql ENCRYPTION='N';
131 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
132 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
133
134 --echo #########################################################################
135 --echo # RESTART 3 : WITHOUT KEYRING PLUGIN
136 --echo #########################################################################
137 let $restart_parameters = restart:;
138 --source include/restart_mysqld_no_echo.inc
139 SET debug='+d,skip_dd_table_access_check';
140
141 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
142 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
143
144 --echo #############################################################
145 --echo # TEST 3 : CRASH BEFORE/AFTER ENCRYPTION PROCESSING.
146 --echo #############################################################
147 --echo
148 --echo #########################################################################
149 --echo # RESTART 4 : WITH KEYRING PLUGIN
150 --echo #########################################################################
151 let $restart_parameters = restart: --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT;
152 --source include/restart_mysqld_no_echo.inc
153 SET debug='+d,skip_dd_table_access_check';
154
155 # Encrypt tablespace
156 ALTER TABLESPACE mysql ENCRYPTION='Y';
157 # Read rows from table
158 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
159
160 --echo # Set server to crash just before encryption processing starts
161 SET SESSION debug="+d,alter_encrypt_tablespace_crash_before_processing";
162
163 --echo # Unencrypt the tablespace. It will cause crash.
164 --source include/expect_crash.inc
165 --error 0,CR_SERVER_LOST,ER_INTERNAL_ERROR
166 ALTER TABLESPACE mysql ENCRYPTION='N';
167 --echo # Restart after crash
168 --source include/start_mysqld_no_echo.inc
169 SET debug='+d,skip_dd_table_access_check';
170
171 --echo # Wait for Unencryption processing to finish in background thread
172 let $wait_condition = select count(*) = 0
173 from performance_schema.events_stages_current
174 where EVENT_NAME='stage/innodb/alter tablespace (encryption)';
175 --source include/wait_condition.inc
176
177 # Encrytion property of tablespace shouldn't have changed i.e. it should still
178 # be encrypted.
179 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
180 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
181
182
183 --echo # Set server to crash just after encryption processing finishes
184 SET SESSION debug="-d,alter_encrypt_tablespace_crash_before_processing";
185 SET SESSION debug="+d,alter_encrypt_tablespace_crash_after_processing";
186
187 --echo # Unencrypt the tablespace. It will cause crash.
188 --source include/expect_crash.inc
189 --error 0,CR_SERVER_LOST,ER_INTERNAL_ERROR
190 ALTER TABLESPACE mysql ENCRYPTION='N';
191 --echo # Restart after crash
192 --source include/start_mysqld_no_echo.inc
193 SET debug='+d,skip_dd_table_access_check';
194
195 --echo # Wait for Unencryption processing to finish in background thread
196 let $wait_condition = select count(*) = 0
197 from performance_schema.events_stages_current
198 where EVENT_NAME='stage/innodb/alter tablespace (encryption)';
199 --source include/wait_condition.inc
200
201 # Encrytion property of tablespace should have changed i.e. it should be
202 # unencrypted now.
203 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql';
204 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
205
206 --echo #############################################################
207 --echo # TEST 4 : CRASH DURING KEY ROTATION.
208 --echo #############################################################
209 --echo
210 --echo #########################################################################
211 --echo # RESTART 5 : WITH KEYRING PLUGIN
212 --echo #########################################################################
213 let $restart_parameters = restart: --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT;
214 --source include/restart_mysqld_no_echo.inc
215 SET debug='+d,skip_dd_table_access_check';
216
217 # Encrypt tablespace
218 ALTER TABLESPACE mysql ENCRYPTION='Y';
219 # Read rows from table
220 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
221
222 --echo # Set server to crash while rotating encryption
223 SET SESSION debug="+d,ib_crash_during_rotation_for_encryption";
224
225 # Rotate the key. It will cause server to crash.
226 --source include/expect_crash.inc
227 --error 0,CR_SERVER_LOST,ER_INTERNAL_ERROR
228 ALTER INSTANCE ROTATE INNODB MASTER KEY;
229
230 --echo # Restart after crash
231 --source include/start_mysqld_no_echo.inc
232 SET debug='+d,skip_dd_table_access_check';
233 # Read rows from table
234 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
235
236 # Rotate the key.
237 SET SESSION debug="-d,ib_crash_during_rotation_for_encryption";
238 ALTER INSTANCE ROTATE INNODB MASTER KEY;
239 # Read rows from table
240 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
241
242 --echo #############################################################
243 --echo # TEST 5 : PRIVILEGE CHECK.
244 --echo #############################################################
245 --echo
246
247 CREATE DATABASE priv_test;
248 CREATE USER myuser@'localhost';
249 GRANT ALL ON priv_test.* TO myuser@'localhost';
250
251 --echo #connection con1
252 --connect(con1,localhost,myuser,,priv_test)
253 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
254 ALTER TABLESPACE mysql ENCRYPTION='Y';
255
256 --disconnect con1
257 --source include/wait_until_disconnected.inc
258
259 --echo #connection default
260 --connection default
261 --error ER_WRONG_USAGE
262 GRANT CREATE TABLESPACE ON mysql.* TO myuser@'localhost';
263 GRANT CREATE TABLESPACE ON *.* TO myuser@'localhost';
264
265 --echo #connection con1
266 --connect(con1,localhost,myuser,,priv_test)
267 ALTER TABLESPACE mysql ENCRYPTION='N';
268
269 --echo #connection default
270 --connection default
271 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
272
273 --echo #connection con1
274 --connection con1
275 ALTER TABLESPACE mysql ENCRYPTION='Y';
276
277 --echo #connection default
278 --connection default
279 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
280
281 --disconnect con1
282 DROP DATABASE priv_test;
283 DROP USER myuser@localhost;
284
285 --echo ###########
286 --echo # Cleanup #
287 --echo ###########
288 # Unencrypt tablespace
289 ALTER TABLESPACE mysql ENCRYPTION='N';
290
291 SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql';
292 remove_file $MYSQL_TMP_DIR/mysecret_keyring;
293
294 --echo #########################################################################
295 --echo # RESTART 6 : WITHOUT KEYRING PLUGIN
296 --echo #########################################################################
297 let $restart_parameters = restart: ;
298 --source include/restart_mysqld.inc