Debian Codegraph @

mysql-test/suite/binlog/r/binlog_rotate_binlog_master_key_crash_recovery.result

raw
1 SET @@GLOBAL.binlog_encryption=ON;
2 include/assert.inc [the first encrypted binary log is encrypted using first master key]
3 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES(1);
5 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
6 INSERT INTO t1 VALUES(2);
7 # Part 1: crash_before_set_old_master_key_seqno_on_keyring
8 # Adding debug point 'crash_before_set_old_master_key_seqno_on_keyring' to @@GLOBAL.debug
9 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
10 ERROR HY000: Lost connection to MySQL server during query
11 # Restart the master server
12 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
13 #
14 # Verify that an error 'ER_RPL_ENCRYPTION_MASTER_KEY_RECOVERY_FAILED'
15 # is emitted to the client side when executing the command
16 # 'SET @@GLOBAL.binlog_encryption=ON' if there is an error
17 # when fetching master key seqno from keyring.
18 #
19 # Adding debug point 'fail_to_fetch_master_key_seqno_from_keyring' to @@GLOBAL.debug
20 SET @@GLOBAL.binlog_encryption=ON;
21 ERROR HY000: Unable to recover binlog encryption master key, please check if keyring is loaded.
22 # Removing debug point 'fail_to_fetch_master_key_seqno_from_keyring' from @@GLOBAL.debug
23 #
24 # Verify that an error 'ER_RPL_ENCRYPTION_MASTER_KEY_RECOVERY_FAILED'
25 # is emitted to the client side when executing the command
26 # 'SET @@GLOBAL.binlog_encryption=ON' if there is an error
27 # when fetching old master key seqno from keyring.
28 #
29 # Adding debug point 'fail_to_fetch_old_master_key_seqno_from_keyring' to @@GLOBAL.debug
30 SET @@GLOBAL.binlog_encryption=ON;
31 ERROR HY000: Unable to recover binlog encryption master key, please check if keyring is loaded.
32 # Removing debug point 'fail_to_fetch_old_master_key_seqno_from_keyring' from @@GLOBAL.debug
33 SET @@GLOBAL.binlog_encryption=ON;
34 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
35 include/assert.inc [the before binary log is encrypted using current master key with key id: 2]
36 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
37 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
38 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
39 INSERT INTO t1 VALUES (1);
40 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 3]
41 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 3]
42 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 3]
43 # Part 2: crash_after_set_old_master_key_seqno_on_keyring
44 # Adding debug point 'crash_after_set_old_master_key_seqno_on_keyring' to @@GLOBAL.debug
45 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
46 ERROR HY000: Lost connection to MySQL server during query
47 # Restart the master server
48 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
49 #
50 # Verify that an error 'ER_binlog_MASTER_KEY_RECOVERY_OUT_OF_COMBINATION'
51 # is emitted to the client side when executing the command
52 # 'SET @@GLOBAL.binlog_encryption=ON' if the combination of
53 # values of new_master_key_seqno, master_key_seqno and
54 # old_master_key_seqno are wrong when recovering binlog master key.
55 #
56 # Adding debug point 'simulate_master_key_recovery_out_of_combination' to @@GLOBAL.debug
57 SET @@GLOBAL.binlog_encryption=ON;
58 ERROR HY000: Unable to recover binary log master key, the combination of new_master_key_seqno=0, master_key_seqno=4 and old_master_key_seqno=3 are wrong.
59 # Removing debug point 'simulate_master_key_recovery_out_of_combination' from @@GLOBAL.debug
60 SET @@GLOBAL.binlog_encryption=ON;
61 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
62 include/assert.inc [the before binary log is encrypted using current master key with key id: 4]
63 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
64 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
65 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
66 INSERT INTO t1 VALUES (1);
67 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 5]
68 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 5]
69 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 5]
70 # Part 3: crash_after_set_new_master_key_seqno_on_keyring
71 # Adding debug point 'crash_after_set_new_master_key_seqno_on_keyring' to @@GLOBAL.debug
72 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
73 ERROR HY000: Lost connection to MySQL server during query
74 # Restart the master server
75 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
76 #
77 # Verify that an error 'ER_RPL_ENCRYPTION_MASTER_KEY_RECOVERY_FAILED'
78 # is emitted to the client side when executing the command
79 # 'SET @@GLOBAL.binlog_encryption=ON' if there is an error
80 # when fetching new master key from keyring.
81 #
82 # Adding debug point 'fail_to_fetch_new_master_key_from_keyring' to @@GLOBAL.debug
83 SET @@GLOBAL.binlog_encryption=ON;
84 ERROR HY000: Unable to recover binlog encryption master key, please check if keyring is loaded.
85 # Removing debug point 'fail_to_fetch_new_master_key_from_keyring' from @@GLOBAL.debug
86 SET @@GLOBAL.binlog_encryption=ON;
87 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
88 include/assert.inc [the before binary log is encrypted using current master key with key id: 6]
89 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
90 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
91 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
92 INSERT INTO t1 VALUES (1);
93 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 7]
94 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 7]
95 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 7]
96 # Part 4: crash_after_generate_new_master_key_on_keyring
97 # Adding debug point 'crash_after_generate_new_master_key_on_keyring' to @@GLOBAL.debug
98 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
99 ERROR HY000: Lost connection to MySQL server during query
100 # Restart the master server
101 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
102 #
103 # Verify that an error 'ER_RPL_ENCRYPTION_MASTER_KEY_RECOVERY_FAILED'
104 # is emitted to the client side when executing the command
105 # 'SET @@GLOBAL.binlog_encryption=ON' if there is an error
106 # when fetching new master key seqno from keyring.
107 #
108 # Adding debug point 'fail_to_fetch_new_master_key_seqno_from_keyring' to @@GLOBAL.debug
109 SET @@GLOBAL.binlog_encryption=ON;
110 ERROR HY000: Unable to recover binlog encryption master key, please check if keyring is loaded.
111 # Removing debug point 'fail_to_fetch_new_master_key_seqno_from_keyring' from @@GLOBAL.debug
112 SET @@GLOBAL.binlog_encryption=ON;
113 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
114 include/assert.inc [the before binary log is encrypted using current master key with key id: 8]
115 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
116 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
117 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
118 INSERT INTO t1 VALUES (1);
119 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 9]
120 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 9]
121 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 9]
122 # Part 5: crash_after_remove_master_key_seqno_from_keyring
123 # Adding debug point 'crash_after_remove_master_key_seqno_from_keyring' to @@GLOBAL.debug
124 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
125 ERROR HY000: Lost connection to MySQL server during query
126 # Restart the master server
127 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
128 SET @@GLOBAL.binlog_encryption=ON;
129 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
130 include/assert.inc [the before binary log is encrypted using current master key with key id: 10]
131 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
132 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
133 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
134 INSERT INTO t1 VALUES (1);
135 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 11]
136 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 11]
137 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 11]
138 # Part 6: crash_after_set_master_key_seqno_on_keyring
139 # Adding debug point 'crash_after_set_master_key_seqno_on_keyring' to @@GLOBAL.debug
140 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
141 ERROR HY000: Lost connection to MySQL server during query
142 # Restart the master server
143 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
144 SET @@GLOBAL.binlog_encryption=ON;
145 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
146 include/assert.inc [the before binary log is encrypted using current master key with key id: 12]
147 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
148 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
149 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
150 INSERT INTO t1 VALUES (1);
151 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 13]
152 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 13]
153 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 13]
154 # Part 7: crash_after_remove_old_master_key_seqno_from_keyring
155 # Adding debug point 'crash_after_remove_old_master_key_seqno_from_keyring' to @@GLOBAL.debug
156 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
157 ERROR HY000: Lost connection to MySQL server during query
158 # Restart the master server
159 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
160 SET @@GLOBAL.binlog_encryption=ON;
161 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
162 include/assert.inc [the before binary log is encrypted using current master key with key id: 14]
163 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
164 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
165 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
166 INSERT INTO t1 VALUES (1);
167 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 15]
168 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 15]
169 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 15]
170 # Part 8: crash_after_remove_new_master_key_seqno_from_keyring
171 # Adding debug point 'crash_after_remove_new_master_key_seqno_from_keyring' to @@GLOBAL.debug
172 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
173 ERROR HY000: Lost connection to MySQL server during query
174 # Restart the master server
175 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
176 SET @@GLOBAL.binlog_encryption=ON;
177 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
178 include/assert.inc [the before binary log is encrypted using current master key with key id: 16]
179 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
180 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
181 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
182 INSERT INTO t1 VALUES (1);
183 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 17]
184 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 17]
185 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 17]
186 # Part 9: crash_after_set_old_master_key_seqno_on_keyring
187 # Adding debug point 'crash_after_set_old_master_key_seqno_on_keyring' to @@GLOBAL.debug
188 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
189 ERROR HY000: Lost connection to MySQL server during query
190 # Restart the master server
191 include/assert.inc ['binlog_encryption' is off after above crash recovery.]
192 #
193 # Verify that an error 'ER_RPL_ENCRYPTION_FAILED_TO_STORE_KEY'
194 # is emitted to the client side when executing the command
195 # 'SET @@GLOBAL.binlog_encryption=ON' if there is an error
196 # on setting new master key seqno on keyring when recovering
197 # binlog master key.
198 #
199 # Adding debug point 'fail_to_set_new_master_key_seqno_on_keyring' to @@GLOBAL.debug
200 SET @@GLOBAL.binlog_encryption=ON;
201 ERROR HY000: Failed to store key, please check if keyring is loaded.
202 # Removing debug point 'fail_to_set_new_master_key_seqno_on_keyring' from @@GLOBAL.debug
203 SET @@GLOBAL.binlog_encryption=ON;
204 include/assert.inc [Verify that 'binlog_encryption' can be enabled after above crash recovery.]
205 include/assert.inc [the before binary log is encrypted using current master key with key id: 18]
206 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
207 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
208 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
209 INSERT INTO t1 VALUES (1);
210 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 19]
211 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 19]
212 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 19]
213 DROP TABLE t1;
214 SET @@GLOBAL.binlog_encryption=DEFAULT_BINLOG_ENCRYPTION;