Gecko [ www.jdcpatala.org ]

Name	Size	Permission
binlog_anonymous_ownership.tes...	11.78 KB	-rw-r--r--
binlog_bug23533.test	1.48 KB	-rw-r--r--
binlog_bug36391-master.opt	32 B	-rw-r--r--
binlog_bug36391.test	1.18 KB	-rw-r--r--
binlog_cache_write_failure-mas...	97 B	-rw-r--r--
binlog_cache_write_failure.tes...	5.4 KB	-rw-r--r--
binlog_check_flush_log_asserti...	1.68 KB	-rw-r--r--
binlog_checksum.test	1.08 KB	-rw-r--r--
binlog_crash_safe_master_check...	51 B	-rw-r--r--
binlog_crash_safe_master_check...	2.6 KB	-rw-r--r--
binlog_database.test	370 B	-rw-r--r--
binlog_delete_and_flush_index....	3.53 KB	-rw-r--r--
binlog_dmls_on_tmp_tables_read...	2.38 KB	-rw-r--r--
binlog_drop_if_exists.test	3.47 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	2 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	1.75 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	379 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	378 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	1.46 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	3.75 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	314 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	313 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	739 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	409 B	-rw-r--r--
binlog_error_action-master.opt	88 B	-rw-r--r--
binlog_error_action.test	17.12 KB	-rw-r--r--
binlog_flush_logs_error.test	1.72 KB	-rw-r--r--
binlog_foreign_key_parent_tabl...	44 B	-rw-r--r--
binlog_foreign_key_parent_tabl...	1.08 KB	-rw-r--r--
binlog_format_switch_in_tmp_ta...	2.77 KB	-rw-r--r--
binlog_grant.test	1.83 KB	-rw-r--r--
binlog_grant_alter_user-master...	32 B	-rw-r--r--
binlog_grant_alter_user.test	39.59 KB	-rw-r--r--
binlog_group_commit_flush_cras...	51 B	-rw-r--r--
binlog_group_commit_flush_cras...	2.17 KB	-rw-r--r--
binlog_group_commit_gtid_order...	4.6 KB	-rw-r--r--
binlog_group_commit_indefinite...	1.51 KB	-rw-r--r--
binlog_group_commit_sync_delay...	1.84 KB	-rw-r--r--
binlog_group_commit_sync_delay...	1.23 KB	-rw-r--r--
binlog_group_commit_sync_no_de...	3.72 KB	-rw-r--r--
binlog_gtid_automatic_using_ro...	2.02 KB	-rw-r--r--
binlog_gtid_cache-master.opt	117 B	-rw-r--r--
binlog_gtid_cache.test	635 B	-rw-r--r--
binlog_gtid_errors-master.opt	149 B	-rw-r--r--
binlog_gtid_errors.test	9.1 KB	-rw-r--r--
binlog_gtid_exhausted-master.o...	77 B	-rw-r--r--
binlog_gtid_exhausted.test	3.3 KB	-rw-r--r--
binlog_gtid_implicit_commit.te...	121 B	-rw-r--r--
binlog_gtid_innodb.test	132 B	-rw-r--r--
binlog_gtid_mix_ok_packet_all_...	131 B	-rw-r--r--
binlog_gtid_mix_ok_packet_all_...	1.63 KB	-rw-r--r--
binlog_gtid_mix_response_packe...	99 B	-rw-r--r--
binlog_gtid_mix_response_packe...	1.82 KB	-rw-r--r--
binlog_gtid_mode_set_gtid_next...	4.66 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row.te...	197 B	-rw-r--r--
binlog_gtid_mysqlbinlog_row_in...	707 B	-rw-r--r--
binlog_gtid_mysqlbinlog_row_my...	661 B	-rw-r--r--
binlog_gtid_mysqlbinlog_start_...	444 B	-rw-r--r--
binlog_gtid_mysqldump.test	2.09 KB	-rw-r--r--
binlog_gtid_next_begin_caused_...	948 B	-rw-r--r--
binlog_gtid_next_partially_fai...	2.93 KB	-rw-r--r--
binlog_gtid_next_partially_fai...	9.45 KB	-rw-r--r--
binlog_gtid_next_single_stmt_t...	968 B	-rw-r--r--
binlog_gtid_next_temporary_tab...	2.73 KB	-rw-r--r--
binlog_gtid_next_xa.test	241 B	-rw-r--r--
binlog_gtid_ps_reprepare.test	6.56 KB	-rw-r--r--
binlog_gtid_purge_binlog_at_st...	3.72 KB	-rw-r--r--
binlog_gtid_rbr_only_flag.test	2.51 KB	-rw-r--r--
binlog_gtid_reset_consistency_...	2.61 KB	-rw-r--r--
binlog_gtid_row_ctype_ucs.test	265 B	-rw-r--r--
binlog_gtid_simple_recovery.te...	6 KB	-rw-r--r--
binlog_gtid_state_update_deadl...	2.62 KB	-rw-r--r--
binlog_gtid_stm_ctype_ucs.test	280 B	-rw-r--r--
binlog_gtid_unknown_xid.test	5.39 KB	-rw-r--r--
binlog_gtid_utils.test	3.56 KB	-rw-r--r--
binlog_gtids_table_gcov.test	2.86 KB	-rw-r--r--
binlog_implicit_commit.test	290 B	-rw-r--r--
binlog_incident.test	1.39 KB	-rw-r--r--
binlog_incident_ignore-master....	24 B	-rw-r--r--
binlog_incident_ignore.test	152 B	-rw-r--r--
binlog_index-master.opt	16 B	-rw-r--r--
binlog_index.test	16.86 KB	-rw-r--r--
binlog_innodb-master.opt	25 B	-rw-r--r--
binlog_innodb.test	139 B	-rw-r--r--
binlog_innodb_row.test	2.72 KB	-rw-r--r--
binlog_killed.test	9.71 KB	-rw-r--r--
binlog_killed_simulate-master....	39 B	-rw-r--r--
binlog_killed_simulate.test	2.7 KB	-rw-r--r--
binlog_max_extension.test	2.61 KB	-rw-r--r--
binlog_max_flush_queue_time_wa...	32 B	-rw-r--r--
binlog_max_flush_queue_time_wa...	850 B	-rw-r--r--
binlog_mixed_cache_stat.test	277 B	-rw-r--r--
binlog_mixed_load_data.test	535 B	-rw-r--r--
binlog_mts_logical_clock.test	2.35 KB	-rw-r--r--
binlog_mts_logical_clock_gtid....	318 B	-rw-r--r--
binlog_mysqlbinlog-cp932-maste...	23 B	-rw-r--r--
binlog_mysqlbinlog-cp932.test	1.11 KB	-rw-r--r--
binlog_mysqlbinlog_base64.test	2.64 KB	-rw-r--r--
binlog_mysqlbinlog_concat.test	4.28 KB	-rw-r--r--
binlog_mysqlbinlog_filter.test	2.07 KB	-rw-r--r--
binlog_mysqlbinlog_intvar.test	1.59 KB	-rw-r--r--
binlog_mysqlbinlog_raw.test	3.53 KB	-rw-r--r--
binlog_mysqlbinlog_rewrite_db....	6.58 KB	-rw-r--r--
binlog_mysqlbinlog_row.test	204 B	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	714 B	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	669 B	-rw-r--r--
binlog_mysqlbinlog_row_trans.t...	4.07 KB	-rw-r--r--
binlog_mysqlbinlog_start_stop....	452 B	-rw-r--r--
binlog_mysqlbinlog_start_stop_...	1.95 KB	-rw-r--r--
binlog_nogtid_mix_response_pac...	480 B	-rw-r--r--
binlog_noop_dml_with_readonly....	2.4 KB	-rw-r--r--
binlog_old_versions.test	5.22 KB	-rw-r--r--
binlog_purge_binary_logs_stall...	70 B	-rw-r--r--
binlog_purge_binary_logs_stall...	1.36 KB	-rw-r--r--
binlog_purge_binary_logs_to.te...	3.45 KB	-rw-r--r--
binlog_query_filter_rules-mast...	40 B	-rw-r--r--
binlog_query_filter_rules.test	855 B	-rw-r--r--
binlog_rbr_only_savepoint.test	2.83 KB	-rw-r--r--
binlog_reset_connection_not_re...	3.49 KB	-rw-r--r--
binlog_reset_master.test	996 B	-rw-r--r--
binlog_rewrite.test	2.99 KB	-rw-r--r--
binlog_rewrite_db_noleak.test	2.65 KB	-rw-r--r--
binlog_rewrite_order.test	1.07 KB	-rw-r--r--
binlog_rewrite_suppress_use.te...	2.25 KB	-rw-r--r--
binlog_rotate_bgc_sync.test	3.37 KB	-rw-r--r--
binlog_rotate_deadlock-master....	181 B	-rw-r--r--
binlog_rotate_deadlock.test	1.75 KB	-rw-r--r--
binlog_row_binlog-master.opt	55 B	-rw-r--r--
binlog_row_binlog.test	783 B	-rw-r--r--
binlog_row_cache_stat.test	274 B	-rw-r--r--
binlog_row_create_select_crash...	1.35 KB	-rw-r--r--
binlog_row_ctype_cp932.test	268 B	-rw-r--r--
binlog_row_ctype_ucs.test	272 B	-rw-r--r--
binlog_row_delete_all_rows.tes...	688 B	-rw-r--r--
binlog_row_drop_tbl.test	215 B	-rw-r--r--
binlog_row_drop_tmp_tbl.test	233 B	-rw-r--r--
binlog_row_innodb_stat-master....	26 B	-rw-r--r--
binlog_row_insert_select.test	708 B	-rw-r--r--
binlog_row_kill_create_select....	845 B	-rw-r--r--
binlog_row_mix_innodb_myisam-m...	97 B	-rw-r--r--
binlog_row_mix_innodb_myisam.t...	585 B	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	4.36 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	5.59 KB	-rw-r--r--
binlog_row_query_log_events.te...	942 B	-rw-r--r--
binlog_server_id.test	794 B	-rw-r--r--
binlog_server_start_options-ma...	54 B	-rw-r--r--
binlog_server_start_options.te...	1.14 KB	-rw-r--r--
binlog_set_gtid_mode_ongoing_t...	6.96 KB	-rw-r--r--
binlog_set_trans_dependency_de...	2.24 KB	-rw-r--r--
binlog_sf.test	2.67 KB	-rw-r--r--
binlog_shutdown_hang.test	1.14 KB	-rw-r--r--
binlog_simulate_crash_and_erro...	4.24 KB	-rw-r--r--
binlog_spurious_ddl_errors-mas...	20 B	-rw-r--r--
binlog_spurious_ddl_errors.tes...	4.16 KB	-rw-r--r--
binlog_sql_mode.test	4.75 KB	-rw-r--r--
binlog_start_comment.test	1.01 KB	-rw-r--r--
binlog_start_slave_heartbeat-s...	16 B	-rw-r--r--
binlog_start_slave_heartbeat.t...	1.33 KB	-rw-r--r--
binlog_stm_binlog-master.opt	55 B	-rw-r--r--
binlog_stm_binlog.test	741 B	-rw-r--r--
binlog_stm_blackhole.test	456 B	-rw-r--r--
binlog_stm_cache_stat.test	280 B	-rw-r--r--
binlog_stm_ctype_cp932.test	318 B	-rw-r--r--
binlog_stm_ctype_ucs.test	287 B	-rw-r--r--
binlog_stm_delete_all_rows.tes...	712 B	-rw-r--r--
binlog_stm_do_db-master.opt	38 B	-rw-r--r--
binlog_stm_do_db.test	2.8 KB	-rw-r--r--
binlog_stm_drop_tbl.test	230 B	-rw-r--r--
binlog_stm_drop_tmp_tbl.test	248 B	-rw-r--r--
binlog_stm_innodb_stat-master....	26 B	-rw-r--r--
binlog_stm_insert_select.test	489 B	-rw-r--r--
binlog_stm_mix_innodb_myisam-m...	145 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.t...	552 B	-rw-r--r--
binlog_stm_ps.test	939 B	-rw-r--r--
binlog_stm_row.test	3.38 KB	-rw-r--r--
binlog_stm_unsafe_warning-mast...	51 B	-rw-r--r--
binlog_stm_unsafe_warning.test	5.65 KB	-rw-r--r--
binlog_stm_user_variables.test	3.4 KB	-rw-r--r--
binlog_switch_inside_trans.tes...	7.63 KB	-rw-r--r--
binlog_temporary_tables_user_v...	1.14 KB	-rw-r--r--
binlog_tmp_table.test	4.53 KB	-rw-r--r--
binlog_transaction_dependency_...	90 B	-rw-r--r--
binlog_transaction_dependency_...	8.21 KB	-rw-r--r--
binlog_transaction_dependency_...	2.2 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.98 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.33 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.21 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	4.15 KB	-rw-r--r--
binlog_truncate_kill.test	1.96 KB	-rw-r--r--
binlog_truncate_myisam.test	348 B	-rw-r--r--
binlog_unsafe-master.opt	65 B	-rw-r--r--
binlog_unsafe.test	25.95 KB	-rw-r--r--
binlog_unsafe_stmt_capable_eng...	41 B	-rw-r--r--
binlog_unsafe_stmt_capable_eng...	12.55 KB	-rw-r--r--
binlog_use_gtid_skip.test	1.03 KB	-rw-r--r--
binlog_user_if_exists.test	9.22 KB	-rw-r--r--
binlog_variables_log_bin-maste...	16 B	-rw-r--r--
binlog_variables_log_bin.test	136 B	-rw-r--r--
binlog_variables_log_bin_index...	70 B	-rw-r--r--
binlog_variables_log_bin_index...	136 B	-rw-r--r--
binlog_variables_log_statement...	2.18 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	879 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	2.45 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	633 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	801 B	-rw-r--r--
binlog_write_error.test	2.7 KB	-rw-r--r--
binlog_writeset_history_protec...	3.06 KB	-rw-r--r--
binlog_wrong_last_committed.te...	3.07 KB	-rw-r--r--
binlog_xa_handling.test	3.69 KB	-rw-r--r--
binlog_xa_modify_gtid_executed...	2.93 KB	-rw-r--r--
binlog_xa_prepare_failure.test	2.05 KB	-rw-r--r--
binlog_xa_prepared_disconnect....	628 B	-rw-r--r--
binlog_xa_rollback_failure.tes...	1.4 KB	-rw-r--r--
binlog_xa_select_gtid_executed...	2.41 KB	-rw-r--r--
binlog_xa_trx_gtid_response_pa...	98 B	-rw-r--r--
binlog_xa_trx_gtid_response_pa...	1.1 KB	-rw-r--r--
binlog_xa_trx_split_across_bin...	2.51 KB	-rw-r--r--
disabled.def	404 B	-rw-r--r--
log_builtin_as_identified_by_p...	39 B	-rw-r--r--
log_builtin_as_identified_by_p...	128 B	-rw-r--r--
show_binlog_events_no_lock.tes...	2.27 KB	-rw-r--r--

