Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_circular_for_4_hosts_myisam.test

raw
1 # ==== Purpose ====
2 #
3 # Setup: circular replication on four hosts, i.e., topology
4 # server_1 -> server_2 -> server_3 -> server_4 -> server_1
5 #
6 # Tested properties:
7 # - Correctly configured autoinc works.
8 # - Manual failover works.
9 #
10 # ==== Related bugs and worklogs ====
11 #
12 # WL#3754
13 # BUG#49978
14
15 --source include/not_group_replication_plugin.inc
16 --source include/force_myisam_default.inc
17 --source include/have_myisam.inc
18
19 # Use wait_for_slave_to_(start|stop) for current connections
20 let $keep_connection= 1;
21
22 # Set up circular ring and new names for servers
23 --echo *** Set up circular replication on four servers ***
24 --let $rpl_topology= 1->2->3->4->1
25 --source include/rpl_init.inc
26 --echo
27
28 #set auto inc variables at each server
29 --let $_rpl_server= $rpl_server_count
30 while ($_rpl_server)
31 {
32 --let $rpl_connection_name= server_$_rpl_server
33 --source include/rpl_connection.inc
34 eval SET auto_increment_increment= $rpl_server_count;
35 eval SET auto_increment_offset= $_rpl_server;
36
37 --dec $_rpl_server
38 }
39
40 # Preparing data.
41 --echo *** Preparing data ***
42 --connection server_1
43 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b VARCHAR(100), c INT NOT NULL, PRIMARY KEY(a)) ENGINE=MyISAM;
44 --source include/rpl_sync.inc
45 --connection server_4
46 call mtr.add_suppression("Replica SQL.*Request to stop replica SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
47 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
48 call mtr.add_suppression("Replica SQL: Coordinator thread of multi-threaded replica is exiting seeing a failed Worker to apply an event");
49 call mtr.add_suppression("Replica worker thread has failed to apply an event");
50 --connection server_3
51 call mtr.add_suppression("Replica SQL.*Duplicate entry .6. for key .t1.PRIMARY.* Error_code: MY-001062");
52 --echo
53
54 #
55 # Testing
56 #
57
58 --echo *** Testing schema A->B->C->D->A ***
59 --echo
60 # insert data via all hosts
61 --connection server_1
62 INSERT INTO t1(b,c) VALUES('A',1);
63 --sync_slave_with_master server_2
64 INSERT INTO t1(b,c) VALUES('B',1);
65 --sync_slave_with_master server_3
66 INSERT INTO t1(b,c) VALUES('C',1);
67 --sync_slave_with_master server_4
68 INSERT INTO t1(b,c) VALUES('D',1);
69
70 --source include/rpl_sync.inc
71
72 --connection server_1
73 SELECT 'Master A',a,b FROM t1 WHERE c = 1 ORDER BY a,b;
74 --connection server_2
75 SELECT 'Master B',a,b FROM t1 WHERE c = 1 ORDER BY a,b;
76 --connection server_3
77 SELECT 'Master C',a,b FROM t1 WHERE c = 1 ORDER BY a,b;
78 --connection server_4
79 SELECT 'Master D',a,b FROM t1 WHERE c = 1 ORDER BY a,b;
80 --echo
81
82 --echo *** Testing schema A->B->D->A if C has failure ***
83 --echo
84 --echo * Do failure for C and then make new connection B->D *
85
86 # Note: server_N has auto_increment_offset=N. Below, we insert value 6
87 # in the autoinc column on server_3 (and prevent it from replicating
88 # further using SQL_REPLICA_SKIP_COUNTER on server_4). Due to the
89 # auto_increment_offset setting, the autoinc value 6 is normally
90 # generated on server_2. When we later insert a row on server_2, we
91 # thus cause a duplicate key error on server_3.
92
93 # Do not replicate next event from C
94 --connection server_4
95 STOP SLAVE;
96 SET GLOBAL SQL_REPLICA_SKIP_COUNTER = 1;
97 source include/start_slave.inc;
98 --connection server_3
99 INSERT INTO t1 VALUES(6,'C',2);
100 --sync_slave_with_master server_4
101
102 --connection server_3
103
104 lock table t1 write /* must block B_2^6 coming */;
105
106 --connection server_2
107 INSERT INTO t1(b,c) VALUES('B',2);
108
109 # MTS: catching failure
110 --connection server_3
111 unlock tables;
112
113 # Wait while C will stop.
114 --connection server_3
115 # 1062 = ER_DUP_ENTRY
116 --let $slave_sql_errno= 1062
117 --source include/wait_for_slave_sql_error.inc
118 --connection server_1
119 INSERT INTO t1(b,c) VALUES('A',2);
120 --connection server_4
121
122 INSERT INTO t1(b,c) VALUES('D',2);
123
124
125 # Sync all servers except C
126 --connection server_2
127 let $wait_condition= SELECT COUNT(*)=3 FROM t1 WHERE a > 4;
128 --let $server_connection= server_1
129 --source include/wait_condition_or_abort.inc
130
131 --echo
132 --echo * Data on servers (C failed) *
133 # Masters C,D shouldn't have correct data
134 --connection server_1
135 SELECT 'Master A',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
136 --connection server_2
137 SELECT 'Master B',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
138 --connection server_3
139 SELECT 'Master C',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
140 --connection server_4
141 SELECT 'Master D',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
142 --echo
143
144 --echo * Reconfigure replication to schema A->B->D->A *
145 # Exclude Master C
146 --connection server_3
147 --source include/stop_slave_io.inc
148 --let $pos_c= query_get_value(SHOW SLAVE STATUS, Exec_Master_Log_Pos, 1)
149 --let $file_c= query_get_value(SHOW SLAVE STATUS, Master_Log_File, 1)
150
151 --connection server_4
152 --source include/stop_slave.inc
153
154 --let $rpl_topology= 1->2->4->1,2->3
155 --let $rpl_master_log_file= 4:$file_c
156 --let $rpl_master_log_pos= 4:$pos_c
157 --source include/rpl_change_topology.inc
158
159 #--replace_result $SERVER_MYPORT_2 SERVER_MYPORT_2 $file_c LOG_FILE $pos_c LOG_POS
160 #--eval CHANGE MASTER TO master_host='127.0.0.1',master_port=$SERVER_MYPORT_2,master_user='root',master_log_file='$file_c',master_log_pos=$pos_c
161 source include/start_slave.inc;
162 --connection server_2
163 --sync_slave_with_master server_4
164 --sync_slave_with_master server_1
165 --echo
166
167 --echo * Check data inserted before failure *
168 --connection server_1
169 SELECT 'Master A',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
170 --connection server_2
171 SELECT 'Master B',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
172 --connection server_3
173 SELECT 'Master C',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
174 --connection server_4
175 SELECT 'Master D',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
176 --echo
177
178 --echo * Check data inserted after failure *
179 --connection server_1
180 INSERT INTO t1(b,c) VALUES('A',3);
181 --connection server_2
182 INSERT INTO t1(b,c) VALUES('B',3);
183 --connection server_4
184 INSERT INTO t1(b,c) VALUES('D',3);
185 connection server_1;
186
187 --let $rpl_only_running_threads= 1
188 --source include/rpl_sync.inc
189
190 --connection server_1
191 SELECT 'Master A',a,b FROM t1 WHERE c = 3 ORDER BY a,b;
192 --connection server_2
193 SELECT 'Master B',a,b FROM t1 WHERE c = 3 ORDER BY a,b;
194 --connection server_3
195 SELECT 'Master C',a,b FROM t1 WHERE c = 3 ORDER BY a,b;
196 --connection server_4
197 SELECT 'Master D',a,b FROM t1 WHERE c = 3 ORDER BY a,b;
198 --connection server_1
199 --echo
200
201 --echo *** Testing restoring scheme A->B->C->D->A after failure ***
202 --echo
203 # Master D will ignore a next event from C so that event will not be
204 # distributed to other servers
205 --echo * Remove wrong event from C and restore B->C->D *
206 --connection server_4
207 source include/stop_slave.inc;
208 --connection server_3
209 DELETE FROM t1 WHERE a = 6;
210 --source include/start_slave.inc
211 --connection server_2
212 --sync_slave_with_master server_3
213 RESET MASTER;
214 --let $file_d= query_get_value(SHOW MASTER STATUS, File, 1)
215 --let $pos_d= query_get_value(SHOW MASTER STATUS, Position, 1)
216 --connection server_4
217 RESET SLAVE;
218 --let $rpl_topology= 1->2->3->4->1
219 --let $rpl_master_log_file= 4:$file_d
220 --let $rpl_master_log_pos= 4:$pos_d
221 --source include/rpl_change_topology.inc
222 #--replace_result $SERVER_MYPORT_3 SERVER_MYPORT_3 $file_d LOG_FILE $pos_d LOG_POS
223 #--eval CHANGE MASTER TO master_host='127.0.0.1',master_port=$SERVER_MYPORT_3,master_user='root',master_log_file='$file_d',master_log_pos=$pos_d
224 --source include/start_slave.inc
225 --connection server_3
226 --sync_slave_with_master server_4
227 --source include/rpl_sync.inc
228
229 --echo
230 --echo * Check data inserted before restoring schema A->B->C->D->A *
231 --connection server_1
232 SELECT 'Master A',a,b FROM t1 WHERE c IN (2,3) ORDER BY a,b;
233 --sync_slave_with_master server_2
234 SELECT 'Master B',a,b FROM t1 WHERE c IN (2,3) ORDER BY a,b;
235 --sync_slave_with_master server_3
236 SELECT 'Master C',a,b FROM t1 WHERE c IN (2,3) ORDER BY a,b;
237 --sync_slave_with_master server_4
238 SELECT 'Master D',a,b FROM t1 WHERE c IN (2,3) ORDER BY a,b;
239 --sync_slave_with_master server_1
240 --echo
241
242 --echo * Check data inserted after restoring schema A->B->C->D->A *
243 --connection server_1
244 INSERT INTO t1(b,c) VALUES('A',4);
245 --connection server_2
246 INSERT INTO t1(b,c) VALUES('B',4);
247 --connection server_3
248 INSERT INTO t1(b,c) VALUES('C',4);
249 --connection server_4
250 INSERT INTO t1(b,c) VALUES('D',4);
251 --connection server_1
252
253 --source include/rpl_sync.inc
254
255 --connection server_1
256 SELECT 'Master A',a,b FROM t1 WHERE c = 4 ORDER BY a,b;
257 --connection server_2
258 SELECT 'Master B',a,b FROM t1 WHERE c = 4 ORDER BY a,b;
259 --connection server_3
260 SELECT 'Master C',a,b FROM t1 WHERE c = 4 ORDER BY a,b;
261 --connection server_4
262 SELECT 'Master D',a,b FROM t1 WHERE c = 4 ORDER BY a,b;
263 --connection server_1
264 --echo
265
266 # Clean up
267 --echo *** Clean up ***
268 --connection server_1
269 DROP TABLE t1;
270
271 --source include/rpl_end.inc