Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 master_id: 1
7 stop slave;
8 Warnings:
9 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
10 *** --replicate-same-server-id and change master option can clash ***
11 CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (2, 1);
12 ERROR HY000: The requested server id 2 clashes with the replica startup option --replicate-same-server-id
13 *** must be empty due to the error ***
14 ignore server id list:
15 CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (10, 100);
16 *** must be 10, 100 ***
17 ignore server id list: 10, 100
18 reset slave;
19 Warnings:
20 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
21 *** must be still (10,100) after reset slave ***
22 ignore server id list: 10, 100
23 CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (10, 100);
24 *** CHANGE MASTER with IGNORE_SERVER_IDS option overrides (does not increment) the previous setup ***
25 CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (5, 1, 4, 3, 1);
26 *** must be 1, 3, 4, 5 due to overriding policy ***
27 ignore server id list: 1, 3, 4, 5
28 *** ignore master (server 1) queries for a while ***
29 include/start_slave.inc
30 include/sync_slave_sql_with_master.inc
31 create table t1 (n int);
32 include/wait_for_slave_param.inc [Exec_Master_Log_Pos]
33 *** must be empty as the event is to be filtered out ***
34 show tables;
35 Tables_in_test
36 *** allowing events from master ***
37 stop slave;
38 Warnings:
39 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
40 include/wait_for_slave_to_stop.inc
41 reset slave;
42 Warnings:
43 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
44 CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= (10, 100);
45 *** the list must remain (10, 100) after reset slave ***
46 CHANGE REPLICATION SOURCE to IGNORE_SERVER_IDS= ();
47 *** must be empty due to IGNORE_SERVER_IDS empty list ***
48 ignore server id list:
49 *** RESET SLAVE ALL should empty the list ***
50 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (10, 100);
51 ignore server id list: 10, 100
52 RESET SLAVE ALL;
53 Warnings:
54 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
55 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root';
56 Warnings:
57 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
58 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
59 include/start_slave.inc
60 include/assert.inc [RESET SLAVE ALL must empty the list of server-ids.]
61 include/sync_slave_sql_with_master.inc
62 *** must have caught create table ***
63 show tables;
64 Tables_in_test
65 t1
66 drop table t1;
67 include/sync_slave_sql_with_master.inc
68 # === Bug#18192817 IGNORE_SERVER_IDS IS SHOWING DUPLICATE SERVER IDS ===
69 include/stop_slave.inc
70 The list should have 0 elements.
71 Replicate_Ignore_Server_Ids = ''
72
73 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420);
74 The list should have 4 elements.
75 Replicate_Ignore_Server_Ids = '110, 220, 330, 420'
76
77 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (110,220,330,420);
78 The list should still have only 4 elements.
79 Replicate_Ignore_Server_Ids = '110, 220, 330, 420'
80
81 ISSUE WAS HERE: All server ids should be stored and showed only once, while they are set twice or even more.
82 The list should have 5 elements.
83 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (111,220,330,420);
84 Replicate_Ignore_Server_Ids = '110, 111, 220, 330, 420'
85
86 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (111,221,330,420);
87 The list should have 6 elements.
88 Replicate_Ignore_Server_Ids = '110, 111, 220, 221, 330, 420'
89
90 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (111,221,331,420);
91 The list should have 7 elements.
92 Replicate_Ignore_Server_Ids = '110, 111, 220, 221, 330, 331, 420'
93
94 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (110,220,330,420), IGNORE_SERVER_IDS= (111,221,331,421);
95 The list should have 8 elements.
96 Replicate_Ignore_Server_Ids = '110, 111, 220, 221, 330, 331, 420, 421'
97
98 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= ();
99 The list should have NO elements.
100 Replicate_Ignore_Server_Ids = ''
101
102 # === Bug #18593479: ON MASTER_INFO_REPOSITORY CHANGE, ===
103 # === IGNORE_SERVER_IDS DOUBLES WITH DUP VALUES ===
104 SET GLOBAL master_info_repository= 'FILE';
105 Warnings:
106 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
107 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (5,10,15);
108 include/start_slave.inc
109 Expect 3 elements.
110 Replicate_Ignore_Server_Ids = '5, 10, 15'
111
112 include/stop_slave.inc
113 SET GLOBAL master_info_repository= 'TABLE';
114 Warnings:
115 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
116 include/start_slave.inc
117
118 ISSUE WAS HERE: Due to buggy behaviour, we woule see 6 elements here.
119 Expect 3 elements ONLY to verify the fix when changing from FILE->TABLE.
120 Replicate_Ignore_Server_Ids = '5, 10, 15'
121
122 include/stop_slave.inc
123 SET GLOBAL master_info_repository= 'FILE';
124 Warnings:
125 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
126 include/start_slave.inc
127
128 ISSUE WAS HERE TOO: Due to buggy behaviour, we woule see 12 elements here.
129 Expect 3 elements ONLY to verify the fix when changinf from TABLE->FILE.
130 Replicate_Ignore_Server_Ids = '5, 10, 15'
131
132 include/stop_slave.inc
133 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= ();
134 include/start_slave.inc
135 include/rpl_end.inc