2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
1
include/master-slave.inc
7
3
call mtr.add_suppression("Slave I/O: Master command COM_REGISTER_SLAVE failed: .*");
8
4
call mtr.add_suppression("Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; .*");
9
5
call mtr.add_suppression("Slave I/O thread .* register on master");
11
7
SET @@global.debug= "+d,'debug_lock.before_get_UNIX_TIMESTAMP'";
8
include/start_slave.inc
13
9
slave is going to hang in get_master_version_and_clock
10
include/rpl_stop_server.inc [server_number=1]
15
12
SET DEBUG_SYNC='now SIGNAL signal.get_unix_timestamp';
16
13
Check network error happened here
14
include/wait_for_slave_io_error.inc [errno=1040, 1053, 2002, 2003, 2006, 2013]
17
15
set @@global.debug = "-d,'debug_lock.before_get_UNIX_TIMESTAMP'";
16
include/rpl_start_server.inc [server_number=1]
17
include/wait_for_slave_param.inc [Slave_IO_Running]
18
include/stop_slave.inc
19
19
SET @@global.debug= "+d,'debug_lock.before_get_SERVER_ID'";
20
include/start_slave.inc
21
21
slave is going to hang in get_master_version_and_clock
22
include/rpl_stop_server.inc [server_number=1]
23
24
SET DEBUG_SYNC='now SIGNAL signal.get_server_id';
24
25
Check network error happened here
26
include/wait_for_slave_io_error.inc [errno=1040, 1053, 2002, 2003, 2006, 2013]
25
27
set @@global.debug = "-d,'debug_lock.before_get_SERVER_ID'";
28
include/rpl_start_server.inc [server_number=1]
29
include/wait_for_slave_param.inc [Slave_IO_Running]
26
30
set global debug= '';
28
include/stop_slave.inc
29
change master to master_port=SLAVE_PORT;
31
*** must be having the replicate-same-server-id IO thread error ***
32
Last_IO_Error = Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
33
31
SET DEBUG_SYNC= 'RESET';