Code Editor : binlog_error_action.test

###############################################################################
# Bug#11758766:MYSQLD CONTINUES OPERATION WITHOUT LOGGING WHEN BINLOGS
# CANNOT BE WRITTEN
#
# Problem:
# ========
# If an error occurs that prevents mysqld writing to the binary logs (disk
# full, readonly filesystem, etc) then the logs are disabled and operations
# continue. This can lead to out of sync slaves and improper backups.
#
# Test:
# =====
# A new option "binlog_error_action" has been introduced whose values
# are "IGNORE" or "ABORT". When binlogging becomes impossible if user sets
# the variable to "ABORT" server will stop if user sets it to "IGNORE" binlog
# will be turned off and server will continue. 4 different test cases are
# added to check both the behaviours.
###############################################################################
--source include/have_log_bin.inc
--source include/not_embedded.inc
--source include/have_binlog_format_statement.inc
# Don't test this under valgrind, memory leaks will occur
--source include/not_valgrind.inc
--source include/have_debug.inc
--source include/have_debug_sync.inc
# Avoid CrashReporter popup on Mac
--source include/not_crashrep.inc

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");
let $old=`select @@debug`;

--let $saved_binlog_error_action=`SELECT @@GLOBAL.binlog_error_action`

RESET MASTER;

