Debian Codegraph @

mysql-test/suite/rpl/r/rpl_server_id_ignore.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 master_id: 1
5 stop slave;
6 *** --replicate-same-server-id and change master option can clash ***
7 change master to IGNORE_SERVER_IDS= (2, 1);
8 ERROR HY000: The requested server id 2 clashes with the slave startup option --replicate-same-server-id
9 *** must be empty due to the error ***
10 ignore server id list:
11 change master to IGNORE_SERVER_IDS= (10, 100);
12 *** must be 10, 100 ***
13 ignore server id list: 10, 100
14 include/reset_slave.inc
15 *** must be empty due to reset slave ***
16 ignore server id list: 10, 100
17 change master to IGNORE_SERVER_IDS= (10, 100);
18 *** CHANGE MASTER with IGNORE_SERVER_IDS option overrides (does not increment) the previous setup ***
19 change master to IGNORE_SERVER_IDS= (5, 1, 4, 3, 1);
20 *** must be 1, 3, 4, 5 due to overriding policy ***
21 ignore server id list: 1, 3, 4, 5
22 *** ignore master (server 1) queries for a while ***
23 start slave;
24 connection master;
25 connection slave;
26 connection master;
27 create table t1 (n int);
28 connection slave;
29 include/wait_for_slave_param.inc [Exec_Master_Log_Pos]
30 *** must be empty as the event is to be filtered out ***
31 show tables;
32 Tables_in_test
33 *** allowing events from master ***
34 stop slave;
35 include/wait_for_slave_to_stop.inc
36 include/reset_slave.inc
37 change master to IGNORE_SERVER_IDS= (10, 100);
38 *** the list must remain (10, 100) after reset slave ***
39 change master to IGNORE_SERVER_IDS= ();
40 *** must be empty due to IGNORE_SERVER_IDS empty list ***
41 ignore server id list:
42 change master to master_host='127.0.0.1', master_port=MASTER_PORT, master_user='root';
43 start slave;
44 connection master;
45 connection slave;
46 *** must have caught create table ***
47 show tables;
48 Tables_in_test
49 t1
50 connection master;
51 drop table t1;
52 connection slave;
53 end of the tests
54 include/rpl_end.inc