| 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; |