Gecko [ 122.154.134.11 ]

Name	Size	Permission
binlog_base64_flag.test	5.38 KB	-rw-r--r--
binlog_bug23533.test	1.45 KB	-rw-r--r--
binlog_bug36391-master.opt	32 B	-rw-r--r--
binlog_bug36391.test	1023 B	-rw-r--r--
binlog_database.test	369 B	-rw-r--r--
binlog_delete_and_flush_index....	3.49 KB	-rw-r--r--
binlog_drop_if_exists.test	3.47 KB	-rw-r--r--
binlog_grant.test	1.82 KB	-rw-r--r--
binlog_incident-master.opt	52 B	-rw-r--r--
binlog_incident.test	939 B	-rw-r--r--
binlog_index-master.opt	16 B	-rw-r--r--
binlog_index.test	7.34 KB	-rw-r--r--
binlog_innodb.test	3.97 KB	-rw-r--r--
binlog_innodb_row.test	2.19 KB	-rw-r--r--
binlog_killed.test	8.21 KB	-rw-r--r--
binlog_killed_simulate-master....	39 B	-rw-r--r--
binlog_killed_simulate.test	2.54 KB	-rw-r--r--
binlog_mix_innodb_stat.test	230 B	-rw-r--r--
binlog_mixed_failure_mixing_en...	143 B	-rw-r--r--
binlog_mixed_load_data.test	501 B	-rw-r--r--
binlog_multi_engine.test	2.78 KB	-rw-r--r--
binlog_mysqlbinlog-cp932-maste...	23 B	-rw-r--r--
binlog_mysqlbinlog-cp932.test	975 B	-rw-r--r--
binlog_mysqlbinlog2.test	7.07 KB	-rw-r--r--
binlog_mysqlbinlog_base64.test	2.45 KB	-rw-r--r--
binlog_mysqlbinlog_row.test	10.67 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	638 B	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	631 B	-rw-r--r--
binlog_mysqlbinlog_row_trans.t...	3.71 KB	-rw-r--r--
binlog_old_versions.test	4.99 KB	-rw-r--r--
binlog_query_filter_rules-mast...	40 B	-rw-r--r--
binlog_query_filter_rules.test	808 B	-rw-r--r--
binlog_reset_master.test	998 B	-rw-r--r--
binlog_row_binlog-master.opt	24 B	-rw-r--r--
binlog_row_binlog.test	223 B	-rw-r--r--
binlog_row_ctype_cp932.test	228 B	-rw-r--r--
binlog_row_ctype_ucs.test	234 B	-rw-r--r--
binlog_row_drop_tmp_tbl.test	232 B	-rw-r--r--
binlog_row_failure_mixing_engi...	141 B	-rw-r--r--
binlog_row_innodb_stat-master....	26 B	-rw-r--r--
binlog_row_innodb_stat.test	228 B	-rw-r--r--
binlog_row_insert_select.test	471 B	-rw-r--r--
binlog_row_mix_innodb_myisam-m...	29 B	-rw-r--r--
binlog_row_mix_innodb_myisam.t...	545 B	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	4.12 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	3.76 KB	-rw-r--r--
binlog_server_id.test	663 B	-rw-r--r--
binlog_sf.test	2.67 KB	-rw-r--r--
binlog_sql_mode.test	4.58 KB	-rw-r--r--
binlog_start_comment.test	900 B	-rw-r--r--
binlog_statement_insert_delaye...	336 B	-rw-r--r--
binlog_stm_binlog-master.opt	40 B	-rw-r--r--
binlog_stm_binlog.test	483 B	-rw-r--r--
binlog_stm_blackhole.test	267 B	-rw-r--r--
binlog_stm_ctype_cp932.test	278 B	-rw-r--r--
binlog_stm_ctype_ucs.test	249 B	-rw-r--r--
binlog_stm_do_db-master.opt	38 B	-rw-r--r--
binlog_stm_do_db.test	2.78 KB	-rw-r--r--
binlog_stm_drop_tmp_tbl.test	247 B	-rw-r--r--
binlog_stm_innodb_stat-master....	26 B	-rw-r--r--
binlog_stm_innodb_stat.test	234 B	-rw-r--r--
binlog_stm_insert_select.test	252 B	-rw-r--r--
binlog_stm_mix_innodb_myisam-m...	29 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.t...	512 B	-rw-r--r--
binlog_stm_ps.test	701 B	-rw-r--r--
binlog_stm_row.test	3.06 KB	-rw-r--r--
binlog_stm_unsafe_warning-mast...	38 B	-rw-r--r--
binlog_stm_unsafe_warning.test	3.7 KB	-rw-r--r--
binlog_tmp_table.test	3.94 KB	-rw-r--r--
binlog_truncate_innodb-master....	14 B	-rw-r--r--
binlog_truncate_innodb.test	1.07 KB	-rw-r--r--
binlog_truncate_myisam.test	352 B	-rw-r--r--
binlog_unsafe.test	13.34 KB	-rw-r--r--
binlog_write_error.test	2.31 KB	-rw-r--r--
disabled.def	634 B	-rw-r--r--

