1
by brian
clean slate |
1 |
# This test checks that the slave I/O thread refuses to start if slave |
2 |
# and master have the same server id (because this is a useless setup, |
|
3 |
# and otherwise SHOW SLAVE STATUS shows progress but all queries are |
|
4 |
# ignored, which has caught our customers), unless |
|
5 |
# --replicate-same-server-id. |
|
6 |
||
7 |
source include/master-slave.inc; |
|
8 |
connection slave; |
|
9 |
reset master; |
|
10 |
||
11 |
# replicate ourselves |
|
12 |
stop slave; |
|
13 |
--replace_result $SLAVE_MYPORT SLAVE_PORT
|
|
14 |
eval change master to master_port=$SLAVE_MYPORT; |
|
15 |
start slave; |
|
16 |
||
17 |
--echo *** must be having the replicate-same-server-id IO thread error ***
|
|
18 |
||
19 |
source include/wait_for_slave_io_to_stop.inc; |
|
20 |
||
21 |
--replace_result $SLAVE_MYPORT SLAVE_PORT
|
|
22 |
--replace_column 12 # 16 # 19 # 20 # 18 # 37 # 38 #
|
|
23 |
query_vertical show slave status; |
|
24 |
||
25 |
# End of 4.1 tests |