call mtr.add_suppression("MYSQL_BIN_LOG::add_log_to_index failed to copy index file to crash safe index file.");
call mtr.add_suppression("Disk is full writing *");
call mtr.add_suppression("Retry in 60 secs. *");
call mtr.add_suppression("Error writing file*");
call mtr.add_suppression("Could not open .*");
call mtr.add_suppression("Could not use .*");
call mtr.add_suppression("Can't generate a unique log-filename master-bin");
call mtr.add_suppression("The server was unable to create a new log file *");
call mtr.add_suppression("An error occurred during flush stage of the commit");
call mtr.add_suppression("An error occurred during sync stage of the commit");
call mtr.add_suppression("Either disk is full or file system is read only");
call mtr.add_suppression("Attempting backtrace. You can use the following information to find out");
RESET MASTER;
Test case1
SET GLOBAL binlog_error_action= ABORT_SERVER;
flush logs;
ERROR HY000: Binary logging not possible. Message: Either disk is full or file system is read only while rotating the binlog. Aborting the server.
Test case2
SET SESSION debug="+d,fault_injection_updating_index";
SET GLOBAL binlog_error_action= ABORT_SERVER;
flush logs;
ERROR HY000: Binary logging not possible. Message: Either disk is full or file system is read only while opening the binlog. Aborting the server.
Test case3
SET SESSION debug="+d,simulate_disk_full_on_open_binlog";
SET GLOBAL binlog_error_action= ABORT_SERVER;
flush logs;
ERROR HY000: Binary logging not possible. Message: Either disk is full or file system is read only while opening the binlog. Aborting the server.
Test case4
SET SESSION debug="+d,fault_injection_init_name";
SET GLOBAL binlog_error_action= ABORT_SERVER;
flush logs;
ERROR HY000: Binary logging not possible. Message: Either disk is full or file system is read only while opening the binlog. Aborting the server.
Test case5
flush logs;
ERROR HY000: File 'master-bin.index' not found (Errcode: 13 - Permission denied)
CREATE TABLE t1 ( f int );
SHOW TABLES;
Tables_in_test
t1
DROP TABLE t1;
Test case6
SET SESSION debug="+d,fault_injection_updating_index";
flush logs;
ERROR HY000: Can't open file: 'master-bin.000007' (errno: 1 - Operation not permitted)
CREATE TABLE t2 (f int );
SHOW TABLES;
Tables_in_test
t2
DROP TABLE t2;
SET SESSION debug="-d,fault_injection_updating_index";
Test case7
SET SESSION debug="+d,simulate_disk_full_on_open_binlog";
flush logs;
ERROR HY000: Error writing file 'master-bin.index_crash_safe' (Errcode: 28 - No space left on device)
SET SESSION debug="-d,simulate_disk_full_on_open_binlog";
Test case8
SET SESSION debug="+d,fault_injection_init_name";
flush logs;
ERROR HY000: Can't open file: 'master-bin.000009' (errno: 1 - Operation not permitted)
CREATE TABLE t2 (f int );
SHOW TABLES;
Tables_in_test
t2
DROP TABLE t2;
SET SESSION debug="-d,fault_injection_init_name";
Test case09
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
SET SESSION debug='+d,error_unique_log_filename';
FLUSH LOGS;
ERROR HY000: Can't generate a unique log-filename master-bin.(1-999)
DROP TABLE t1;
SET SESSION debug="";
SHOW BINARY LOGS;
ERROR HY000: You are not using binary logging
Test case10
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
SET GLOBAL binlog_error_action=ABORT_SERVER;
SET SESSION debug='+d,error_unique_log_filename';
FLUSH LOGS;
ERROR HY000: Binary logging not possible. Message: Either disk is full or file system is read only while rotating the binlog. Aborting the server.
DROP TABLE t1;
Test case11
RESET MASTER;
CREATE TABLE t1(i INT);
SET SESSION debug = "+d,simulate_error_during_flush_cache_to_file";
SET GLOBAL binlog_error_action = ABORT_SERVER;
INSERT INTO t1 VALUES (1);
ERROR HY000: Binary logging not possible. Message: An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'. Hence aborting the server.
include/assert.inc [Count of elements in t1 should be 0.]
include/assert.inc [Query is not binlogged as expected.]
RESET MASTER;
SET SESSION debug ="+d,simulate_error_during_flush_cache_to_file";
SET GLOBAL binlog_error_action= IGNORE_ERROR;
INSERT INTO t1 VALUES (2);
include/assert.inc [Count of elements in t1 should be 1.]
include/assert.inc [Query is not binlogged as expected.]
DROP TABLE t1;
RESET MASTER;
Test case12
SET GLOBAL sync_binlog = 1;
CREATE TABLE t1(i INT);
SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
SET GLOBAL binlog_error_action = ABORT_SERVER;
INSERT INTO t1 VALUES (1);
ERROR HY000: Binary logging not possible. Message: An error occurred during sync stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'. Hence aborting the server.
DELETE FROM t1;
RESET MASTER;
SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
SET GLOBAL binlog_error_action = IGNORE_ERROR;
INSERT INTO t1 VALUES (2);
include/assert.inc [Count of elements in t1 should be 1.]
DROP table t1;
SET SESSION debug = "-d,simulate_error_during_sync_binlog_file";
RESET MASTER;
Test case13
CREATE TABLE t1(i INT);
SET SESSION debug = "+d,simulate_do_write_cache_failure";
SET GLOBAL binlog_error_action = ABORT_SERVER;
INSERT INTO t1 VALUES (1);
ERROR HY000: Binary logging not possible. Message: An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'. Hence aborting the server.
include/assert.inc [Count of elements in t1 should be 0.]
include/assert.inc [Query is not binlogged as expected.]
RESET MASTER;
SET SESSION debug = "+d,simulate_do_write_cache_failure";
SET GLOBAL binlog_error_action = IGNORE_ERROR;
INSERT INTO t1 VALUES (2);
include/assert.inc [Count of elements in t1 should be 1.]
DROP table t1;
RESET MASTER;
Test case14
SET GLOBAL binlog_error_action = IGNORE_ERROR;
SET GLOBAL sync_binlog = 1;
CREATE TABLE t1(i INT);
CREATE TABLE t2(i INT);
SET DEBUG_SYNC = "waiting_to_enter_flush_stage SIGNAL about_to_enter_flush_stage WAIT_FOR binlog_closed";
INSERT INTO t1 values (1);;
SET DEBUG_SYNC = "now wait_for about_to_enter_flush_stage";
SET DEBUG_SYNC = "after_binlog_closed_due_to_error SIGNAL binlog_closed";
SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
INSERT INTO t2 values (2);;
DROP table t1, t2;
Test case15
SET GLOBAL binlog_error_action = IGNORE_ERROR;
SET GLOBAL sync_binlog = 1;
CREATE TABLE t1(i INT);
CREATE TABLE t2(i INT);
SET DEBUG_SYNC = "before_binlog_closed_due_to_error SIGNAL binlog_about_to_be_closed WAIT_FOR in_the_middle_of_flush_stage";
SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
INSERT INTO t1 values (1);;
SET DEBUG_SYNC = "now wait_for binlog_about_to_be_closed";
SET DEBUG_SYNC = "waiting_in_the_middle_of_flush_stage SIGNAL in_the_middle_of_flush_stage";
INSERT INTO t2 values (2);;
DROP table t1, t2;
Test case16
SET GLOBAL binlog_error_action = IGNORE_ERROR;
SET GLOBAL sync_binlog = 1;
CREATE TABLE t1(i INT);
CREATE TABLE t2(i INT);
SET DEBUG_SYNC = "before_binlog_closed_due_to_error SIGNAL binlog_about_to_be_closed WAIT_FOR another_group_encountered_flush_error";
SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
INSERT INTO t1 values (1);;
SET DEBUG_SYNC = "now wait_for binlog_about_to_be_closed";
SET DEBUG_SYNC = "before_binlog_closed_due_to_error SIGNAL another_group_encountered_flush_error";
SET SESSION debug ="+d,simulate_error_during_flush_cache_to_file";
INSERT INTO t2 values (2);;
Matching lines are:
--TIME-- [ERROR] An error occurred during flush_or_sync stage stage of the commit. 'binlog_error_action' is set to 'IGNORE_ERROR'. Hence turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
Occurrences of the An error occurred during in the input file : 1
DROP table t1, t2;