Debian Codegraph @

mysql-test/suite/innodb_undo/r/undo_tablespace_encrypt_rotate.result

raw
1 #
2 # Bug #31467626 : SERVER CRASH OBSERVED AT ROTATE_INNODB_MASTER_KEY
3 #
4 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
5 Variable_name Value
6 innodb_undo_log_encrypt OFF
7 ###############################################################################
8 # With keyring plugin and innodb_undo_log_encrypt=ON
9 ###############################################################################
10 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
11 Variable_name Value
12 innodb_undo_log_encrypt ON
13 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
14 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
15 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
16 NAME SPACE_TYPE ENCRYPTION STATE
17 innodb_undo_001 Undo Y active
18 innodb_undo_002 Undo Y active
19 undo_003 Undo Y active
20 undo_004 Undo Y active
21 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
22 Variable_name Value
23 innodb_undo_log_encrypt ON
24 CREATE DATABASE crypt;
25 DROP PROCEDURE IF EXISTS crypt.rotate_and_truncate;
26 Warnings:
27 Note 1305 PROCEDURE crypt.rotate_and_truncate does not exist
28 CREATE PROCEDURE crypt.rotate_and_truncate(IN start BIGINT)
29 BEGIN
30 SET @idx = start;
31 SET global innodb_undo_log_encrypt=ON;
32 WHILE (@idx > 0) DO
33 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
34 ALTER UNDO TABLESPACE undo_004 SET ACTIVE;
35 ALTER INSTANCE ROTATE INNODB MASTER KEY;
36 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
37 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
38 SET @idx = @idx - 1;
39 END WHILE;
40 END|
41 call crypt.rotate_and_truncate(50);
42 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
43 ALTER UNDO TABLESPACE undo_004 SET ACTIVE;
44 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
45 NAME SPACE_TYPE ENCRYPTION STATE
46 innodb_undo_001 Undo Y active
47 innodb_undo_002 Undo Y active
48 undo_003 Undo Y active
49 undo_004 Undo Y active
50 #
51 # Make sure the rotation code recovers when
52 # one of the tables cannot be rotated.
53 #
54 SET SESSION DEBUG="+d,ib_encryption_rotate_skip";
55 ALTER INSTANCE ROTATE INNODB MASTER KEY;
56 SET SESSION DEBUG="-d,ib_encryption_rotate_skip";
57 Pattern "ib_encryption_rotate_skip" found
58 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
59 NAME SPACE_TYPE ENCRYPTION STATE
60 innodb_undo_001 Undo Y active
61 innodb_undo_002 Undo Y active
62 undo_003 Undo Y active
63 undo_004 Undo Y active
64 ALTER INSTANCE ROTATE INNODB MASTER KEY;
65 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
66 NAME SPACE_TYPE ENCRYPTION STATE
67 innodb_undo_001 Undo Y active
68 innodb_undo_002 Undo Y active
69 undo_003 Undo Y active
70 undo_004 Undo Y active
71 #
72 # Get the UNDO tablespaces ready to drop
73 #
74 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
75 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
76 NAME SPACE_TYPE ENCRYPTION STATE
77 innodb_undo_001 Undo Y active
78 innodb_undo_002 Undo Y active
79 undo_003 Undo Y empty
80 undo_004 Undo Y active
81 #
82 # Be sure that undo tablespaces can be dropped when a concurrent
83 # ENCRYPTION ROTATE is occurring
84 #
85 # Start and pause a ROTATE INNODB MASTER KEY in a second thread
86 SET DEBUG_SYNC='ib_pause_encryption_rotate SIGNAL rotate_paused WAIT_FOR rotate_go';
87 ALTER INSTANCE ROTATE INNODB MASTER KEY;
88 SET DEBUG_SYNC='now WAIT_FOR rotate_paused';
89 # In a third thread, try to drop an undo tablespace
90 DROP UNDO TABLESPACE undo_003;
91 # In a fourth thread, try to set an undo tablespace inactive
92 # which would cause the purge thread to truncate it.
93 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;;
94 # Switch to the default thread and check that the DDL are waiting
95 Pattern "Dropped undo tablespace 'undo_003'" not found
96 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
97 NAME SPACE_TYPE ENCRYPTION STATE
98 innodb_undo_001 Undo Y active
99 innodb_undo_002 Undo Y active
100 undo_003 Undo Y empty
101 undo_004 Undo Y active
102 # Resume the ROTATE thread.
103 SET DEBUG_SYNC='now SIGNAL rotate_go';
104 # Reap the other three threads.
105 # Return to the default thread and disconnect the other three.
106 #
107 # Cleanup
108 #
109 DROP UNDO TABLESPACE undo_004;
110 DROP PROCEDURE crypt.rotate_and_truncate;
111 DROP DATABASE crypt;
112 # Reset to initial state
113 # restart:
114 Pattern "The InnoDB Encryption Master Key has been rotated" found
115 Pattern "Dropped undo tablespace 'undo_003'" found
116 Pattern "Dropped undo tablespace 'undo_004'" found