| 1 |
# |
| 2 |
# TC1. Table `mysql.gtid_executed` read-only & rotate not triggered by `max_binlog_size` |
| 3 |
# |
| 4 |
SET DEBUG = "d,gtid_executed_readonly"; |
| 5 |
CALL mtr.add_suppression("Unable to create a new binlog file."); |
| 6 |
CALL mtr.add_suppression(".Turning logging off for the whole duration of the MySQL server process."); |
| 7 |
CALL mtr.add_suppression(".Gtid table is not ready to be used."); |
| 8 |
include/rpl_log_file_max_number.inc |
| 9 |
FLUSH BINARY LOGS; |
| 10 |
ERROR HY000: Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. |
| 11 |
include/rpl_log_file_max_number.inc |
| 12 |
include/assert.inc ['FLUSH BINARY LOGS' failed to rotate binlog] |
| 13 |
include/assert_grep.inc [ER_BINLOG_UNABLE_TO_ROTATE_GTID_TABLE_READONLY found in server log] |
| 14 |
# |
| 15 |
# TC2. Table `mysql.gtid_executed` read-only & rotate triggered by `max_binlog_size` & `binlog_error_action` is `IGNORE_ERROR` |
| 16 |
# |
| 17 |
SET GLOBAL binlog_error_action = IGNORE_ERROR; |
| 18 |
SET DEBUG = "d,gtid_executed_readonly,simulate_max_binlog_size"; |
| 19 |
include/rpl_log_file_max_number.inc |
| 20 |
FLUSH BINARY LOGS; |
| 21 |
ERROR HY000: Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. |
| 22 |
include/rpl_log_file_max_number.inc |
| 23 |
include/assert.inc ['FLUSH BINARY LOGS' failed to rotate binlog] |
| 24 |
include/assert_grep.inc [ER_BINLOG_CANT_OPEN_FOR_LOGGING found in server log] |
| 25 |
# |
| 26 |
# TC3. Table `mysql.gtid_executed` read-only & rotate triggered by `max_binlog_size` & `binlog_error_action` is `ABORT_SERVER` |
| 27 |
# |
| 28 |
SET GLOBAL binlog_error_action = ABORT_SERVER; |
| 29 |
CALL mtr.add_suppression("Unable to create a new binlog file."); |
| 30 |
CALL mtr.add_suppression(".Turning logging off for the whole duration of the MySQL server process."); |
| 31 |
CALL mtr.add_suppression(".Gtid table is not ready to be used."); |
| 32 |
CALL mtr.add_suppression("."); |
| 33 |
SET DEBUG = "d,gtid_executed_readonly,simulate_max_binlog_size"; |
| 34 |
include/rpl_log_file_max_number.inc |
| 35 |
FLUSH BINARY LOGS; |
| 36 |
ERROR HY000: Binary logging not possible. Message: Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened., while rotating the binlog. Aborting the server |
| 37 |
include/rpl_log_file_max_number.inc |
| 38 |
include/assert.inc ['FLUSH BINARY LOGS' failed to rotate binlog but as the server restarts, the binary log is rotated] |
| 39 |
include/assert_grep.inc [ER_BINLOG_LOGGING_IMPOSSIBLE found in server log] |
| 40 |
SET DEBUG = INITIAL_DEBUG; |
| 41 |
SET GLOBAL binlog_error_action = INITIAL_ERROR_ACTION; |