--echo Test case1
# Make binlog index readonly and check the behaviour with ABORT
let $MYSQLD_DATADIR= `select @@datadir`;
let $INDEX=$MYSQLD_DATADIR/master-bin.index;
--chmod 0444 $INDEX

SET GLOBAL binlog_error_action= ABORT_SERVER;
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--error ER_BINLOG_LOGGING_IMPOSSIBLE
flush logs;
--chmod 0666 $INDEX
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

--echo Test case2
# Make MYSQL_BIN_LOG::open_binlog fail with debug simulation and test
# the behaviour in case of ABORT
SET SESSION debug="+d,fault_injection_updating_index";
SET GLOBAL binlog_error_action= ABORT_SERVER;
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--error ER_BINLOG_LOGGING_IMPOSSIBLE
flush logs;
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

--echo Test case3
# Simulate diskfull during opening of binlog and check for diskfull error
# behaviour where binlogging impossible error is to abort the server.
SET SESSION debug="+d,simulate_disk_full_on_open_binlog";
SET GLOBAL binlog_error_action= ABORT_SERVER;
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--error ER_BINLOG_LOGGING_IMPOSSIBLE
flush logs;
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

--echo Test case4
SET SESSION debug="+d,fault_injection_init_name";
SET GLOBAL binlog_error_action= ABORT_SERVER;
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--error ER_BINLOG_LOGGING_IMPOSSIBLE
flush logs;
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

