Debian Codegraph @

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

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating local configuration file for keyring component: component_keyring_file
4 # Creating manifest file for current MySQL server instance
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 # START : WITHOUT KEYRING
8
9 #########
10 # SETUP #
11 #########
12 # Taking backup of local manifest file for MySQL server instance
13 CREATE TABLESPACE encrypt_ts ADD DATAFILE 'encrypt_ts.ibd' ENGINE=InnoDB ENCRYPTION="N";
14 CREATE TABLE t1(c1 char(100)) ENGINE=InnoDB TABLESPACE encrypt_ts;
15 set global innodb_buf_flush_list_now = 1;
16 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
17 NAME ENCRYPTION
18 encrypt_ts N
19 SELECT * FROM t1 LIMIT 10;
20 c1
21 SOME VALUES
22 SOME VALUES
23 SOME VALUES
24 SOME VALUES
25 SOME VALUES
26 SOME VALUES
27 SOME VALUES
28 SOME VALUES
29 SOME VALUES
30 SOME VALUES
31 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
32 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
33 #-------------------------- TEST 1 -------------------------------------#
34 # RESTART 1 : WITH KEYRING
35 # Restore local manifest file for MySQL server instance from backup
36 ########################################################################
37 # ALTER TABLESPACE : Unencrypted => Encrypted #
38 ########################################################################
39 # Set process to crash at page 10
40 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
41 # Encrypt the tablespace. It will cause crash.
42 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
43 # RESTART 2 : WITH KEYRING PLUGIN after crash and cause resume operation
44 # to crash just before flushing page 0 at the end
45 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
46 Got one of the listed errors
47 # Search the pattern in error log
48 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
49 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" not found
50 # RESTART 3 : Normal. In this restart resume operation should finish successfully
51 # Wait for Encryption processing to finish in background thread
52 # Search the pattern in error log
53 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
54 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" found
55 SELECT * FROM t1 LIMIT 10;
56 c1
57 SOME VALUES
58 SOME VALUES
59 SOME VALUES
60 SOME VALUES
61 SOME VALUES
62 SOME VALUES
63 SOME VALUES
64 SOME VALUES
65 SOME VALUES
66 SOME VALUES
67 ########################################################################
68 # ALTER TABLESPACE : Encrypted => Unencrypted #
69 ########################################################################
70 # Set process to crash at page 10
71 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
72 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
73 NAME ENCRYPTION
74 encrypt_ts Y
75 # Unencrypt the tablespace. It will cause crash.
76 ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
77 # RESTART 4 : WITH KEYRING PLUGIN after crash and cause resume operation
78 # to crash just before flushing page 0 at the end
79 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
80 Got one of the listed errors
81 # Search the pattern in error log
82 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
83 Pattern "Finished DECRYPTION for tablespace encrypt_ts" not found
84 # RESTART 5 : Normal. In this restart resume operation should finish successfully
85 # Wait for Encryption processing to finish in background thread
86 # Search the pattern in error log
87 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
88 Pattern "Finished DECRYPTION for tablespace encrypt_ts" found
89 # RESTART 6 : WITHOUT KEYRING PLUGIN
90 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
91 NAME ENCRYPTION
92 encrypt_ts N
93 SELECT * FROM t1 LIMIT 10;
94 c1
95 SOME VALUES
96 SOME VALUES
97 SOME VALUES
98 SOME VALUES
99 SOME VALUES
100 SOME VALUES
101 SOME VALUES
102 SOME VALUES
103 SOME VALUES
104 SOME VALUES
105 #-------------------------- TEST 2 -------------------------------------#
106 # RESTART 7 : WITH KEYRING
107 ########################################################################
108 # ALTER TABLESPACE : Unencrypted => Encrypted #
109 ########################################################################
110 # Set process to crash at page 10
111 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
112 # Encrypt the tablespace. It will cause crash.
113 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
114 # RESTART 8 : WITH KEYRING PLUGIN after crash and cause resume operation
115 # to crash just after flushing page 0 at the end
116 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
117 Got one of the listed errors
118 # Search the pattern in error log
119 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
120 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" not found
121 # RESTART 9 : Normal. In this restart resume operation should finish successfully
122 # Wait for Encryption processing to finish in background thread
123 # Search the pattern in error log
124 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
125 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" found
126 SELECT * FROM t1 LIMIT 10;
127 c1
128 SOME VALUES
129 SOME VALUES
130 SOME VALUES
131 SOME VALUES
132 SOME VALUES
133 SOME VALUES
134 SOME VALUES
135 SOME VALUES
136 SOME VALUES
137 SOME VALUES
138 ########################################################################
139 # ALTER TABLESPACE : Encrypted => Unencrypted #
140 ########################################################################
141 # Set process to crash at page 10
142 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
143 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
144 NAME ENCRYPTION
145 encrypt_ts Y
146 # Unencrypt the tablespace. It will cause crash.
147 ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
148 # RESTART 10 : WITH KEYRING PLUGIN after crash and cause resume operation
149 # to crash just after flushing page 0 at the end
150 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
151 Got one of the listed errors
152 # Search the pattern in error log
153 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
154 Pattern "Finished DECRYPTION for tablespace encrypt_ts" not found
155 # RESTART 11 : Normal. In this restart resume operation should finish successfully
156 # Wait for Encryption processing to finish in background thread
157 # Search the pattern in error log
158 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
159 Pattern "Finished DECRYPTION for tablespace encrypt_ts" found
160 # RESTART 12 : WITHOUT KEYRING PLUGIN
161 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
162 NAME ENCRYPTION
163 encrypt_ts N
164 SELECT * FROM t1 LIMIT 10;
165 c1
166 SOME VALUES
167 SOME VALUES
168 SOME VALUES
169 SOME VALUES
170 SOME VALUES
171 SOME VALUES
172 SOME VALUES
173 SOME VALUES
174 SOME VALUES
175 SOME VALUES
176 #-------------------------- TEST 3 -------------------------------------#
177 # RESTART 13 : WITH KEYRING
178 ########################################################################
179 # ALTER TABLESPACE : Unencrypted => Encrypted #
180 ########################################################################
181 # Set process to crash at page 10
182 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
183 # Encrypt the tablespace. It will cause crash.
184 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
185 # RESTART 14 : WITH KEYRING PLUGIN after crash and cause resume operation
186 # to crash just before resetting_progress on page 0
187 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
188 Got one of the listed errors
189 # Search the pattern in error log
190 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
191 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" not found
192 # RESTART 15 : Normal. In this restart resume operation should finish successfully
193 # Wait for Encryption processing to finish in background thread
194 # Search the pattern in error log
195 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
196 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" found
197 SELECT * FROM t1 LIMIT 10;
198 c1
199 SOME VALUES
200 SOME VALUES
201 SOME VALUES
202 SOME VALUES
203 SOME VALUES
204 SOME VALUES
205 SOME VALUES
206 SOME VALUES
207 SOME VALUES
208 SOME VALUES
209 ########################################################################
210 # ALTER TABLESPACE : Encrypted => Unencrypted #
211 ########################################################################
212 # Set process to crash at page 10
213 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
214 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
215 NAME ENCRYPTION
216 encrypt_ts Y
217 # Unencrypt the tablespace. It will cause crash.
218 ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
219 # RESTART 16 : WITH KEYRING PLUGIN after crash and cause resume operation
220 # to crash just before resetting_progress on page 0
221 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
222 Got one of the listed errors
223 # Search the pattern in error log
224 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
225 Pattern "Finished DECRYPTION for tablespace encrypt_ts" not found
226 # RESTART 17 : Normal. In this restart resume operation should finish successfully
227 # Wait for Encryption processing to finish in background thread
228 # Search the pattern in error log
229 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
230 Pattern "Finished DECRYPTION for tablespace encrypt_ts" found
231 # RESTART 18 : WITHOUT KEYRING PLUGIN
232 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
233 NAME ENCRYPTION
234 encrypt_ts N
235 SELECT * FROM t1 LIMIT 10;
236 c1
237 SOME VALUES
238 SOME VALUES
239 SOME VALUES
240 SOME VALUES
241 SOME VALUES
242 SOME VALUES
243 SOME VALUES
244 SOME VALUES
245 SOME VALUES
246 SOME VALUES
247 #-------------------------- TEST 4 -------------------------------------#
248 # RESTART 19 : WITH KEYRING
249 # Encrypt the tablespace.
250 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
251 ########################################################################
252 # ALTER TABLESPACE : Encrypted => Unencrypted #
253 ########################################################################
254 # Set process to crash at page 10
255 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
256 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
257 NAME ENCRYPTION
258 encrypt_ts Y
259 # Unencrypt the tablespace. It will cause crash.
260 ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
261 # RESTART 20 : WITH KEYRING PLUGIN after crash and cause resume operation
262 # to crash just before updating flags
263 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
264 Got one of the listed errors
265 # Search the pattern in error log
266 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
267 Pattern "Finished DECRYPTION for tablespace encrypt_ts" not found
268 # RESTART 21 : Normal. In this restart resume operation should finish successfully
269 # Wait for Encryption processing to finish in background thread
270 # Search the pattern in error log
271 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
272 Pattern "Finished DECRYPTION for tablespace encrypt_ts" found
273 # RESTART 22 : WITHOUT KEYRING PLUGIN
274 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
275 NAME ENCRYPTION
276 encrypt_ts N
277 SELECT * FROM t1 LIMIT 10;
278 c1
279 SOME VALUES
280 SOME VALUES
281 SOME VALUES
282 SOME VALUES
283 SOME VALUES
284 SOME VALUES
285 SOME VALUES
286 SOME VALUES
287 SOME VALUES
288 SOME VALUES
289 #-------------------------- TEST 5 -------------------------------------#
290 # RESTART 23 : WITH KEYRING
291 ########################################################################
292 # ALTER TABLESPACE : Unencrypted => Encrypted #
293 ########################################################################
294 # Set process to crash at page 10
295 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
296 # Encrypt the tablespace. It will cause crash.
297 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
298 # RESTART 24 : WITH KEYRING PLUGIN after crash and cause resume operation
299 # to crash just before encryption processing is started
300 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
301 Got one of the listed errors
302 # Search the pattern in error log
303 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
304 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" not found
305 # RESTART 25 : Normal. In this restart resume operation should finish successfully
306 # Wait for Encryption processing to finish in background thread
307 # Search the pattern in error log
308 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
309 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" found
310 SELECT * FROM t1 LIMIT 10;
311 c1
312 SOME VALUES
313 SOME VALUES
314 SOME VALUES
315 SOME VALUES
316 SOME VALUES
317 SOME VALUES
318 SOME VALUES
319 SOME VALUES
320 SOME VALUES
321 SOME VALUES
322 ########################################################################
323 # ALTER TABLESPACE : Encrypted => Unencrypted #
324 ########################################################################
325 # Set process to crash at page 10
326 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
327 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
328 NAME ENCRYPTION
329 encrypt_ts Y
330 # Unencrypt the tablespace. It will cause crash.
331 ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
332 # RESTART 26 : WITH KEYRING PLUGIN after crash and cause resume operation
333 # to crash just before encryption processing is started
334 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
335 Got one of the listed errors
336 # Search the pattern in error log
337 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
338 Pattern "Finished DECRYPTION for tablespace encrypt_ts" not found
339 # RESTART 27 : Normal. In this restart resume operation should finish successfully
340 # Wait for Encryption processing to finish in background thread
341 # Search the pattern in error log
342 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
343 Pattern "Finished DECRYPTION for tablespace encrypt_ts" found
344 # RESTART 28 : WITHOUT KEYRING PLUGIN
345 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
346 NAME ENCRYPTION
347 encrypt_ts N
348 SELECT * FROM t1 LIMIT 10;
349 c1
350 SOME VALUES
351 SOME VALUES
352 SOME VALUES
353 SOME VALUES
354 SOME VALUES
355 SOME VALUES
356 SOME VALUES
357 SOME VALUES
358 SOME VALUES
359 SOME VALUES
360 #-------------------------- TEST 6 -------------------------------------#
361 # RESTART 29 : WITH KEYRING
362 ########################################################################
363 # ALTER TABLESPACE : Unencrypted => Encrypted #
364 ########################################################################
365 # Set process to crash at page 10
366 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
367 # Encrypt the tablespace. It will cause crash.
368 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
369 # RESTART 30 : WITH KEYRING PLUGIN after crash and cause resume operation
370 # to crash just after encryption processing is finished
371 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
372 Got one of the listed errors
373 # Search the pattern in error log
374 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
375 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" not found
376 # RESTART 31 : Normal. In this restart resume operation should finish successfully
377 # Wait for Encryption processing to finish in background thread
378 # Search the pattern in error log
379 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
380 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" found
381 SELECT * FROM t1 LIMIT 10;
382 c1
383 SOME VALUES
384 SOME VALUES
385 SOME VALUES
386 SOME VALUES
387 SOME VALUES
388 SOME VALUES
389 SOME VALUES
390 SOME VALUES
391 SOME VALUES
392 SOME VALUES
393 ########################################################################
394 # ALTER TABLESPACE : Encrypted => Unencrypted #
395 ########################################################################
396 # Set process to crash at page 10
397 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
398 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
399 NAME ENCRYPTION
400 encrypt_ts Y
401 # Unencrypt the tablespace. It will cause crash.
402 ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
403 # RESTART 32 : WITH KEYRING PLUGIN after crash and cause resume operation
404 # to crash just after encryption processing is finished
405 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
406 Got one of the listed errors
407 # Search the pattern in error log
408 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
409 Pattern "Finished DECRYPTION for tablespace encrypt_ts" not found
410 # RESTART 33 : Normal. In this restart resume operation should finish successfully
411 # Wait for Encryption processing to finish in background thread
412 # Search the pattern in error log
413 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
414 Pattern "Finished DECRYPTION for tablespace encrypt_ts" found
415 # RESTART 34 : WITHOUT KEYRING PLUGIN
416 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
417 NAME ENCRYPTION
418 encrypt_ts N
419 SELECT * FROM t1 LIMIT 10;
420 c1
421 SOME VALUES
422 SOME VALUES
423 SOME VALUES
424 SOME VALUES
425 SOME VALUES
426 SOME VALUES
427 SOME VALUES
428 SOME VALUES
429 SOME VALUES
430 SOME VALUES
431 #-------------------------- TEST 7 -------------------------------------#
432 # RESTART 35 : WITH KEYRING
433 ########################################################################
434 # ALTER TABLESPACE : Unencrypted => Encrypted #
435 ########################################################################
436 # Set process to crash at page 10
437 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
438 # Encrypt the tablespace. It will cause crash.
439 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
440 # RESTART 36 : WITH KEYRING PLUGIN after crash and cause resume operation
441 # to crash just after inserting DDL Log Entry
442 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
443 Got one of the listed errors
444 # Search the pattern in error log
445 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
446 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" not found
447 # RESTART 37 : Normal. In this restart resume operation should finish successfully
448 # Wait for Encryption processing to finish in background thread
449 # Search the pattern in error log
450 Pattern "Resuming ENCRYPTION for tablespace encrypt_ts" found
451 Pattern "Finished ENCRYPTION for tablespace encrypt_ts" found
452 SELECT * FROM t1 LIMIT 10;
453 c1
454 SOME VALUES
455 SOME VALUES
456 SOME VALUES
457 SOME VALUES
458 SOME VALUES
459 SOME VALUES
460 SOME VALUES
461 SOME VALUES
462 SOME VALUES
463 SOME VALUES
464 ########################################################################
465 # ALTER TABLESPACE : Encrypted => Unencrypted #
466 ########################################################################
467 # Set process to crash at page 10
468 SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
469 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
470 NAME ENCRYPTION
471 encrypt_ts Y
472 # Unencrypt the tablespace. It will cause crash.
473 ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
474 # RESTART 38 : WITH KEYRING PLUGIN after crash and cause resume operation
475 # to crash just after inserting DDL Log Entry
476 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
477 Got one of the listed errors
478 # Search the pattern in error log
479 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
480 Pattern "Finished DECRYPTION for tablespace encrypt_ts" not found
481 # RESTART 39 : Normal. In this restart resume operation should finish successfully
482 # Wait for Encryption processing to finish in background thread
483 # Search the pattern in error log
484 Pattern "Resuming DECRYPTION for tablespace encrypt_ts" found
485 Pattern "Finished DECRYPTION for tablespace encrypt_ts" found
486 # RESTART 40 : WITHOUT KEYRING PLUGIN
487 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
488 NAME ENCRYPTION
489 encrypt_ts N
490 SELECT * FROM t1 LIMIT 10;
491 c1
492 SOME VALUES
493 SOME VALUES
494 SOME VALUES
495 SOME VALUES
496 SOME VALUES
497 SOME VALUES
498 SOME VALUES
499 SOME VALUES
500 SOME VALUES
501 SOME VALUES
502 ###########
503 # Cleanup #
504 ###########
505 DROP TABLE t1;
506 DROP TABLESPACE encrypt_ts;
507 # RESTART 41 : final
508 # ----------------------------------------------------------------------
509 # Teardown
510 # Removing manifest file for current MySQL server instance
511 # Removing local keyring file for keyring component: component_keyring_file
512 # Removing local configuration file for keyring component: component_keyring_file
513 # Restarting server without the manifest file
514 # ----------------------------------------------------------------------