Code Editor : binlog_delete_and_flush_index.test

# BUG#34582: FLUSH LOGS does not close and reopen the binlog index
# file
#
# WHAT
# ==== 
#
# We want to test that FLUSH LOGS closes and reopens binlog index
# file.
#
# HOW
# === 
#
#  PREPARE:
#   1. create some binlog events
#   2. show index content, binlog events and binlog contents 
#      for mysql-bin.000001
#   3. copy the mysql-bin.000001 to mysql-bin-b34582.000001
#   4. change the index file so that mysql-bin.000001 is replaced 
#      with mysql-bin-b34582.000001
#   5. FLUSH the logs so that new index is closed and reopened
#
#  ASSERTIONS:
#   1. index file contents shows mysql-bin-b34582.000001 and 
#      mysql-bin.000002
#   1. show binary logs shows current index entries
#   2. binlog contents for mysql-bin-b34582.000001 are displayed
#   3. Purge binlogs up to the latest one succeeds
#   4. SHOW BINARY LOGS presents the latest one only after purging
#   5. Purged binlogs files don't exist in the filesystem
#   6. Not purged binlog file exists in the filesystem
#
#  CLEAN UP:
#   1. RESET MASTER
#

-- source include/have_log_bin.inc

RESET MASTER;

-- let $datadir= `SELECT @@datadir`
-- let $index=$datadir/master-bin.index
-- chmod 0644 $index

# action: issue one command so that binlog gets some event
CREATE TABLE t1 (a int);

-- echo ### assertion: index file contains regular entries
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
-- eval SET @index=LOAD_FILE('$index')
-- replace_regex /\.[\\\/]master/master/
SELECT @index;

--echo ### assertion: show original binlogs
-- source include/show_binary_logs.inc

--echo ### assertion: binlog contents from regular entries
-- source include/show_binlog_events.inc

# action: copy binlogs to other names and change entries in index file
-- copy_file $datadir/master-bin.000001 $datadir/master-bin-b34582.000001
let INDEX_FILE=$index;
perl;
$file= $ENV{'INDEX_FILE'};
open(FILE, ">$file") || die "Unable to open $file.";
truncate(FILE,0);
close ($file);
EOF

-- append_file $index 
master-bin-b34582.000001
EOF

# action: should cause rotation, and creation of new binlogs
FLUSH LOGS;

# file is not used anymore - remove it (mysql closed on flush logs).
-- remove_file $datadir/master-bin.000001

-- echo ### assertion: index file contains renamed binlog and the new one
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
-- eval SET @index=LOAD_FILE('$index')
-- replace_regex /\.[\\\/]master/master/
SELECT @index;

-- echo ### assertion: original binlog content still exists, despite we
-- echo ###            renamed and changed the index file 
-- source include/show_binlog_events.inc

-- echo ### assertion: user changed binlog index shows correct entries
-- source include/show_binary_logs.inc

DROP TABLE t1;

-- echo ### assertion: purging binlogs up to binlog created after instrumenting index file should work
-- let $current_binlog= query_get_value(SHOW MASTER STATUS, File, 1)
-- eval PURGE BINARY LOGS TO '$current_binlog'

-- echo ### assertion: show binary logs should only contain latest binlog
-- source include/show_binary_logs.inc

-- echo ### assertion: assert that binlog files were indeed purged (using file_exists calls)
-- error 1
-- file_exists $datadir/master-bin-b34852.000001

-- echo ### assertion: assert that not purged binlog file exists
-- file_exists $datadir/$current_binlog

-- echo ### assertion: show index file contents and these should match show binary logs issued above
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
-- eval SET @index=LOAD_FILE('$index')
-- replace_regex /\.[\\\/]master/master/
SELECT @index;

RESET MASTER;

${this.title}

Code Editor : binlog_delete_and_flush_index.test