Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 INT);
2 include/assert.inc [the first encrypted binary log is encrypted using first master key]
3 # Part 1: fail_to_set_old_master_key_seqno_on_keyring
4 # Adding debug point 'fail_to_set_old_master_key_seqno_on_keyring' to @@GLOBAL.debug
5 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
6 ERROR HY000: Failed to operate binary log master key on keyring, please check if keyring is loaded. The statement had no effect: the old binary log master key is still in use, the keyring, binary and relay log files are unchanged, and the server could not start using a new binary log master key for encrypting new binary and relay log files.
7 # Removing debug point 'fail_to_set_old_master_key_seqno_on_keyring' from @@GLOBAL.debug
8 include/assert.inc [the before binary log is encrypted using current master key with key id: 1]
9 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
10 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
11 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
12 INSERT INTO t1 VALUES (1);
13 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 2]
14 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 2]
15 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 2]
16 # Part 2: fail_to_decrypt_file_password
17 # Adding debug point 'fail_to_decrypt_file_password' to @@GLOBAL.debug
18 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
19 ERROR HY000: Failed to re-encrypt log file './binlog.000002': failed to decrypt the file password. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
20 # Removing debug point 'fail_to_decrypt_file_password' from @@GLOBAL.debug
21 include/assert.inc [the before binary log is encrypted using current master key with key id: 3]
22 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
23 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
24 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
25 INSERT INTO t1 VALUES (1);
26 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 4]
27 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 4]
28 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 4]
29 # Part 3: fail_to_reset_file_stream
30 # Adding debug point 'fail_to_reset_file_stream' to @@GLOBAL.debug
31 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
32 ERROR HY000: Failed to re-encrypt log file './binlog.000004': failed to reset the file out stream. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
33 # Removing debug point 'fail_to_reset_file_stream' from @@GLOBAL.debug
34 include/assert.inc [the before binary log is encrypted using current master key with key id: 5]
35 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
36 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
37 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
38 INSERT INTO t1 VALUES (1);
39 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 6]
40 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 6]
41 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 6]
42 # Part 4: fail_to_encrypt_file_password
43 # Adding debug point 'fail_to_encrypt_file_password' to @@GLOBAL.debug
44 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
45 ERROR HY000: Failed to re-encrypt log file './binlog.000006': failed to encrypt the file password with current encryption key. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
46 # Removing debug point 'fail_to_encrypt_file_password' from @@GLOBAL.debug
47 include/assert.inc [the before binary log is encrypted using current master key with key id: 7]
48 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
49 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
50 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
51 INSERT INTO t1 VALUES (1);
52 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 8]
53 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 8]
54 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 8]
55 # Part 5: fail_to_write_reencrypted_header
56 # Adding debug point 'fail_to_write_reencrypted_header' to @@GLOBAL.debug
57 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
58 ERROR HY000: Failed to re-encrypt log file './binlog.000008': failed to write the new reencrypted file header. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
59 # Removing debug point 'fail_to_write_reencrypted_header' from @@GLOBAL.debug
60 include/assert.inc [the before binary log is encrypted using current master key with key id: 9]
61 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
62 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
63 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
64 INSERT INTO t1 VALUES (1);
65 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 10]
66 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 10]
67 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 10]
68 # Part 6: fail_to_flush_reencrypted_header
69 # Adding debug point 'fail_to_flush_reencrypted_header' to @@GLOBAL.debug
70 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
71 ERROR HY000: Failed to re-encrypt log file './binlog.000010': failed to flush the new reencrypted file header. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
72 # Removing debug point 'fail_to_flush_reencrypted_header' from @@GLOBAL.debug
73 include/assert.inc [the before binary log is encrypted using current master key with key id: 11]
74 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
75 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
76 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
77 INSERT INTO t1 VALUES (1);
78 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 12]
79 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 12]
80 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 12]
81 # Part 7: fail_to_sync_reencrypted_header
82 # Adding debug point 'fail_to_sync_reencrypted_header' to @@GLOBAL.debug
83 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
84 ERROR HY000: Failed to re-encrypt log file './binlog.000012': failed to synchronize the new reencrypted file header. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
85 # Removing debug point 'fail_to_sync_reencrypted_header' from @@GLOBAL.debug
86 include/assert.inc [the before binary log is encrypted using current master key with key id: 13]
87 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
88 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
89 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
90 INSERT INTO t1 VALUES (1);
91 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 14]
92 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 14]
93 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 14]
94 # Part 8: fail_to_open_log_file
95 # Adding debug point 'fail_to_open_log_file' to @@GLOBAL.debug
96 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
97 ERROR HY000: Failed to open log file './binlog.000014'. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
98 # Removing debug point 'fail_to_open_log_file' from @@GLOBAL.debug
99 include/assert.inc [the before binary log is encrypted using current master key with key id: 15]
100 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
101 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
102 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
103 INSERT INTO t1 VALUES (1);
104 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 16]
105 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 16]
106 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 16]
107 # Part 9: fail_to_open_index_file
108 # Adding debug point 'fail_to_open_index_file' to @@GLOBAL.debug
109 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
110 ERROR HY000: I/O error reading index file './binlog.index'. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
111 # Removing debug point 'fail_to_open_index_file' from @@GLOBAL.debug
112 include/assert.inc [the before binary log is encrypted using current master key with key id: 17]
113 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
114 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
115 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
116 INSERT INTO t1 VALUES (1);
117 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 18]
118 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 18]
119 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 18]
120 # Part 10: fail_to_rotate_binary_log
121 # Adding debug point 'fail_to_rotate_binary_log' to @@GLOBAL.debug
122 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
123 ERROR HY000: Failed to rotate one or more binary or relay log files. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
124 # Removing debug point 'fail_to_rotate_binary_log' from @@GLOBAL.debug
125 FLUSH BINARY LOGS;
126 include/assert.inc [the before binary log is encrypted using current master key with key id: 19]
127 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
128 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
129 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
130 INSERT INTO t1 VALUES (1);
131 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 20]
132 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 20]
133 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 20]
134 # Part 11: fail_to_fetch_key_from_keyring
135 # Adding debug point 'fail_to_fetch_key_from_keyring' to @@GLOBAL.debug
136 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
137 ERROR HY000: Failed to operate binary log master key on keyring, please check if keyring is loaded. The statement had no effect: the old binary log master key is still in use, the keyring, binary and relay log files are unchanged, and the server could not start using a new binary log master key for encrypting new binary and relay log files.
138 # Removing debug point 'fail_to_fetch_key_from_keyring' from @@GLOBAL.debug
139 FLUSH BINARY LOGS;
140 include/assert.inc [the before binary log is encrypted using current master key with key id: 20]
141 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
142 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
143 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
144 INSERT INTO t1 VALUES (1);
145 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 21]
146 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 21]
147 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 21]
148 # Part 12: fail_to_set_new_master_key_seqno_on_keyring
149 # Adding debug point 'fail_to_set_new_master_key_seqno_on_keyring' to @@GLOBAL.debug
150 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
151 ERROR HY000: Failed to operate binary log master key on keyring, please check if keyring is loaded. The statement had no effect: the old binary log master key is still in use, the keyring, binary and relay log files are unchanged, and the server could not start using a new binary log master key for encrypting new binary and relay log files.
152 # Removing debug point 'fail_to_set_new_master_key_seqno_on_keyring' from @@GLOBAL.debug
153 # Adding debug point 'fail_to_remove_old_master_key_seqno_from_keyring' to @@GLOBAL.debug
154 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
155 ERROR HY000: Failed to remove key, please check if keyring is loaded.
156 # Removing debug point 'fail_to_remove_old_master_key_seqno_from_keyring' from @@GLOBAL.debug
157 # Adding debug point 'failed_to_fetch_master_key_seqno_from_keyring' to @@GLOBAL.debug
158 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
159 ERROR HY000: Failed to fetch key from keyring, please check if keyring is loaded.
160 # Removing debug point 'failed_to_fetch_master_key_seqno_from_keyring' from @@GLOBAL.debug
161 # Adding debug point 'failed_to_fetch_old_master_key_seqno_from_keyring' to @@GLOBAL.debug
162 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
163 ERROR HY000: Failed to fetch key from keyring, please check if keyring is loaded.
164 # Removing debug point 'failed_to_fetch_old_master_key_seqno_from_keyring' from @@GLOBAL.debug
165 FLUSH BINARY LOGS;
166 include/assert.inc [the before binary log is encrypted using current master key with key id: 21]
167 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
168 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
169 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
170 INSERT INTO t1 VALUES (1);
171 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 22]
172 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 22]
173 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 22]
174 #
175 # Verify that an error 'ER_BINLOG_MASTER_KEY_ROTATION_FAIL_TO_OPERATE_KEY'
176 # is emitted to the client side when executing the command
177 # 'ALTER INSTANCE ROTATE BINLOG MASTER KEY' if there is an
178 # error when generating key on keyring.
179 #
180 # Part 13: fail_to_generate_key_on_keyring
181 # Adding debug point 'fail_to_generate_key_on_keyring' to @@GLOBAL.debug
182 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
183 ERROR HY000: Failed to operate binary log master key on keyring, please check if keyring is loaded. The statement had no effect: the old binary log master key is still in use, the keyring, binary and relay log files are unchanged, and the server could not start using a new binary log master key for encrypting new binary and relay log files.
184 # Removing debug point 'fail_to_generate_key_on_keyring' from @@GLOBAL.debug
185 # Adding debug point 'fail_to_remove_new_master_key_seqno_from_keyring' to @@GLOBAL.debug
186 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
187 ERROR HY000: Failed to remove key, please check if keyring is loaded.
188 # Removing debug point 'fail_to_remove_new_master_key_seqno_from_keyring' from @@GLOBAL.debug
189 # Adding debug point 'failed_to_fetch_new_master_key_seqno_from_keyring' to @@GLOBAL.debug
190 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
191 ERROR HY000: Failed to fetch key from keyring, please check if keyring is loaded.
192 # Removing debug point 'failed_to_fetch_new_master_key_seqno_from_keyring' from @@GLOBAL.debug
193 FLUSH BINARY LOGS;
194 include/assert.inc [the before binary log is encrypted using current master key with key id: 22]
195 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
196 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
197 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
198 INSERT INTO t1 VALUES (1);
199 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 23]
200 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 23]
201 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 23]
202 # Part 14: fail_to_remove_master_key_from_keyring
203 # Adding debug point 'fail_to_remove_master_key_from_keyring' to @@GLOBAL.debug
204 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
205 ERROR HY000: Failed to operate binary log master key on keyring, please check if keyring is loaded. The statement had no effect: the old binary log master key is still in use, the keyring, binary and relay log files are unchanged, and the server could not start using a new binary log master key for encrypting new binary and relay log files.
206 # Removing debug point 'fail_to_remove_master_key_from_keyring' from @@GLOBAL.debug
207 FLUSH BINARY LOGS;
208 include/assert.inc [the before binary log is encrypted using current master key with key id: 24]
209 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
210 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
211 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
212 INSERT INTO t1 VALUES (1);
213 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 25]
214 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 25]
215 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 25]
216 # Part 15: fail_to_get_purged_seqno_from_keyring
217 # Adding debug point 'fail_to_get_purged_seqno_from_keyring' to @@GLOBAL.debug
218 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
219 Warnings:
220 Error 3784 Failed to fetch key from keyring, please check if keyring is loaded.
221 Warning 3810 Failed to remove unused binary log encryption keys from the keyring, please check if keyring is loaded. The unused binary log encryption keys may still exist in the keyring, and they will be removed upon server restart or next 'ALTER INSTANCE ROTATE BINLOG MASTER KEY' execution.
222 # Removing debug point 'fail_to_get_purged_seqno_from_keyring' from @@GLOBAL.debug
223 FLUSH BINARY LOGS;
224 include/assert.inc [the before binary log is encrypted using current master key with key id: 26]
225 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
226 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
227 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
228 INSERT INTO t1 VALUES (1);
229 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 27]
230 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 27]
231 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 27]
232 # Part 16: fail_to_get_key_from_keyring
233 # Adding debug point 'fail_to_get_key_from_keyring' to @@GLOBAL.debug
234 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
235 Warnings:
236 Error 3784 Failed to fetch key from keyring, please check if keyring is loaded.
237 Warning 3810 Failed to remove unused binary log encryption keys from the keyring, please check if keyring is loaded. The unused binary log encryption keys may still exist in the keyring, and they will be removed upon server restart or next 'ALTER INSTANCE ROTATE BINLOG MASTER KEY' execution.
238 # Removing debug point 'fail_to_get_key_from_keyring' from @@GLOBAL.debug
239 include/assert.inc [the before binary log is encrypted using current master key with key id: 28]
240 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
241 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
242 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
243 INSERT INTO t1 VALUES (1);
244 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 29]
245 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 29]
246 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 29]
247 # Part 17: fail_to_remove_unused_key_from_keyring
248 # Adding debug point 'fail_to_remove_unused_key_from_keyring' to @@GLOBAL.debug
249 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
250 Warnings:
251 Error 3792 Failed to remove key, please check if keyring is loaded.
252 Warning 3810 Failed to remove unused binary log encryption keys from the keyring, please check if keyring is loaded. The unused binary log encryption keys may still exist in the keyring, and they will be removed upon server restart or next 'ALTER INSTANCE ROTATE BINLOG MASTER KEY' execution.
253 # Removing debug point 'fail_to_remove_unused_key_from_keyring' from @@GLOBAL.debug
254 include/assert.inc [the before binary log is encrypted using current master key with key id: 30]
255 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
256 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
257 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
258 INSERT INTO t1 VALUES (1);
259 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 31]
260 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 31]
261 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 31]
262 # Part 18: fail_to_remove_last_purged_seqno_from_keyring
263 # Adding debug point 'fail_to_remove_last_purged_seqno_from_keyring' to @@GLOBAL.debug
264 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
265 Warnings:
266 Error 3792 Failed to remove key, please check if keyring is loaded.
267 Warning 3810 Failed to remove unused binary log encryption keys from the keyring, please check if keyring is loaded. The unused binary log encryption keys may still exist in the keyring, and they will be removed upon server restart or next 'ALTER INSTANCE ROTATE BINLOG MASTER KEY' execution.
268 # Removing debug point 'fail_to_remove_last_purged_seqno_from_keyring' from @@GLOBAL.debug
269 include/assert.inc [the before binary log is encrypted using current master key with key id: 32]
270 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
271 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
272 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
273 INSERT INTO t1 VALUES (1);
274 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 33]
275 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 33]
276 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 33]
277 # Part 19: fail_to_remove_old_master_key_seqno_from_keyring
278 # Adding debug point 'fail_to_remove_old_master_key_seqno_from_keyring' to @@GLOBAL.debug
279 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
280 Warnings:
281 Error 3792 Failed to remove key, please check if keyring is loaded.
282 Warning 3811 Failed to remove auxiliary binary log encryption key from keyring, please check if keyring is loaded. The cleanup of the binary log master key rotation process did not finish as expected and the cleanup will take place upon server restart or next 'ALTER INSTANCE ROTATE BINLOG MASTER KEY' execution.
283 # Removing debug point 'fail_to_remove_old_master_key_seqno_from_keyring' from @@GLOBAL.debug
284 include/assert.inc [the before binary log is encrypted using current master key with key id: 34]
285 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
286 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
287 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
288 INSERT INTO t1 VALUES (1);
289 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 35]
290 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 35]
291 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 35]
292 # Part 20: fail_to_remove_new_master_key_seqno_from_keyring
293 # Adding debug point 'fail_to_remove_new_master_key_seqno_from_keyring' to @@GLOBAL.debug
294 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
295 Warnings:
296 Error 3792 Failed to remove key, please check if keyring is loaded.
297 Warning 3811 Failed to remove auxiliary binary log encryption key from keyring, please check if keyring is loaded. The cleanup of the binary log master key rotation process did not finish as expected and the cleanup will take place upon server restart or next 'ALTER INSTANCE ROTATE BINLOG MASTER KEY' execution.
298 # Removing debug point 'fail_to_remove_new_master_key_seqno_from_keyring' from @@GLOBAL.debug
299 include/assert.inc [the before binary log is encrypted using current master key with key id: 36]
300 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
301 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
302 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
303 INSERT INTO t1 VALUES (1);
304 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 37]
305 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 37]
306 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 37]
307 # Part 21: fail_to_set_last_purged_master_key_seqno_on_keyring
308 # Adding debug point 'fail_to_set_last_purged_master_key_seqno_on_keyring' to @@GLOBAL.debug
309 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
310 Warnings:
311 Error 3791 Failed to store key, please check if keyring is loaded.
312 Warning 3810 Failed to remove unused binary log encryption keys from the keyring, please check if keyring is loaded. The unused binary log encryption keys may still exist in the keyring, and they will be removed upon server restart or next 'ALTER INSTANCE ROTATE BINLOG MASTER KEY' execution.
313 # Removing debug point 'fail_to_set_last_purged_master_key_seqno_on_keyring' from @@GLOBAL.debug
314 include/assert.inc [the before binary log is encrypted using current master key with key id: 38]
315 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
316 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
317 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
318 INSERT INTO t1 VALUES (1);
319 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 39]
320 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 39]
321 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 39]
322 # Part 22: fail_to_set_master_key_seqno_on_keyring
323 # Adding debug point 'fail_to_set_master_key_seqno_on_keyring' to @@GLOBAL.debug
324 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
325 ERROR HY000: Failed to operate binary log master key on keyring, please check if keyring is loaded. The statement had no effect: the old binary log master key is still in use, the keyring, binary and relay log files are unchanged, and the server could not start using a new binary log master key for encrypting new binary and relay log files.
326 # Removing debug point 'fail_to_set_master_key_seqno_on_keyring' from @@GLOBAL.debug
327 # Adding debug point 'fail_to_set_master_key_seqno_on_keyring' to @@GLOBAL.debug
328 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
329 ERROR HY000: Failed to store key, please check if keyring is loaded.
330 # Removing debug point 'fail_to_set_master_key_seqno_on_keyring' from @@GLOBAL.debug
331 include/assert.inc [the before binary log is encrypted using current master key with key id: 39]
332 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
333 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
334 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
335 INSERT INTO t1 VALUES (1);
336 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 41]
337 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 41]
338 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 41]
339 # Part 23: fail_to_read_index_file
340 # Adding debug point 'fail_to_read_index_file' to @@GLOBAL.debug
341 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
342 ERROR HY000: I/O error reading index file './binlog.index'. A new binary log master key was generated and will be used to encrypt new binary and relay log files. There may still exist binary or relay log files using the previous binary log master key.
343 # Removing debug point 'fail_to_read_index_file' from @@GLOBAL.debug
344 include/assert.inc [the before binary log is encrypted using current master key with key id: 42]
345 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
346 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
347 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
348 INSERT INTO t1 VALUES (1);
349 include/assert.inc [the after binary log is encrypted using rotated master key with key id: 43]
350 include/assert.inc [the before binary log is re-encrypted using rotated master key with key id: 43]
351 include/assert.inc [the first encrypted binary log is re-encrypted using rotated master key with key id: 43]
352 DROP TABLE t1;