--echo Test case5
# Make binlog index readonly and check the behaviour with IGNORE
SET GLOBAL binlog_error_action= IGNORE_ERROR;
--chmod 0444 $INDEX
--replace_regex /\.[\\\/]master/master/ /errno: 13 - .*\)/errno: 13 - Permission denied)/
--error 29
flush logs;
CREATE TABLE t1 ( f int );
SHOW TABLES;
DROP TABLE t1;
--chmod 0666 $INDEX
--source include/restart_mysqld.inc

--echo Test case6
# Make MYSQL_BIN_LOG::open_binlog fail with debug simulation and test
# the behaviour in case of IGNORE
SET SESSION debug="+d,fault_injection_updating_index";
SET GLOBAL binlog_error_action= IGNORE_ERROR;
--replace_regex /\.[\\\/]master/master/ /errno: 1 - .*\)/errno: 1 - Operation not permitted)/
--error ER_CANT_OPEN_FILE
flush logs;
CREATE TABLE t2 (f int );
SHOW TABLES;
DROP TABLE t2;
SET SESSION debug="-d,fault_injection_updating_index";
--source include/restart_mysqld.inc

--echo Test case7
# Simulate diskfull during opening of binlog and check for diskfull error
# behaviour where binlogging impossible error is to continue the server
# after the error.
SET GLOBAL binlog_error_action= IGNORE_ERROR;
SET SESSION debug="+d,simulate_disk_full_on_open_binlog";
--replace_regex /\.[\\\/]master/master/ /Errcode: 28 - .*\)/Errcode: 28 - No space left on device)/
# error EE_WRITE with error code number 3 is expected.
--error 3
flush logs;
SET SESSION debug="-d,simulate_disk_full_on_open_binlog";
--source include/restart_mysqld.inc

