[ Avaa Bypassed ]




Upload:

Command:

hmhc3928@3.15.192.89: ~ $
# ==== Purpose ====
#
# Test if statements used temporary tables are binlogged correctly
#
# ==== Method ====
#
# Use two connections, use temporary tables on both of them, and by
# switching connections between statements, the test can check if the
# statements are logged with the correct thread id.
# 
# The statements current tested include:
#   CREATE TEMPORARY TABLE
#   CREATE TEMPORARY TABLE LIKE
#   INSERT
#   REPLACE
#   UPDATE
#   INSERT SELECT
#   TRUNCATE
#
# Note: When adding new query statements, please add them between the
# two 'flush logs'. And aslo please make sure the connection is
# switched between each statement.
#
# ==== Related bugs ====
#
# BUG#35583 mysqlbinlog replay fails with ERROR 1146 when temp tables are used
#
source include/have_log_bin.inc;
source include/have_binlog_format_mixed_or_statement.inc;

RESET MASTER;

--disable_query_log
CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
--enable_query_log

connect (master,127.0.0.1,root,,test,$MASTER_MYPORT,);
connect (master1,127.0.0.1,root,,test,$MASTER_MYPORT,);

create table foo (a int);

flush logs;

connection master;
create temporary table tmp1_foo like foo;
connection master1;
create temporary table tmp2_foo (a int);

connection master;
insert into tmp1_foo values (1), (2), (3), (4);
connection master1;
replace into tmp2_foo values (1), (2), (3), (4);

connection master;
update tmp1_foo set a=2*a-1;
connection master1;
update tmp2_foo set a=2*a;

connection master;
delete from tmp1_foo where a < 5;
connection master1;
delete from tmp2_foo where a < 5;

--disable_warnings
connection master;
insert into foo select * from tmp1_foo;
connection master1;
insert into foo select * from tmp2_foo;
--enable_warnings

connection master;
truncate table tmp1_foo;
connection master1;
truncate table tmp2_foo;

let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1);

flush logs;

connection default;
select * from foo;

# prepare for the replay
drop table foo;
create table foo (a int);

# replay from binary log
let $MYSQLD_DATADIR= `select @@datadir`;
copy_file $MYSQLD_DATADIR/$binlog_file $MYSQLD_DATADIR/master-bin.saved35583;
# Reset GTIDs
RESET MASTER;
exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.saved35583 | $MYSQL;
select * from foo;

# clean up
drop table foo;

#################################################################
# BUG#51226
#################################################################

RESET MASTER;

-- let $dbname=b51226

