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;
7
call mtr.add_suppression("Slave I/O: Master command COM_REGISTER_SLAVE failed: .*");
8
call mtr.add_suppression("Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; .*");
9
call mtr.add_suppression("Slave I/O thread .* register on master");
10
SELECT IS_FREE_LOCK("debug_lock.before_get_UNIX_TIMESTAMP");
11
IS_FREE_LOCK("debug_lock.before_get_UNIX_TIMESTAMP")
13
SELECT GET_LOCK("debug_lock.before_get_UNIX_TIMESTAMP", 1000);
14
GET_LOCK("debug_lock.before_get_UNIX_TIMESTAMP", 1000)
16
set global debug= 'd,debug_lock.before_get_UNIX_TIMESTAMP';
19
SELECT RELEASE_LOCK("debug_lock.before_get_UNIX_TIMESTAMP");
20
RELEASE_LOCK("debug_lock.before_get_UNIX_TIMESTAMP")
22
Check network error happened here
24
SELECT IS_FREE_LOCK("debug_lock.before_get_SERVER_ID");
25
IS_FREE_LOCK("debug_lock.before_get_SERVER_ID")
27
SELECT GET_LOCK("debug_lock.before_get_SERVER_ID", 1000);
28
GET_LOCK("debug_lock.before_get_SERVER_ID", 1000)
30
set global debug= 'd,debug_lock.before_get_SERVER_ID';
33
SELECT RELEASE_LOCK("debug_lock.before_get_SERVER_ID");
34
RELEASE_LOCK("debug_lock.before_get_SERVER_ID")
36
Check network error happened here
40
include/stop_slave.inc
41
change master to master_port=SLAVE_PORT;
43
*** must be having the replicate-same-server-id IO thread error ***
45
Slave_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).