--echo Test case8
SET GLOBAL binlog_error_action= IGNORE_ERROR;
SET SESSION debug="+d,fault_injection_init_name";
--replace_regex /\.[\\\/]master/master/ /errno: 1 - .*\)/errno: 1 - Operation not permitted)/
--error ER_CANT_OPEN_FILE
flush logs;
CREATE TABLE t2 (f int );
SHOW TABLES;
DROP TABLE t2;
SET SESSION debug="-d,fault_injection_init_name";
--source include/restart_mysqld.inc

###############################################################################
# Bug#20805298: BINLOG_ERROR_ACTION DOESN'T HANDLE SOME
# FAILURES DURING BINLOG ROTATION
#
# Problem:
# ========
# Hardware errors in binlog partition during binlog rotate are not handled by
# binlog_error_action.
#
# Test:
# =====
# Simulate failure during creation of new binary log file name. Set
# binlog_error_action to "IGNORE_ERROR" and observe that the binary log gets
# disabled and the server continues by logging an appropriate error message in
# error log file. Set binlog_error_action to "ABORT_ERROR" and observe that
# the
# server aborts when creation of new binarylog file name fails.
###############################################################################
--echo Test case09
# Test error scenario with binlog_error_action=IGNORE_ERROR
SET GLOBAL binlog_error_action= IGNORE_ERROR;
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
SET SESSION debug='+d,error_unique_log_filename';
--error ER_NO_UNIQUE_LOGFILE
FLUSH LOGS;
DROP TABLE t1;
eval SET SESSION debug="$debug_save";
# Test to prove that binary log is disabled
--error ER_NO_BINARY_LOGGING
SHOW BINARY LOGS;
--source include/restart_mysqld.inc

