1
# TBF - difference in row level logging
2
# Temp tables are not replicated in rbr, but it is still good to hit rbr with everthing
4
# See SHOW SLAVE STATUS displays well after RESET SLAVE (it should display the
5
# --master-* options from mysqld, as this is what is going to be used next time
6
# slave threads will be started). In bug 985, it displayed old values (of before
8
# See if slave crashes when doing a CREATE TEMPORARY TABLE twice, separated by
11
-- source include/master-slave.inc
16
source include/show_slave_status2.inc;
19
change master to master_user='test';
20
source include/show_slave_status2.inc;
23
source include/show_slave_status2.inc;
27
source include/show_slave_status2.inc;
29
# test of crash with temp tables & RESET SLAVE
30
# (test to see if RESET SLAVE clears temp tables in memory and disk)
35
create temporary table t1 (a int);
43
show status like 'slave_open_temp_tables';
46
#Bug#34654 RESET SLAVE does not clear LAST_IO_Err*
52
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
53
echo *** errno must be zero: $last_io_errno ***;
56
# verifying start slave resets Last_IO_Error and Last_IO_Errno.
59
change master to master_user='impossible_user_name';
61
source include/wait_for_slave_io_error.inc;
62
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
64
eval SELECT $last_io_errno > 0 as ONE;
67
source include/stop_slave.inc;
68
change master to master_user='root';
69
source include/start_slave.inc;
70
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
71
let $last_io_error= query_get_value(SHOW SLAVE STATUS, Last_IO_Error, 1);
72
--echo *** last errno must be zero: $last_io_errno ***
73
--echo *** last error must be blank: $last_io_error ***
76
# verifying reset slave resets Last_{IO,SQL}_Err{or,no}
79
source include/stop_slave.inc;
80
change master to master_user='impossible_user_name';
82
source include/wait_for_slave_io_error.inc;
83
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
85
eval SELECT $last_io_errno > 0 as ONE;
88
source include/stop_slave.inc;
90
let $last_io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1);
91
let $last_io_error= query_get_value(SHOW SLAVE STATUS, Last_IO_Error, 1);
92
let $last_sql_errno= query_get_value(SHOW SLAVE STATUS, Last_SQL_Errno, 1);
93
let $last_sql_error= query_get_value(SHOW SLAVE STATUS, Last_SQL_Error, 1);
94
--echo *** io last errno must be zero: $last_io_errno ***
95
--echo *** io last error must be blank: $last_io_error ***
96
--echo *** sql last errno must be zero: $last_sql_errno ***
97
--echo *** sql last error must be blank: $last_sql_error ***