1include/master-slave.inc
2[connection master]
3connection slave;
4include/stop_slave.inc
5set @restore_slave_net_timeout= @@global.slave_net_timeout;
6set @@global.slave_net_timeout= 10;
7show status like 'Slave_heartbeat_period';;
8Variable_name	Slave_heartbeat_period
9Value	60.000
10SET @saved_dbug= @@GLOBAL.debug_dbug;
11SET GLOBAL debug_dbug="+d,simulate_slave_heartbeat_network_error";
12CALL mtr.add_suppression('SET @master_heartbeat_period to master failed with error');
13CALL mtr.add_suppression('Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again');
14include/start_slave.inc
15connection master;
16drop table if exists t1;
17CREATE TABLE t1 (a INT PRIMARY KEY);
18INSERT INTO t1 VALUES (1);
19connection slave;
20connection slave;
21SELECT * FROM t1;
22a
231
24connection master;
25drop table t1;
26connection slave;
27include/stop_slave.inc
28SET GLOBAL debug_dbug=@saved_dbug;
29set @@global.slave_net_timeout= @restore_slave_net_timeout;
30include/start_slave.inc
31include/rpl_end.inc
32