--echo Test case10
# Test error scenario with binlog_error_action=ABORT_SERVER

CREATE TABLE t1 (a INT) ENGINE=InnoDB;
SET GLOBAL binlog_error_action=ABORT_SERVER;
SET SESSION debug='+d,error_unique_log_filename';
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--error ER_BINLOG_LOGGING_IMPOSSIBLE
FLUSH LOGS;
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc
DROP TABLE t1;

###############################################################################
# BUG#16666407BINLOG WRITE ERRORS SILENTLY IGNORED
# BUG#20938915 2PC SUCCEEDS EVEN THOUGH BINLOG FLUSH/SYNC FAILS
###############################################################################

############################
--echo Test case11
############################

# Simulate error during flushing cache to file and test the behaviour
# when binlog_error_action is set to ABORT_SERVER/IGNORE_ERROR.

# Case 11.1 (binlog_error_action = ABORT_SERVER)
--source include/shutdown_mysqld.inc
--remove_file $MYSQLTEST_VARDIR/tmp/binlog_error_action.err
--source include/start_mysqld.inc
RESET MASTER;

CREATE TABLE t1(i INT);
--let $log_pos_before = query_get_value("SHOW BINARY LOGS", File_size, 1)
SET SESSION debug = "+d,simulate_error_during_flush_cache_to_file";
SET GLOBAL binlog_error_action = ABORT_SERVER;
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect

# Check that flush error causing server to abort and client gets
# ER_BINLOG_LOGGING_IMPOSSIBLE when binlog_error_action= 'ABORT_SERVER'.
--error ER_BINLOG_LOGGING_IMPOSSIBLE
INSERT INTO t1 VALUES (1);
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

# Check that error present in error log
--let SEARCH_FILE = $MYSQLTEST_VARDIR/tmp/binlog_error_action.err
--let SEARCH_PATTERN = An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'.
--source include/search_pattern_in_file.inc

# Check that transaction is not committed
--let $assert_cond= COUNT(*) = 0 FROM t1;
--let $assert_text= Count of elements in t1 should be 0.
--source include/assert.inc

