Debian Codegraph @

mysql-test/suite/group_replication/r/gr_concurrent_ticket_pop_with_channel_2.result

raw
1 include/group_replication.inc [rpl_server_count=4]
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 server1]
6
7 ############################################################
8 # 1. Bootstrap group on server1.
9 # Start an inbound channel that replicates from server4.
10 [connection server1]
11 include/start_and_bootstrap_group_replication.inc
12 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=SERVER_4_PORT FOR CHANNEL 'ch1';
13 Warnings:
14 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
15 Note 1760 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.
16 include/start_slave.inc [FOR CHANNEL 'ch1']
17
18 ############################################################
19 # 2. Create table t1 without consuming a GTID to cause a future
20 # `group_replication_recovery` channel error.
21 # The goal is make the join operation as short as possible,
22 # so that we can maximize the number of joins per test.
23 # Join server2 to the group.
24 [connection server2]
25 SET SESSION sql_log_bin=0;
26 CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
27 SET SESSION sql_log_bin=1;
28 include/start_group_replication.inc
29
30 ############################################################
31 # 3. Create table t1 without consuming a GTID to cause a future
32 # `group_replication_recovery` channel error.
33 # The goal is make the join operation as short as possible,
34 # so that we can maximize the number of joins per test.
35 # Join server3 to the group.
36 [connection server3]
37 SET SESSION sql_log_bin=0;
38 CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
39 SET SESSION sql_log_bin=1;
40 include/start_group_replication.inc
41
42 ############################################################
43 # 4. Execute a procedure on server4 that commits transactions
44 # "forever" (until we kill the session).
45 [connection server4]
46 CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
47 CREATE EVENT ev1
48 ON SCHEDULE
49 EVERY 1 SECOND
50 DO
51 BEGIN
52 DECLARE i INTEGER;
53 SET i = 0;
54 WHILE i < 5000 DO
55 INSERT INTO t1() VALUES ();
56 SET i = i + 1;
57 END WHILE;
58 END |
59
60 ############################################################
61 # 5. Wait for the duplicate table error on server2 and server3.
62 [connection server2]
63 include/stop_group_replication.inc
64 [connection server3]
65 include/stop_group_replication.inc
66
67 ############################################################
68 # 6. Attempt to rejoin server2 and server3 50 times.
69 [connection server2]
70 START GROUP_REPLICATION;
71 Got one of the listed errors
72 [connection server3]
73 START GROUP_REPLICATION;
74 Got one of the listed errors
75 [connection server2]
76 START GROUP_REPLICATION;
77 Got one of the listed errors
78 [connection server3]
79 START GROUP_REPLICATION;
80 Got one of the listed errors
81 [connection server2]
82 START GROUP_REPLICATION;
83 Got one of the listed errors
84 [connection server3]
85 START GROUP_REPLICATION;
86 Got one of the listed errors
87 [connection server2]
88 START GROUP_REPLICATION;
89 Got one of the listed errors
90 [connection server3]
91 START GROUP_REPLICATION;
92 Got one of the listed errors
93 [connection server2]
94 START GROUP_REPLICATION;
95 Got one of the listed errors
96 [connection server3]
97 START GROUP_REPLICATION;
98 Got one of the listed errors
99 [connection server2]
100 START GROUP_REPLICATION;
101 Got one of the listed errors
102 [connection server3]
103 START GROUP_REPLICATION;
104 Got one of the listed errors
105 [connection server2]
106 START GROUP_REPLICATION;
107 Got one of the listed errors
108 [connection server3]
109 START GROUP_REPLICATION;
110 Got one of the listed errors
111 [connection server2]
112 START GROUP_REPLICATION;
113 Got one of the listed errors
114 [connection server3]
115 START GROUP_REPLICATION;
116 Got one of the listed errors
117 [connection server2]
118 START GROUP_REPLICATION;
119 Got one of the listed errors
120 [connection server3]
121 START GROUP_REPLICATION;
122 Got one of the listed errors
123 [connection server2]
124 START GROUP_REPLICATION;
125 Got one of the listed errors
126 [connection server3]
127 START GROUP_REPLICATION;
128 Got one of the listed errors
129 [connection server2]
130 START GROUP_REPLICATION;
131 Got one of the listed errors
132 [connection server3]
133 START GROUP_REPLICATION;
134 Got one of the listed errors
135 [connection server2]
136 START GROUP_REPLICATION;
137 Got one of the listed errors
138 [connection server3]
139 START GROUP_REPLICATION;
140 Got one of the listed errors
141 [connection server2]
142 START GROUP_REPLICATION;
143 Got one of the listed errors
144 [connection server3]
145 START GROUP_REPLICATION;
146 Got one of the listed errors
147 [connection server2]
148 START GROUP_REPLICATION;
149 Got one of the listed errors
150 [connection server3]
151 START GROUP_REPLICATION;
152 Got one of the listed errors
153 [connection server2]
154 START GROUP_REPLICATION;
155 Got one of the listed errors
156 [connection server3]
157 START GROUP_REPLICATION;
158 Got one of the listed errors
159 [connection server2]
160 START GROUP_REPLICATION;
161 Got one of the listed errors
162 [connection server3]
163 START GROUP_REPLICATION;
164 Got one of the listed errors
165 [connection server2]
166 START GROUP_REPLICATION;
167 Got one of the listed errors
168 [connection server3]
169 START GROUP_REPLICATION;
170 Got one of the listed errors
171 [connection server2]
172 START GROUP_REPLICATION;
173 Got one of the listed errors
174 [connection server3]
175 START GROUP_REPLICATION;
176 Got one of the listed errors
177 [connection server2]
178 START GROUP_REPLICATION;
179 Got one of the listed errors
180 [connection server3]
181 START GROUP_REPLICATION;
182 Got one of the listed errors
183 [connection server2]
184 START GROUP_REPLICATION;
185 Got one of the listed errors
186 [connection server3]
187 START GROUP_REPLICATION;
188 Got one of the listed errors
189 [connection server2]
190 START GROUP_REPLICATION;
191 Got one of the listed errors
192 [connection server3]
193 START GROUP_REPLICATION;
194 Got one of the listed errors
195 [connection server2]
196 START GROUP_REPLICATION;
197 Got one of the listed errors
198 [connection server3]
199 START GROUP_REPLICATION;
200 Got one of the listed errors
201 [connection server2]
202 START GROUP_REPLICATION;
203 Got one of the listed errors
204 [connection server3]
205 START GROUP_REPLICATION;
206 Got one of the listed errors
207 [connection server2]
208 START GROUP_REPLICATION;
209 Got one of the listed errors
210 [connection server3]
211 START GROUP_REPLICATION;
212 Got one of the listed errors
213 [connection server2]
214 START GROUP_REPLICATION;
215 Got one of the listed errors
216 [connection server3]
217 START GROUP_REPLICATION;
218 Got one of the listed errors
219 [connection server2]
220 START GROUP_REPLICATION;
221 Got one of the listed errors
222 [connection server3]
223 START GROUP_REPLICATION;
224 Got one of the listed errors
225 [connection server2]
226 START GROUP_REPLICATION;
227 Got one of the listed errors
228 [connection server3]
229 START GROUP_REPLICATION;
230 Got one of the listed errors
231 [connection server2]
232 START GROUP_REPLICATION;
233 Got one of the listed errors
234 [connection server3]
235 START GROUP_REPLICATION;
236 Got one of the listed errors
237 [connection server2]
238 START GROUP_REPLICATION;
239 Got one of the listed errors
240 [connection server3]
241 START GROUP_REPLICATION;
242 Got one of the listed errors
243 [connection server2]
244 START GROUP_REPLICATION;
245 Got one of the listed errors
246 [connection server3]
247 START GROUP_REPLICATION;
248 Got one of the listed errors
249 [connection server2]
250 START GROUP_REPLICATION;
251 Got one of the listed errors
252 [connection server3]
253 START GROUP_REPLICATION;
254 Got one of the listed errors
255 [connection server2]
256 START GROUP_REPLICATION;
257 Got one of the listed errors
258 [connection server3]
259 START GROUP_REPLICATION;
260 Got one of the listed errors
261 [connection server2]
262 START GROUP_REPLICATION;
263 Got one of the listed errors
264 [connection server3]
265 START GROUP_REPLICATION;
266 Got one of the listed errors
267 [connection server2]
268 START GROUP_REPLICATION;
269 Got one of the listed errors
270 [connection server3]
271 START GROUP_REPLICATION;
272 Got one of the listed errors
273 [connection server2]
274 START GROUP_REPLICATION;
275 Got one of the listed errors
276 [connection server3]
277 START GROUP_REPLICATION;
278 Got one of the listed errors
279 [connection server2]
280 START GROUP_REPLICATION;
281 Got one of the listed errors
282 [connection server3]
283 START GROUP_REPLICATION;
284 Got one of the listed errors
285 [connection server2]
286 START GROUP_REPLICATION;
287 Got one of the listed errors
288 [connection server3]
289 START GROUP_REPLICATION;
290 Got one of the listed errors
291 [connection server2]
292 START GROUP_REPLICATION;
293 Got one of the listed errors
294 [connection server3]
295 START GROUP_REPLICATION;
296 Got one of the listed errors
297 [connection server2]
298 START GROUP_REPLICATION;
299 Got one of the listed errors
300 [connection server3]
301 START GROUP_REPLICATION;
302 Got one of the listed errors
303 [connection server2]
304 START GROUP_REPLICATION;
305 Got one of the listed errors
306 [connection server3]
307 START GROUP_REPLICATION;
308 Got one of the listed errors
309 [connection server2]
310 START GROUP_REPLICATION;
311 Got one of the listed errors
312 [connection server3]
313 START GROUP_REPLICATION;
314 Got one of the listed errors
315 [connection server2]
316 START GROUP_REPLICATION;
317 Got one of the listed errors
318 [connection server3]
319 START GROUP_REPLICATION;
320 Got one of the listed errors
321 [connection server2]
322 START GROUP_REPLICATION;
323 Got one of the listed errors
324 [connection server3]
325 START GROUP_REPLICATION;
326 Got one of the listed errors
327 [connection server2]
328 START GROUP_REPLICATION;
329 Got one of the listed errors
330 [connection server3]
331 START GROUP_REPLICATION;
332 Got one of the listed errors
333 [connection server2]
334 START GROUP_REPLICATION;
335 Got one of the listed errors
336 [connection server3]
337 START GROUP_REPLICATION;
338 Got one of the listed errors
339 [connection server2]
340 START GROUP_REPLICATION;
341 Got one of the listed errors
342 [connection server3]
343 START GROUP_REPLICATION;
344 Got one of the listed errors
345 [connection server2]
346 START GROUP_REPLICATION;
347 Got one of the listed errors
348 [connection server3]
349 START GROUP_REPLICATION;
350 Got one of the listed errors
351 [connection server2]
352 START GROUP_REPLICATION;
353 Got one of the listed errors
354 [connection server3]
355 START GROUP_REPLICATION;
356 Got one of the listed errors
357 [connection server2]
358 START GROUP_REPLICATION;
359 Got one of the listed errors
360 [connection server3]
361 START GROUP_REPLICATION;
362 Got one of the listed errors
363 [connection server2]
364 START GROUP_REPLICATION;
365 Got one of the listed errors
366 [connection server3]
367 START GROUP_REPLICATION;
368 Got one of the listed errors
369
370 ############################################################
371 # 7. There must be 0 applier threads on server1 with the state
372 # 'Waiting for Binlog Group Commit ticket'.
373 [connection server1]
374
375 ############################################################
376 # 8. Clean up.
377 [connection server3]
378 DROP TABLE t1;
379 include/suppress_messages.inc
380 # Connection 3 suppresses message <Replica SQL for channel 'group_replication_applier': Worker [0-9] failed executing transaction*>.
381 # Connection 3 suppresses message <The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.>.
382 # Connection 3 suppresses message <Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.>.
383 # Connection 3 suppresses message <The server was automatically set into read only mode after an error was detected.>.
384 # Connection 3 suppresses message <Skipping leave operation: concurrent attempt to leave the group is on-going.>.
385 # Connection 3 suppresses message <Skipping leave operation: member already left the group.>.
386 # Connection 3 suppresses message <Unable to confirm whether the server has left the group or not. Check *.*>.
387 # Connection 3 suppresses message <The server was automatically set into read only mode after an error was detected.>.
388 # Connection 3 suppresses message <There was a previous plugin error while the member joined the group. The member will now exit the group.>.
389 # Connection 3 suppresses message <Message received while the plugin is not ready, message discarded.>.
390 # Connection 3 suppresses message <Unable to initialize the Group Replication applier module.>.
391 # Connection 3 suppresses message <.*Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state*>.
392 # Connection 3 suppresses message <.*Coordinator experienced an error or was killed while scheduling an event at.*>.
393 [connection server2]
394 DROP TABLE t1;
395 include/suppress_messages.inc
396 # Connection 2 suppresses message <Replica SQL for channel 'group_replication_applier': Worker [0-9] failed executing transaction*>.
397 # Connection 2 suppresses message <The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.>.
398 # Connection 2 suppresses message <Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.>.
399 # Connection 2 suppresses message <The server was automatically set into read only mode after an error was detected.>.
400 # Connection 2 suppresses message <Skipping leave operation: concurrent attempt to leave the group is on-going.>.
401 # Connection 2 suppresses message <Skipping leave operation: member already left the group.>.
402 # Connection 2 suppresses message <Unable to confirm whether the server has left the group or not. Check *.*>.
403 # Connection 2 suppresses message <The server was automatically set into read only mode after an error was detected.>.
404 # Connection 2 suppresses message <There was a previous plugin error while the member joined the group. The member will now exit the group.>.
405 # Connection 2 suppresses message <Message received while the plugin is not ready, message discarded.>.
406 # Connection 2 suppresses message <Unable to initialize the Group Replication applier module.>.
407 # Connection 2 suppresses message <.*Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state*>.
408 # Connection 2 suppresses message <.*Coordinator experienced an error or was killed while scheduling an event at.*>.
409 [connection server1]
410 include/stop_slave.inc [FOR CHANNEL 'ch1']
411 include/stop_group_replication.inc
412 RESET REPLICA ALL FOR CHANNEL 'ch1';
413 DROP EVENT ev1;
414 DROP TABLE t1;
415 include/suppress_messages.inc
416 # Connection 1 suppresses message <The transaction '[a-z0-9-]*:[0-9]*' will commit out of order with respect to its source to follow the group global order.>.
417 [connection server4]
418 DROP EVENT ev1;
419 DROP TABLE t1;
420 include/group_replication_end.inc