42 lines
2.3 KiB
Plaintext
42 lines
2.3 KiB
Plaintext
#
|
|
# TC1. Table `mysql.gtid_executed` read-only & rotate not triggered by `max_binlog_size`
|
|
#
|
|
SET DEBUG = "d,gtid_executed_readonly";
|
|
CALL mtr.add_suppression("Unable to create a new binlog file.");
|
|
CALL mtr.add_suppression(".Turning logging off for the whole duration of the MySQL server process.");
|
|
CALL mtr.add_suppression(".Gtid table is not ready to be used.");
|
|
include/rpl_log_file_max_number.inc
|
|
FLUSH BINARY LOGS;
|
|
ERROR HY000: Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
|
|
include/rpl_log_file_max_number.inc
|
|
include/assert.inc ['FLUSH BINARY LOGS' failed to rotate binlog]
|
|
include/assert_grep.inc [ER_BINLOG_UNABLE_TO_ROTATE_GTID_TABLE_READONLY found in server log]
|
|
#
|
|
# TC2. Table `mysql.gtid_executed` read-only & rotate triggered by `max_binlog_size` & `binlog_error_action` is `IGNORE_ERROR`
|
|
#
|
|
SET GLOBAL binlog_error_action = IGNORE_ERROR;
|
|
SET DEBUG = "d,gtid_executed_readonly,simulate_max_binlog_size";
|
|
include/rpl_log_file_max_number.inc
|
|
FLUSH BINARY LOGS;
|
|
ERROR HY000: Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
|
|
include/rpl_log_file_max_number.inc
|
|
include/assert.inc ['FLUSH BINARY LOGS' failed to rotate binlog]
|
|
include/assert_grep.inc [ER_BINLOG_CANT_OPEN_FOR_LOGGING found in server log]
|
|
#
|
|
# TC3. Table `mysql.gtid_executed` read-only & rotate triggered by `max_binlog_size` & `binlog_error_action` is `ABORT_SERVER`
|
|
#
|
|
SET GLOBAL binlog_error_action = ABORT_SERVER;
|
|
CALL mtr.add_suppression("Unable to create a new binlog file.");
|
|
CALL mtr.add_suppression(".Turning logging off for the whole duration of the MySQL server process.");
|
|
CALL mtr.add_suppression(".Gtid table is not ready to be used.");
|
|
CALL mtr.add_suppression(".");
|
|
SET DEBUG = "d,gtid_executed_readonly,simulate_max_binlog_size";
|
|
include/rpl_log_file_max_number.inc
|
|
FLUSH BINARY LOGS;
|
|
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
|
|
include/rpl_log_file_max_number.inc
|
|
include/assert.inc ['FLUSH BINARY LOGS' failed to rotate binlog but as the server restarts, the binary log is rotated]
|
|
include/assert_grep.inc [ER_BINLOG_LOGGING_IMPOSSIBLE found in server log]
|
|
SET DEBUG = INITIAL_DEBUG;
|
|
SET GLOBAL binlog_error_action = INITIAL_ERROR_ACTION;
|