# Check that transaction is not binlogged as well
--let $log_pos_after = query_get_value("SHOW BINARY LOGS", File_size, 1)
--let $assert_cond = $log_pos_before = $log_pos_after
--let $assert_text = Query is not binlogged as expected.
--source include/assert.inc

# Case 11.2 (binlog_error_action = IGNORE_ERROR)
RESET MASTER;
--let $log_pos_before = query_get_value("SHOW BINARY LOGS", File_size, 1)
SET SESSION debug ="+d,simulate_error_during_flush_cache_to_file";
SET GLOBAL binlog_error_action= IGNORE_ERROR;
INSERT INTO t1 VALUES (2);

# Check that transaction is committed
--let $assert_cond = COUNT(*) = 1 FROM t1;
--let $assert_text = Count of elements in t1 should be 1.
--source include/assert.inc

# Restart so that binary log is enabled again and we can do the below test
--source include/restart_mysqld.inc

# Check that transaction is not binlogged
--let $log_pos_after = query_get_value("SHOW BINARY LOGS", File_size, 1)
--let $assert_cond = $log_pos_before = $log_pos_after
--let $assert_text = Query is not binlogged as expected.
--source include/assert.inc

# Check that error present in error log
--let SEARCH_FILE = $MYSQLTEST_VARDIR/tmp/binlog_error_action.err
--let SEARCH_PATTERN = An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'IGNORE_ERROR'.
--source include/search_pattern_in_file.inc

# Cleanup
DROP TABLE t1;
RESET MASTER;

############################
--echo Test case12
############################

# Simulate error during syncing binlog file and test the behaviour
# when binlog_error_action is set to ABORT_SERVER/IGNORE_ERROR.
# Set sync_binlog=1 just to make sure that logic enters into sync phase.

# Case 12.1 (binlog_error_action = ABORT_SERVER)
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;
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect

# Check that sync error causing server to abort and client gets
# ER_BINLOG_LOGGING_IMPOSSIBLE when binlog_error_action= 'ABORT_SERVER'.
--error ER_BINLOG_LOGGING_IMPOSSIBLE
INSERT INTO t1 VALUES (1);

--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

# Cleanup
DELETE FROM t1;
RESET MASTER;

# Case 12.2 (binlog_error_action = IGNORE_ERROR)
SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
SET GLOBAL binlog_error_action = IGNORE_ERROR;
INSERT INTO t1 VALUES (2);

# Check that transaction is committed
--let $assert_cond = COUNT(*) = 1 FROM t1;
--let $assert_text = Count of elements in t1 should be 1.
--source include/assert.inc

# Cleanup
DROP table t1;
SET SESSION debug = "-d,simulate_error_during_sync_binlog_file";
--source include/restart_mysqld.inc
RESET MASTER;

############################
--echo Test case13
############################

# Simulate error during flushing events to binlog cache and test the behaviour
# when binlog_error_action is set to ABORT_SERVER/IGNORE_ERROR.

# Case 13.1 (binlog_error_action = ABORT_SERVER)
CREATE TABLE t1(i INT);
--let $log_pos_before = query_get_value("SHOW BINARY LOGS", File_size, 1)
SET SESSION debug = "+d,simulate_do_write_cache_failure";
SET GLOBAL binlog_error_action = ABORT_SERVER;
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect

# Check that write cache error is causing server to abort and client gets
# ER_BINLOG_LOGGING_IMPOSSIBLE when binlog_error_action= 'ABORT_SERVER'.
--error ER_BINLOG_LOGGING_IMPOSSIBLE
INSERT INTO t1 VALUES (1);
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

# Check that transaction is not committed
--let $assert_cond = COUNT(*) = 0 FROM t1;
--let $assert_text = Count of elements in t1 should be 0.
--source include/assert.inc

# Cleanup
RESET MASTER;

# Case 13.2 (binlog_error_action = IGNORE_ERROR)
SET SESSION debug = "+d,simulate_do_write_cache_failure";
SET GLOBAL binlog_error_action = IGNORE_ERROR;
INSERT INTO t1 VALUES (2);

