Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.224.5.46
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
binlog /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
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--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : binlog_index.test
# # testing of purging of binary log files bug#18199/Bug#18453 # source include/have_log_bin.inc; source include/not_embedded.inc; # Don't test this under valgrind, memory leaks will occur --source include/not_valgrind.inc source include/have_debug.inc; # Avoid CrashReporter popup on Mac --source include/not_crashrep.inc call mtr.add_suppression('Attempting backtrace'); call mtr.add_suppression('MYSQL_BIN_LOG::purge_logs failed to process registered files that would be purged.'); call mtr.add_suppression('MYSQL_BIN_LOG::open failed to sync the index file'); call mtr.add_suppression('Turning logging off for the whole duration of the MySQL server process.'); call mtr.add_suppression('Could not open .*'); call mtr.add_suppression('MYSQL_BIN_LOG::purge_logs failed to clean registers before purging logs.'); let $old=`select @@debug`; let $saved_binlog_error_action=`SELECT @@GLOBAL.binlog_error_action`; RESET MASTER; let $MYSQLD_DATADIR= `select @@datadir`; let $INDEX=$MYSQLD_DATADIR/master-bin.index; # # testing purge binary logs TO # flush logs; flush logs; flush logs; source include/show_binary_logs.inc; remove_file $MYSQLD_DATADIR/master-bin.000001; # there must be a warning with file names replace_regex /\.[\\\/]master/master/; purge binary logs TO 'master-bin.000004'; --echo *** must show a list starting from the 'TO' argument of PURGE *** source include/show_binary_logs.inc; # # testing purge binary logs BEFORE # reset master; flush logs; flush logs; flush logs; remove_file $MYSQLD_DATADIR/master-bin.000001; --echo *** must be a warning master-bin.000001 was not found *** let $date=`select NOW() + INTERVAL 1 MINUTE`; --disable_query_log replace_regex /\.[\\\/]master/master/; eval purge binary logs BEFORE '$date'; --enable_query_log --echo *** must show one record, of the active binlog, left in the index file after PURGE *** source include/show_binary_logs.inc; # # testing a fatal error # Turning a binlog file into a directory must be a portable setup # reset master; flush logs; flush logs; flush logs; remove_file $MYSQLD_DATADIR/master-bin.000001; mkdir $MYSQLD_DATADIR/master-bin.000001; --error ER_BINLOG_PURGE_FATAL_ERR purge binary logs TO 'master-bin.000002'; replace_regex /\.[\\\/]master/master/; show warnings; rmdir $MYSQLD_DATADIR/master-bin.000001; --disable_warnings reset master; --enable_warnings --echo # crash_purge_before_update_index flush logs; --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect SET SESSION debug="+d,crash_purge_before_update_index"; --error 2013 purge binary logs TO 'master-bin.000002'; --enable_reconnect --source include/wait_until_connected_again.inc file_exists $MYSQLD_DATADIR/master-bin.000001; file_exists $MYSQLD_DATADIR/master-bin.000002; file_exists $MYSQLD_DATADIR/master-bin.000003; --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --echo # crash_purge_non_critical_after_update_index flush logs; --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect SET SESSION debug="+d,crash_purge_non_critical_after_update_index"; --error 2013 purge binary logs TO 'master-bin.000004'; --enable_reconnect --source include/wait_until_connected_again.inc --error 1 file_exists $MYSQLD_DATADIR/master-bin.000001; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000002; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000003; --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --echo # crash_purge_critical_after_update_index flush logs; --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect SET SESSION debug="+d,crash_purge_critical_after_update_index"; --error 2013 purge binary logs TO 'master-bin.000006'; --enable_reconnect --source include/wait_until_connected_again.inc --error 1 file_exists $MYSQLD_DATADIR/master-bin.000004; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000005; file_exists $MYSQLD_DATADIR/master-bin.000006; file_exists $MYSQLD_DATADIR/master-bin.000007; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000008; --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --echo # crash_create_non_critical_before_update_index --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect SET SESSION debug="+d,crash_create_non_critical_before_update_index"; --error 2013 flush logs; --enable_reconnect --source include/wait_until_connected_again.inc file_exists $MYSQLD_DATADIR/master-bin.000008; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000009; --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --echo # crash_create_critical_before_update_index --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect SET SESSION debug="+d,crash_create_critical_before_update_index"; --error 2013 flush logs; --enable_reconnect --source include/wait_until_connected_again.inc file_exists $MYSQLD_DATADIR/master-bin.000009; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000010; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000011; --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --echo # crash_create_after_update_index --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect SET SESSION debug="+d,crash_create_after_update_index"; --error 2013 flush logs; --enable_reconnect --source include/wait_until_connected_again.inc file_exists $MYSQLD_DATADIR/master-bin.000010; file_exists $MYSQLD_DATADIR/master-bin.000011; --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --echo # --echo # This should put the server in unsafe state and stop --echo # accepting any command. If we inject a fault at this --echo # point and continue the execution the server crashes. --echo # --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --echo # fault_injection_registering_index SET SESSION debug="+d,fault_injection_registering_index"; SET GLOBAL binlog_error_action= IGNORE_ERROR; # normalize strerror message for solaris10-sparc-64bit as long as errno is OK -- replace_regex /\.[\\\/]master/master/ /errno: 1 - .*\)/errno: 1 - Operation not permitted)/ -- error ER_CANT_OPEN_FILE flush logs; --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --source include/restart_mysqld.inc --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --echo # fault_injection_updating_index SET SESSION debug="+d,fault_injection_updating_index"; SET GLOBAL binlog_error_action= IGNORE_ERROR; # normalize strerror message for solaris10-sparc-64bit as long as errno is OK -- replace_regex /\.[\\\/]master/master/ /errno: 1 - .*\)/errno: 1 - Operation not permitted)/ -- error ER_CANT_OPEN_FILE flush logs; --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; --source include/restart_mysqld.inc --chmod 0644 $INDEX -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -- eval SET @index=LOAD_FILE('$index') -- replace_regex /\.[\\\/]master/master/ SELECT @index; # # WL#5493 # Test case6 verifies if the index file has the correct data, # i.e. if binlog file name is added after the master restarts # when setting DEBUG POINT before renaming index file. # # Test case7 verifies if the index file has the correct data, # i.e. if binlog file name is added after the master restarts # when setting DEBUG POINT after renaming index file. # # Test case8 verifies if the index file has the correct data, # i.e. if requested binlog file names are removed after the # master restarts when setting DEBUG POINT after purging index # file. # # Test case9 verifies if the index file has the correct data, # i.e. if requested binlog file names are removed after the # master restarts when setting DEBUG POINT before purging index # file. # # Test case10 verifies if the index file has the correct data, # i.e. although requested binlog file names are not removed # after the master restarts when injecting a fault to the # temp file in the process of purging the index file. # -- echo # Test case6: Set DEBUG POINT before rename index file when -- echo # appending a binlog file name to index file. -- source include/show_binary_logs.inc file_exists $MYSQLD_DATADIR/master-bin.000013; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000014; # Write file to make mysql-test-run.pl expect crash and restart SET SESSION debug="+d,crash_create_before_rename_index_file"; -- exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect --error 2013 flush logs; -- source include/wait_until_disconnected.inc -- enable_reconnect -- echo # Restart the master server -- exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- source include/wait_until_connected_again.inc -- disable_reconnect -- echo # Test if the index file has the correct data, -- echo # i.e. binlog file name is added. -- source include/show_binary_logs.inc file_exists $MYSQLD_DATADIR/master-bin.000014; file_exists $MYSQLD_DATADIR/master-bin.000015; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000016; -- echo # Test case7: Set DEBUG POINT after rename index file when -- echo # appending a binlog file name to index file. # Write file to make mysql-test-run.pl expect crash and restart SET SESSION debug="+d,crash_create_after_rename_index_file"; -- exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- error 2013 flush logs; -- source include/wait_until_disconnected.inc -- enable_reconnect -- echo # Restart the master server -- exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- source include/wait_until_connected_again.inc -- disable_reconnect -- echo # Test if the index file has the correct data, -- echo # i.e. binlog file name is added. -- source include/show_binary_logs.inc file_exists $MYSQLD_DATADIR/master-bin.000016; file_exists $MYSQLD_DATADIR/master-bin.000017; --error 1 file_exists $MYSQLD_DATADIR/master-bin.000018; -- echo # Test case8: Set DEBUG POINT after rename index file when -- echo # purging the index file. -- source include/show_binary_logs.inc # Write file to make mysql-test-run.pl expect crash and restart SET SESSION debug="+d,crash_create_after_rename_index_file"; -- exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- error 2013 purge binary logs TO 'master-bin.000010'; -- source include/wait_until_disconnected.inc -- enable_reconnect -- echo # Restart the master server -- exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- source include/wait_until_connected_again.inc -- disable_reconnect -- echo # Test if the index file has the correct data, -- echo # i.e. requested binlog file names are removed. -- source include/show_binary_logs.inc -- error 1 file_exists $MYSQLD_DATADIR/master-bin.000008; -- error 1 file_exists $MYSQLD_DATADIR/master-bin.000009; file_exists $MYSQLD_DATADIR/master-bin.000010; -- echo # Test case9: Set DEBUG POINT befor rename index file when -- echo # purging the index file. -- source include/show_binary_logs.inc # Write file to make mysql-test-run.pl expect crash and restart SET SESSION debug="+d,crash_create_before_rename_index_file"; -- exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- error 2013 purge binary logs TO 'master-bin.000012'; -- source include/wait_until_disconnected.inc -- enable_reconnect -- echo # Restart the master server -- exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- source include/wait_until_connected_again.inc -- disable_reconnect -- echo # Test if the index file has the correct data, -- echo # i.e. requested binlog file names are removed. -- source include/show_binary_logs.inc -- error 1 file_exists $MYSQLD_DATADIR/master-bin.000010; -- error 1 file_exists $MYSQLD_DATADIR/master-bin.000011; file_exists $MYSQLD_DATADIR/master-bin.000012; -- echo # Test case10: Inject a fault to copy part content to the temp file -- echo # when purging the index file. -- source include/show_binary_logs.inc # Write file to make mysql-test-run.pl expect crash and restart SET SESSION debug="+d,fault_injection_copy_part_file"; -- exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- error 2013 purge binary logs TO 'master-bin.000014'; -- source include/wait_until_disconnected.inc -- enable_reconnect -- echo # Restart the master server -- exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect -- source include/wait_until_connected_again.inc -- disable_reconnect -- echo # Test the index file is complete, although is not purged successfully. -- source include/show_binary_logs.inc file_exists $MYSQLD_DATADIR/master-bin.000012; file_exists $MYSQLD_DATADIR/master-bin.000013; file_exists $MYSQLD_DATADIR/master-bin.000014; -- echo # Test case11: Bug #20381055SERVER CRASHES IF INDEX FILE IS OPENED BY # OTHER APPLICATION AND PURGE IS ISSUED. # This test case test the server behaviour if index file cannot be # deleted. SET SESSION debug="d,force_index_file_delete_failure"; # Add supressions call mtr.add_suppression("Failed to delete the existing index file"); call mtr.add_suppression("failed to move crash safe index file to index file"); call mtr.add_suppression("failed to update the index file"); # When index file cannot be recreated during purge binary logs command, # it should throw error but it should not disable binary logging. -- error ER_IO_ERR_LOG_INDEX_READ -- eval PURGE BINARY LOGS TO 'master-bin.000014'; -- echo # Test the index file is complete, although is not purged successfully. -- echo # Also this will indicate that binary logging is not disabled. -- source include/show_binary_logs.inc file_exists $MYSQLD_DATADIR/master-bin.000012; file_exists $MYSQLD_DATADIR/master-bin.000013; file_exists $MYSQLD_DATADIR/master-bin.000014; # When index file cannot be recreated during FLUSH LOGS command, # it should throw error and binary logging should be disabled. SET GLOBAL binlog_error_action='IGNORE_ERROR'; # normalize strerror message for solaris10-sparc-64bit as long as errno is OK --replace_regex /\.[\\\/]master/master/ /errno: 1 - .*\)/errno: 1 - Operation not permitted)/ --error ER_CANT_OPEN_FILE FLUSH LOGS; --error ER_NO_BINARY_LOGGING SHOW BINARY LOGS; --source include/restart_mysqld.inc --source include/show_binary_logs.inc CREATE TABLE t1(i INT); SET GLOBAL binlog_error_action='IGNORE_ERROR'; SET SESSION debug="+d,force_index_file_delete_failure"; SET SESSION debug="+d,force_rotate"; # When index file cannot be recreated during DML command which # is trying to rotate the binary log, it should throw error and # binary logging should be disabled. # normalize strerror message for solaris10-sparc-64bit as long as errno is OK --replace_regex /\.[\\\/]master/master/ /errno: 1 - .*\)/errno: 1 - Operation not permitted)/ --error ER_CANT_OPEN_FILE INSERT INTO t1 VALUES (12); --error ER_NO_BINARY_LOGGING SHOW BINARY LOGS; --source include/restart_mysqld.inc -- source include/show_binary_logs.inc DROP TABLE t1; eval SET SESSION debug="$old"; -- echo # Test case11: Ends --echo # Test case12: Bug#25839610 ABORT OCCUR DURING SLAVE BACKUP --echo # WHEN RELAY LOG INDEX IS LOCK --echo # This test verifies that serveral retries are performed --echo # if there is a failure while deleting/renaming index files. --disable_warnings SET SESSION debug="+d,simulate_index_file_delete_failure"; SET SESSION debug="+d,simulate_crash_safe_index_file_rename_failure"; FLUSH LOGS; # Check that delete retry is present in the error log --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err --let $assert_only_after = CURRENT_TEST: binlog.binlog_index --let $assert_count = 5 --let $assert_select = Retrying delete --let $assert_text = Retried for delete. --source include/assert_grep.inc # Check that rename retry is present in the error log --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err --let $assert_only_after = CURRENT_TEST: binlog.binlog_index --let $assert_count = 5 --let $assert_select = Retrying rename --let $assert_text = Retried for rename. --source include/assert_grep.inc --enable_warnings eval SET SESSION debug="$old"; --echo # Test case12: Ends eval SET GLOBAL binlog_error_action= $saved_binlog_error_action; # Reset Master deletes all binary log files listed in the index file, resets # the binary log index file to be empty and creates a new binary log file. RESET MASTER; --echo End of tests
Close