connect (con1,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
connect (con2,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK);

#
# action: on con1 create the database and the tmp table
# 
-- connection con1
-- eval create database $dbname
-- eval use $dbname
create temporary table t1(i int);

#
# action: on con1 create the tmp table
# 
-- connection con2
-- eval use $dbname
create temporary table t1(i int);

# action: at this point, the last event binlogged contains the
#         pseudo_thread_id from con2. So now we switch to con1, issue
#         a statement that fails and close the connection (which logs
#         implicitely a DROP TEMPORARY TABLE).  
#
#         Before the patch this would not log con1's pseudo_thread_id
#         because the failing statement would reset THD context
#         (unsetting the thread_specific_used flag, and consequently,
#         causing the DROP event to be logged without pseudo_thread_id
#         in its header).

-- connection con1
-- error 1050
create temporary table t1(i int);
-- disconnect con1

-- connection default
-- let $wait_binlog_event= DROP
-- source include/wait_for_binlog_event.inc

# action: insert in the t1. This would cause the the test to fail,
#         because when replaying the binlog the previous implicit drop
#         temp table would have been executed under the wrong
#         pseudo_thread_id, dropping the tmp table on con2.
-- connection con2
insert into t1 values(1);
-- disconnect con2

-- connection default
-- let $wait_binlog_event= DROP
-- source include/wait_for_binlog_event.inc

-- eval DROP DATABASE $dbname
FLUSH LOGS;
-- let $MYSQLD_DATADIR= `select @@datadir`
copy_file $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.saved51226;
# Reset GTIDs
RESET MASTER;
# assertion: assert that when replaying the binary log will succeed,
#            instead of failing with "Table 'XXX.YYY' doesn't exist"
-- exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.saved51226 | $MYSQL

Filemanager

Name Type Size Permission Actions
binlog_base64_flag.test File 5.53 KB 0644
binlog_bug23533.test File 1.48 KB 0644
binlog_bug36391-master.opt File 32 B 0644
binlog_bug36391.test File 1.14 KB 0644
binlog_cache_write_failure-master.opt File 97 B 0644
binlog_cache_write_failure.test File 5.43 KB 0644
binlog_checksum.test File 1.04 KB 0644
binlog_crash_safe_master_checksum-master.opt File 51 B 0644
binlog_crash_safe_master_checksum.test File 2.56 KB 0644
binlog_database.test File 369 B 0644
binlog_delete_and_flush_index.test File 3.53 KB 0644
binlog_dmls_on_tmp_tables_readonly.test File 2.25 KB 0644
binlog_drop_if_exists.test File 3.47 KB 0644
binlog_enforce_gtid_consistency.test File 5.72 KB 0644
binlog_error_action-master.opt File 88 B 0644
binlog_error_action.test File 16.82 KB 0644
binlog_format_switch_in_tmp_table.test File 2.77 KB 0644
binlog_grant.test File 1.7 KB 0644
binlog_gtid_cache-master.opt File 117 B 0644
binlog_gtid_cache.test File 569 B 0644
binlog_gtid_errors-master.opt File 149 B 0644
binlog_gtid_errors.test File 7.28 KB 0644
binlog_gtid_exhausted-master.opt File 17 B 0644
binlog_gtid_exhausted.test File 2.34 KB 0644
binlog_gtid_implicit_commit.test File 121 B 0644
binlog_gtid_innodb.test File 132 B 0644
binlog_gtid_mysqlbinlog_row.test File 197 B 0644
binlog_gtid_mysqlbinlog_row_innodb.test File 707 B 0644
binlog_gtid_mysqlbinlog_row_myisam.test File 662 B 0644
binlog_gtid_mysqlbinlog_start_stop.test File 445 B 0644
binlog_gtid_row_ctype_ucs.test File 265 B 0644
binlog_gtid_simple_recovery.test File 4.7 KB 0644
binlog_gtid_stm_ctype_ucs.test File 280 B 0644
binlog_gtid_utils.test File 3.11 KB 0644
binlog_hexdump.test File 219 B 0644
binlog_implicit_commit.test File 290 B 0644
binlog_incident-master.opt File 53 B 0644
binlog_incident.test File 1.05 KB 0644
binlog_incident_ignore-master.opt File 77 B 0644
binlog_incident_ignore.test File 151 B 0644
binlog_index-master.opt File 16 B 0644
binlog_index.test File 16.48 KB 0644
binlog_innodb.test File 139 B 0644
binlog_innodb_row.test File 2.69 KB 0644
binlog_killed.test File 10.52 KB 0644
binlog_killed_simulate-master.opt File 39 B 0644
binlog_killed_simulate.test File 2.67 KB 0644
binlog_max_extension.test File 2.57 KB 0644
binlog_mixed_cache_stat.test File 276 B 0644
binlog_mixed_load_data.test File 501 B 0644
binlog_multi_engine.test File 3.18 KB 0644
binlog_mysqlbinlog-cp932-master.opt File 23 B 0644
binlog_mysqlbinlog-cp932.test File 1.07 KB 0644
binlog_mysqlbinlog_base64.test File 2.59 KB 0644
binlog_mysqlbinlog_concat.test File 4.1 KB 0644
binlog_mysqlbinlog_filter.test File 2.07 KB 0644
binlog_mysqlbinlog_raw.test File 3.53 KB 0644
binlog_mysqlbinlog_row.test File 204 B 0644
binlog_mysqlbinlog_row_innodb.test File 714 B 0644
binlog_mysqlbinlog_row_myisam.test File 669 B 0644
binlog_mysqlbinlog_row_trans.test File 4.55 KB 0644
binlog_mysqlbinlog_start_stop.test File 452 B 0644
binlog_mysqlbinlog_start_stop_slave_server_id.test File 1.96 KB 0644
binlog_old_versions.test File 5.6 KB 0644
binlog_query_filter_rules-master.opt File 40 B 0644
binlog_query_filter_rules.test File 854 B 0644
binlog_reset_master.test File 998 B 0644
binlog_rewrite.test File 3.01 KB 0644
binlog_rotate_bgc_sync.test File 3.62 KB 0644
binlog_row_binlog-master.opt File 55 B 0644
binlog_row_binlog.test File 782 B 0644
binlog_row_cache_stat.test File 273 B 0644
binlog_row_ctype_cp932.test File 267 B 0644
binlog_row_ctype_ucs.test File 272 B 0644
binlog_row_drop_tbl.test File 214 B 0644
binlog_row_drop_tmp_tbl.test File 232 B 0644
binlog_row_innodb_stat-master.opt File 26 B 0644
binlog_row_insert_select.test File 510 B 0644
binlog_row_mix_innodb_myisam-master.opt File 97 B 0644
binlog_row_mix_innodb_myisam.test File 584 B 0644
binlog_row_mysqlbinlog_db_filter.test File 4.1 KB 0644
binlog_row_mysqlbinlog_verbose.test File 5.59 KB 0644
binlog_row_query_log_events.test File 1.18 KB 0644
binlog_server_id.test File 1 KB 0644
binlog_server_start_options.test File 3.63 KB 0644
binlog_sf.test File 2.67 KB 0644
binlog_simplified_binlog_gtid_recovery-master.opt File 16 B 0644
binlog_spurious_ddl_errors-master.opt File 29 B 0644
binlog_spurious_ddl_errors.test File 4.16 KB 0644
binlog_sql_mode.test File 4.75 KB 0644
binlog_start_comment.test File 1.01 KB 0644
binlog_statement_insert_delayed.test File 500 B 0644
binlog_stm_binlog-master.opt File 55 B 0644
binlog_stm_binlog.test File 740 B 0644
binlog_stm_blackhole.test File 267 B 0644
binlog_stm_cache_stat.test File 279 B 0644
binlog_stm_ctype_cp932.test File 317 B 0644
binlog_stm_ctype_ucs.test File 287 B 0644
binlog_stm_do_db-master.opt File 38 B 0644
binlog_stm_do_db.test File 2.8 KB 0644
binlog_stm_drop_tbl.test File 229 B 0644
binlog_stm_drop_tmp_tbl.test File 247 B 0644
binlog_stm_innodb_stat-master.opt File 26 B 0644
binlog_stm_insert_select.test File 291 B 0644
binlog_stm_mix_innodb_myisam-master.opt File 145 B 0644
binlog_stm_mix_innodb_myisam.test File 551 B 0644
binlog_stm_ps.test File 866 B 0644
binlog_stm_row.test File 3.12 KB 0644
binlog_stm_unsafe_warning-master.opt File 38 B 0644
binlog_stm_unsafe_warning.test File 5.61 KB 0644
binlog_stm_user_variables.test File 3.16 KB 0644
binlog_switch_inside_trans.test File 7.6 KB 0644
binlog_tmp_table.test File 4.43 KB 0644
binlog_truncate_innodb-master.opt File 15 B 0644
binlog_truncate_kill.test File 1.96 KB 0644
binlog_truncate_myisam.test File 316 B 0644
binlog_unsafe-master.opt File 65 B 0644
binlog_unsafe.test File 26.31 KB 0644
binlog_unsafe_stmt_capable_engine-master.opt File 41 B 0644
binlog_unsafe_stmt_capable_engine.test File 12.55 KB 0644
binlog_use_gtid_skip.test File 1.03 KB 0644
binlog_variables_log_bin-master.opt File 16 B 0644
binlog_variables_log_bin.test File 135 B 0644
binlog_variables_log_bin_index-master.opt File 70 B 0644
binlog_variables_log_bin_index.test File 135 B 0644
binlog_variables_relay_log-master.opt File 24 B 0644
binlog_variables_relay_log.test File 183 B 0644
binlog_variables_relay_log_index-master.opt File 86 B 0644
binlog_variables_relay_log_index.test File 183 B 0644
binlog_write_error.test File 2.37 KB 0644
binlog_xa_handling.test File 769 B 0644
disabled.def File 404 B 0644
show_binlog_events_no_lock.test File 2.27 KB 0644