# Check that transaction is committed (binlog check cannot be done
# as we would have written STOP_EVENT in the binlog while closing
# it)
--let $assert_cond = COUNT(*) = 1 FROM t1;
--let $assert_text = Count of elements in t1 should be 1.
--source include/assert.inc

# Cleanup
DROP table t1;
--source include/restart_mysqld.inc
RESET MASTER;

############################
--echo Test case14
############################

# Simulating a situation when a transaction is about to
# enter ordered_commit and another transaction closed
# binary log due to an error.

SET GLOBAL binlog_error_action = IGNORE_ERROR;
SET GLOBAL sync_binlog = 1;
CREATE TABLE t1(i INT);
CREATE TABLE t2(i INT);
connect(con1,localhost,root,,);
connect(con2,localhost,root,,);

--connection con1
SET DEBUG_SYNC = "bgc_before_flush_stage SIGNAL about_to_enter_flush_stage WAIT_FOR binlog_closed";
--send INSERT INTO t1 values (1);

--connection default
SET DEBUG_SYNC = "now wait_for about_to_enter_flush_stage";

--connection con2
SET DEBUG_SYNC = "after_binlog_closed_due_to_error SIGNAL binlog_closed";
SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
--send INSERT INTO t2 values (2);

--connection con1
--reap
--connection con2
--reap

# Cleanup
--disconnect con1
--disconnect con2

--connection default
DROP table t1, t2;
--source include/restart_mysqld.inc

############################
--echo Test case15
############################

# Simulating a situation when a transaction is about to
# close binary log due to a sync error (about to acquire lock_log)
# and another transaction in the middle of flush stage (holding
# lock_log.

SET GLOBAL binlog_error_action = IGNORE_ERROR;
SET GLOBAL sync_binlog = 1;
CREATE TABLE t1(i INT);
CREATE TABLE t2(i INT);
connect(con1,localhost,root,,);
connect(con2,localhost,root,,);

--connection con1
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";
--send INSERT INTO t1 values (1);

--connection default
SET DEBUG_SYNC = "now wait_for binlog_about_to_be_closed";

--connection con2
SET DEBUG_SYNC = "waiting_in_the_middle_of_flush_stage SIGNAL in_the_middle_of_flush_stage";
--send INSERT INTO t2 values (2);

--connection con1
--reap
--connection con2
--reap

# Claenup
--disconnect con1
--disconnect con2

--connection default
DROP table t1, t2;
--source include/shutdown_mysqld.inc
--remove_file $MYSQLTEST_VARDIR/tmp/binlog_error_action.err
--source include/start_mysqld.inc

############################
--echo Test case16
############################

# Simulating a situation where two binlog groups encounter
# errors (one flush error, one sync error) at the same time
# and both of them try to close the binary log.

SET GLOBAL binlog_error_action = IGNORE_ERROR;
SET GLOBAL sync_binlog = 1;
CREATE TABLE t1(i INT);
CREATE TABLE t2(i INT);
connect(con1,localhost,root,,);
connect(con2,localhost,root,,);

--connection con1
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";
--send INSERT INTO t1 values (1);

--connection default
SET DEBUG_SYNC = "now wait_for binlog_about_to_be_closed";

--connection con2
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";
--send INSERT INTO t2 values (2);

--connection con1
--reap
--connection con2
--reap
--replace_regex /[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.[0-9]{6}[-+Z][0-9:]* *[0-9]*/--TIME--/ /flush|sync stage/flush_or_sync stage/
--let GREP_FILE=$MYSQLTEST_VARDIR/tmp/binlog_error_action.err
--let GREP_PATTERN=An error occurred during
--source include/grep_pattern.inc

# Claenup
--disconnect con1
--disconnect con2

--connection default
DROP table t1, t2;
--source include/restart_mysqld.inc

${this.title}

Code Editor : binlog_error_action.test