Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_wait_for_executed_gtid_set.result

raw
1 include/rpl_init.inc [topology=1->2, 1->3]
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 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 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.
8 include/rpl_group_replication_plugin_installed.inc
9 include/rpl_default_connections.inc
10 ==== 0. Initialize ====
11 [connection server_1]
12 SET GLOBAL GTID_PURGED = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,ffffffff-ffff-ffff-ffff-ffffffffffff:1-1234567890';
13 [connection server_2]
14 SET GLOBAL GTID_PURGED = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,ffffffff-ffff-ffff-ffff-ffffffffffff:1-1234567890';
15 [connection server_3]
16 SET GLOBAL GTID_PURGED = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,ffffffff-ffff-ffff-ffff-ffffffffffff:1-1234567890';
17 CALL mtr.add_suppression('You need to use --log-bin to make --binlog-format work.');
18 CALL mtr.add_suppression('You need to use --log-bin to make --log-replica-updates work.');
19 [connection master]
20 CALL mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.');
21 include/rpl_sync.inc
22 include/rpl_sync.inc
23 CREATE TABLE t1 (a INT);
24 ==== 1. Error conditions ====
25 ---- 1.1. NULL or invalid string ----
26 SELECT WAIT_FOR_EXECUTED_GTID_SET(NULL, 5);
27 ERROR HY000: Malformed GTID set specification 'NULL'.
28 SELECT WAIT_FOR_EXECUTED_GTID_SET(NULL, NULL);
29 ERROR HY000: Malformed GTID set specification 'NULL'.
30 SELECT WAIT_FOR_EXECUTED_GTID_SET(NULL);
31 ERROR HY000: Malformed GTID set specification 'NULL'.
32 set @null = NULL;
33 SELECT WAIT_FOR_EXECUTED_GTID_SET(@null, @null);
34 ERROR HY000: Malformed GTID set specification 'NULL'.
35 SELECT WAIT_FOR_EXECUTED_GTID_SET(5, NULL);
36 ERROR HY000: Incorrect arguments to WAIT_FOR_EXECUTED_GTID_SET.
37 SELECT WAIT_FOR_EXECUTED_GTID_SET('Incorrect_value');
38 ERROR HY000: Malformed GTID set specification 'Incorrect_value'.
39 SELECT WAIT_FOR_EXECUTED_GTID_SET('Incorrect_value', 5);
40 ERROR HY000: Malformed GTID set specification 'Incorrect_value'.
41 SELECT WAIT_FOR_EXECUTED_GTID_SET();
42 ERROR 42000: Incorrect parameter count in the call to native function 'WAIT_FOR_EXECUTED_GTID_SET'
43 SELECT WAIT_FOR_EXECUTED_GTID_SET('NULL', 5, 5);
44 ERROR 42000: Incorrect parameter count in the call to native function 'WAIT_FOR_EXECUTED_GTID_SET'
45 ---- 1.2. Wait for GTID owned by the waiting client ----
46 SET @@SESSION.GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:1';
47 SELECT WAIT_FOR_EXECUTED_GTID_SET('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1');
48 WAIT_FOR_EXECUTED_GTID_SET('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1')
49 0
50 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1');
51 ERROR HY000: The client holds ownership of the GTID cccccccc-cccc-cccc-cccc-cccccccccccc:1. Therefore, WAIT_FOR_EXECUTED_GTID_SET cannot wait for this GTID.
52 ROLLBACK;
53 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 1);
54 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 1)
55 1
56 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
57 ---- 1.3. Function should return NULL in a replication thread ----
58 INSERT INTO t1 VALUES (WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1'));
59 Warnings:
60 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
61 include/assert.inc [t1 should contain 0]
62 include/sync_slave_sql_with_master.inc
63 include/assert.inc [t1 should contain NULL]
64 [connection master]
65 ---- 1.4. Function should generate error if GTID_MODE = OFF ----
66 include/rpl_set_gtid_mode.inc [off on servers 1,2,3]
67 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1');
68 ERROR HY000: Cannot use WAIT_FOR_EXECUTED_GTID_SET when GTID_MODE = OFF.
69 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:9999');
70 ERROR HY000: Cannot use WAIT_FOR_EXECUTED_GTID_SET when GTID_MODE = OFF.
71 include/rpl_set_gtid_mode.inc [on on servers 1,2,3]
72 ---- 1.5. Function should stop fast if client is killed ----
73 include/rpl_connect.inc [creating con1]
74 [connection con1]
75 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:9999');
76 [connection master]
77 include/wait_for_wait_for_executed_gtid_set.inc
78 KILL <THREAD_ID>;
79 [connection con1]
80 ERROR HY000: Lost connection to MySQL server during query
81 [connection master]
82 ---- 1.6. Function should return error if query is killed ----
83 [connection master1]
84 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:9999');
85 [connection master]
86 include/wait_for_wait_for_executed_gtid_set.inc
87 include/kill_wait_for_executed_gtid_set.inc
88 [connection master]
89 ==== 2. Wait set is already part of GTID_EXECUTED ====
90 ---- 2.1. No GTID ----
91 SELECT WAIT_FOR_EXECUTED_GTID_SET('');
92 WAIT_FOR_EXECUTED_GTID_SET('')
93 0
94 SELECT WAIT_FOR_EXECUTED_GTID_SET('', 999999);
95 WAIT_FOR_EXECUTED_GTID_SET('', 999999)
96 0
97 ---- 2.2. Single GTID ----
98 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1');
99 WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1')
100 0
101 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 999999);
102 WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 999999)
103 0
104 ---- 2.3. Multiple GTIDs, all having the same UUID ----
105 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
106 WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')
107 0
108 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 999999);
109 WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 999999)
110 0
111 ---- 2.4. Multiple GTIDs using different UUIDs ----
112 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3');
113 WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3')
114 0
115 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 999999);
116 WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 999999)
117 0
118 ---- 2.5. Huge GTID set ----
119 SELECT WAIT_FOR_EXECUTED_GTID_SET('ffffffff-ffff-ffff-ffff-ffffffffffff:1-1234567890');
120 WAIT_FOR_EXECUTED_GTID_SET('ffffffff-ffff-ffff-ffff-ffffffffffff:1-1234567890')
121 0
122 SELECT WAIT_FOR_EXECUTED_GTID_SET('ffffffff-ffff-ffff-ffff-ffffffffffff:1-1234567890', 999999);
123 WAIT_FOR_EXECUTED_GTID_SET('ffffffff-ffff-ffff-ffff-ffffffffffff:1-1234567890', 999999)
124 0
125 ==== 3. Still waiting after 1 second, if GTIDs not committed ====
126 ---- 3.1. Big timeout ----
127 [connection master1]
128 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 999999);
129 [connection master]
130 include/wait_for_wait_for_executed_gtid_set.inc
131 include/kill_wait_for_executed_gtid_set.inc
132 ---- 3.2. No timeout ----
133 [connection master1]
134 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1');
135 [connection master]
136 include/wait_for_wait_for_executed_gtid_set.inc
137 include/kill_wait_for_executed_gtid_set.inc
138 ==== 4. Still waiting after 1 second, even if GTID included in GTID_OWNED ====
139 [connection server_1]
140 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:1';
141 ---- 4.1. Big timeout ----
142 [connection master1]
143 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 999999);
144 [connection master]
145 include/wait_for_wait_for_executed_gtid_set.inc
146 include/kill_wait_for_executed_gtid_set.inc
147 ---- 4.2. No timeout ----
148 [connection master1]
149 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1');
150 [connection master]
151 include/wait_for_wait_for_executed_gtid_set.inc
152 include/kill_wait_for_executed_gtid_set.inc
153 [connection server_1]
154 ROLLBACK;
155 SET GTID_NEXT = 'AUTOMATIC';
156 ==== 5. Still waiting if anonymous transaction committed ====
157 include/rpl_set_gtid_mode.inc [on_permissive on servers 1,2,3]
158 ---- 5.1. Big timeout ----
159 [connection master1]
160 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 999999);
161 [connection master]
162 include/wait_for_wait_for_executed_gtid_set.inc
163 SET GTID_NEXT = 'ANONYMOUS';
164 INSERT INTO t1 VALUES (1);
165 SET GTID_NEXT = 'AUTOMATIC';
166 include/kill_wait_for_executed_gtid_set.inc
167 ---- 5.2. No timeout ----
168 [connection master1]
169 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1');
170 [connection master]
171 include/wait_for_wait_for_executed_gtid_set.inc
172 SET GTID_NEXT = 'ANONYMOUS';
173 INSERT INTO t1 VALUES (1);
174 SET GTID_NEXT = 'AUTOMATIC';
175 include/kill_wait_for_executed_gtid_set.inc
176 include/rpl_set_gtid_mode.inc [on on servers 1,2,3]
177 ==== 6. Stop after the timeout is reached ====
178 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 1);
179 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 1)
180 1
181 [connection server_1]
182 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:1';
183 [connection master]
184 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 1);
185 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1', 1)
186 1
187 [connection server_1]
188 ROLLBACK;
189 SET GTID_NEXT = 'AUTOMATIC';
190 [connection master]
191 ==== 7. ====
192 ---- 7.1 (1) ----
193 [connection server_1]
194 SELECT WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:6');
195 [connection server_1_1]
196 include/wait_for_wait_for_executed_gtid_set.inc
197 [connection master]
198 SET GTID_NEXT = 'SERVER_UUID:6';
199 COMMIT;
200 SET GTID_NEXT = 'AUTOMATIC';
201 [connection server_1]
202 WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:6')
203 0
204 [connection master]
205 ---- 7.2 (1) ----
206 [connection server_1]
207 SELECT WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:7,SERVER_UUID:8');
208 [connection server_1_1]
209 include/wait_for_wait_for_executed_gtid_set.inc
210 [connection master]
211 SET GTID_NEXT = 'SERVER_UUID:7';
212 COMMIT;
213 SET GTID_NEXT = 'AUTOMATIC';
214 [connection server_1_1]
215 include/wait_for_wait_for_executed_gtid_set.inc
216 [connection master]
217 SET GTID_NEXT = 'SERVER_UUID:8';
218 COMMIT;
219 SET GTID_NEXT = 'AUTOMATIC';
220 [connection server_1]
221 WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:7,SERVER_UUID:8')
222 0
223 [connection master]
224 ---- 7.3 (1) ----
225 [connection server_1]
226 SELECT WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:9,dddddddd-dddd-dddd-dddd-dddddddddddd:1');
227 [connection server_1_1]
228 include/wait_for_wait_for_executed_gtid_set.inc
229 [connection master]
230 SET GTID_NEXT = 'SERVER_UUID:9';
231 COMMIT;
232 SET GTID_NEXT = 'AUTOMATIC';
233 [connection server_1_1]
234 include/wait_for_wait_for_executed_gtid_set.inc
235 [connection master]
236 SET GTID_NEXT = 'dddddddd-dddd-dddd-dddd-dddddddddddd:1';
237 COMMIT;
238 SET GTID_NEXT = 'AUTOMATIC';
239 [connection server_1]
240 WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:9,dddddddd-dddd-dddd-dddd-dddddddddddd:1')
241 0
242 [connection master]
243 ---- 7.4 (1) ----
244 [connection server_1]
245 SELECT WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:1,SERVER_UUID:10,dddddddd-dddd-dddd-dddd-dddddddddddd:2');
246 [connection server_1_1]
247 include/wait_for_wait_for_executed_gtid_set.inc
248 [connection master]
249 SET GTID_NEXT = 'SERVER_UUID:10';
250 COMMIT;
251 SET GTID_NEXT = 'AUTOMATIC';
252 [connection server_1_1]
253 include/wait_for_wait_for_executed_gtid_set.inc
254 [connection master]
255 SET GTID_NEXT = 'dddddddd-dddd-dddd-dddd-dddddddddddd:2';
256 COMMIT;
257 SET GTID_NEXT = 'AUTOMATIC';
258 [connection server_1]
259 WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:1,SERVER_UUID:10,dddddddd-dddd-dddd-dddd-dddddddddddd:2')
260 0
261 [connection master]
262 ---- 7.5 (1) ----
263 [connection server_1]
264 SELECT WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:11,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3');
265 [connection server_1_1]
266 include/wait_for_wait_for_executed_gtid_set.inc
267 [connection master]
268 SET GTID_NEXT = 'SERVER_UUID:11';
269 COMMIT;
270 SET GTID_NEXT = 'AUTOMATIC';
271 [connection server_1]
272 WAIT_FOR_EXECUTED_GTID_SET('SERVER_UUID:11,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3')
273 0
274 [connection master]
275 ---- 7.6 (1) ----
276 ---- 7.1 (2) ----
277 [connection server_1]
278 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1');
279 [connection server_1_1]
280 include/wait_for_wait_for_executed_gtid_set.inc
281 [connection master]
282 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:1';
283 COMMIT;
284 SET GTID_NEXT = 'AUTOMATIC';
285 [connection server_1]
286 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1')
287 0
288 [connection master]
289 ---- 7.2 (2) ----
290 [connection server_1]
291 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:2,cccccccc-cccc-cccc-cccc-cccccccccccc:3');
292 [connection server_1_1]
293 include/wait_for_wait_for_executed_gtid_set.inc
294 [connection master]
295 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:2';
296 COMMIT;
297 SET GTID_NEXT = 'AUTOMATIC';
298 [connection server_1_1]
299 include/wait_for_wait_for_executed_gtid_set.inc
300 [connection master]
301 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:3';
302 COMMIT;
303 SET GTID_NEXT = 'AUTOMATIC';
304 [connection server_1]
305 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:2,cccccccc-cccc-cccc-cccc-cccccccccccc:3')
306 0
307 [connection master]
308 ---- 7.3 (2) ----
309 [connection server_1]
310 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:4,dddddddd-dddd-dddd-dddd-dddddddddddd:3');
311 [connection server_1_1]
312 include/wait_for_wait_for_executed_gtid_set.inc
313 [connection master]
314 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:4';
315 COMMIT;
316 SET GTID_NEXT = 'AUTOMATIC';
317 [connection server_1_1]
318 include/wait_for_wait_for_executed_gtid_set.inc
319 [connection master]
320 SET GTID_NEXT = 'dddddddd-dddd-dddd-dddd-dddddddddddd:3';
321 COMMIT;
322 SET GTID_NEXT = 'AUTOMATIC';
323 [connection server_1]
324 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:4,dddddddd-dddd-dddd-dddd-dddddddddddd:3')
325 0
326 [connection master]
327 ---- 7.4 (2) ----
328 [connection server_1]
329 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1,cccccccc-cccc-cccc-cccc-cccccccccccc:5,dddddddd-dddd-dddd-dddd-dddddddddddd:4');
330 [connection server_1_1]
331 include/wait_for_wait_for_executed_gtid_set.inc
332 [connection master]
333 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:5';
334 COMMIT;
335 SET GTID_NEXT = 'AUTOMATIC';
336 [connection server_1_1]
337 include/wait_for_wait_for_executed_gtid_set.inc
338 [connection master]
339 SET GTID_NEXT = 'dddddddd-dddd-dddd-dddd-dddddddddddd:4';
340 COMMIT;
341 SET GTID_NEXT = 'AUTOMATIC';
342 [connection server_1]
343 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1,cccccccc-cccc-cccc-cccc-cccccccccccc:5,dddddddd-dddd-dddd-dddd-dddddddddddd:4')
344 0
345 [connection master]
346 ---- 7.5 (2) ----
347 [connection server_1]
348 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:6,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3');
349 [connection server_1_1]
350 include/wait_for_wait_for_executed_gtid_set.inc
351 [connection master]
352 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:6';
353 COMMIT;
354 SET GTID_NEXT = 'AUTOMATIC';
355 [connection server_1]
356 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:6,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3')
357 0
358 [connection master]
359 ---- 7.6 (2) ----
360 [connection server_1]
361 SELECT WAIT_FOR_EXECUTED_GTID_SET('UUID:1');
362 [connection server_1_1]
363 include/wait_for_wait_for_executed_gtid_set.inc
364 [connection master]
365 SET GTID_NEXT = 'UUID:1';
366 COMMIT;
367 SET GTID_NEXT = 'AUTOMATIC';
368 [connection server_1]
369 WAIT_FOR_EXECUTED_GTID_SET('UUID:1')
370 0
371 [connection master]
372 ---- 7.1 (3) ----
373 [connection server_2]
374 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:7');
375 [connection server_2_1]
376 include/wait_for_wait_for_executed_gtid_set.inc
377 [connection master]
378 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:7';
379 COMMIT;
380 SET GTID_NEXT = 'AUTOMATIC';
381 [connection server_2]
382 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:7')
383 0
384 [connection master]
385 ---- 7.2 (3) ----
386 [connection server_2]
387 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:8,cccccccc-cccc-cccc-cccc-cccccccccccc:9');
388 [connection server_2_1]
389 include/wait_for_wait_for_executed_gtid_set.inc
390 [connection master]
391 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:8';
392 COMMIT;
393 SET GTID_NEXT = 'AUTOMATIC';
394 [connection server_2_1]
395 include/wait_for_wait_for_executed_gtid_set.inc
396 [connection master]
397 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:9';
398 COMMIT;
399 SET GTID_NEXT = 'AUTOMATIC';
400 [connection server_2]
401 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:8,cccccccc-cccc-cccc-cccc-cccccccccccc:9')
402 0
403 [connection master]
404 ---- 7.3 (3) ----
405 [connection server_2]
406 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:10,dddddddd-dddd-dddd-dddd-dddddddddddd:5');
407 [connection server_2_1]
408 include/wait_for_wait_for_executed_gtid_set.inc
409 [connection master]
410 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:10';
411 COMMIT;
412 SET GTID_NEXT = 'AUTOMATIC';
413 [connection server_2_1]
414 include/wait_for_wait_for_executed_gtid_set.inc
415 [connection master]
416 SET GTID_NEXT = 'dddddddd-dddd-dddd-dddd-dddddddddddd:5';
417 COMMIT;
418 SET GTID_NEXT = 'AUTOMATIC';
419 [connection server_2]
420 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:10,dddddddd-dddd-dddd-dddd-dddddddddddd:5')
421 0
422 [connection master]
423 ---- 7.4 (3) ----
424 [connection server_2]
425 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1,cccccccc-cccc-cccc-cccc-cccccccccccc:11,dddddddd-dddd-dddd-dddd-dddddddddddd:6');
426 [connection server_2_1]
427 include/wait_for_wait_for_executed_gtid_set.inc
428 [connection master]
429 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:11';
430 COMMIT;
431 SET GTID_NEXT = 'AUTOMATIC';
432 [connection server_2_1]
433 include/wait_for_wait_for_executed_gtid_set.inc
434 [connection master]
435 SET GTID_NEXT = 'dddddddd-dddd-dddd-dddd-dddddddddddd:6';
436 COMMIT;
437 SET GTID_NEXT = 'AUTOMATIC';
438 [connection server_2]
439 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1,cccccccc-cccc-cccc-cccc-cccccccccccc:11,dddddddd-dddd-dddd-dddd-dddddddddddd:6')
440 0
441 [connection master]
442 ---- 7.5 (3) ----
443 [connection server_2]
444 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:12,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3');
445 [connection server_2_1]
446 include/wait_for_wait_for_executed_gtid_set.inc
447 [connection master]
448 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:12';
449 COMMIT;
450 SET GTID_NEXT = 'AUTOMATIC';
451 [connection server_2]
452 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:12,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3')
453 0
454 [connection master]
455 ---- 7.6 (3) ----
456 [connection server_2]
457 SELECT WAIT_FOR_EXECUTED_GTID_SET('UUID:1');
458 [connection server_2_1]
459 include/wait_for_wait_for_executed_gtid_set.inc
460 [connection master]
461 SET GTID_NEXT = 'UUID:1';
462 COMMIT;
463 SET GTID_NEXT = 'AUTOMATIC';
464 [connection server_2]
465 WAIT_FOR_EXECUTED_GTID_SET('UUID:1')
466 0
467 [connection master]
468 ---- 7.1 (4) ----
469 [connection server_3]
470 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:13');
471 [connection server_3_1]
472 include/wait_for_wait_for_executed_gtid_set.inc
473 [connection master]
474 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:13';
475 COMMIT;
476 SET GTID_NEXT = 'AUTOMATIC';
477 [connection server_3]
478 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:13')
479 0
480 [connection master]
481 ---- 7.2 (4) ----
482 [connection server_3]
483 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:14,cccccccc-cccc-cccc-cccc-cccccccccccc:15');
484 [connection server_3_1]
485 include/wait_for_wait_for_executed_gtid_set.inc
486 [connection master]
487 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:14';
488 COMMIT;
489 SET GTID_NEXT = 'AUTOMATIC';
490 [connection server_3_1]
491 include/wait_for_wait_for_executed_gtid_set.inc
492 [connection master]
493 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:15';
494 COMMIT;
495 SET GTID_NEXT = 'AUTOMATIC';
496 [connection server_3]
497 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:14,cccccccc-cccc-cccc-cccc-cccccccccccc:15')
498 0
499 [connection master]
500 ---- 7.3 (4) ----
501 [connection server_3]
502 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:16,dddddddd-dddd-dddd-dddd-dddddddddddd:7');
503 [connection server_3_1]
504 include/wait_for_wait_for_executed_gtid_set.inc
505 [connection master]
506 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:16';
507 COMMIT;
508 SET GTID_NEXT = 'AUTOMATIC';
509 [connection server_3_1]
510 include/wait_for_wait_for_executed_gtid_set.inc
511 [connection master]
512 SET GTID_NEXT = 'dddddddd-dddd-dddd-dddd-dddddddddddd:7';
513 COMMIT;
514 SET GTID_NEXT = 'AUTOMATIC';
515 [connection server_3]
516 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:16,dddddddd-dddd-dddd-dddd-dddddddddddd:7')
517 0
518 [connection master]
519 ---- 7.4 (4) ----
520 [connection server_3]
521 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1,cccccccc-cccc-cccc-cccc-cccccccccccc:17,dddddddd-dddd-dddd-dddd-dddddddddddd:8');
522 [connection server_3_1]
523 include/wait_for_wait_for_executed_gtid_set.inc
524 [connection master]
525 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:17';
526 COMMIT;
527 SET GTID_NEXT = 'AUTOMATIC';
528 [connection server_3_1]
529 include/wait_for_wait_for_executed_gtid_set.inc
530 [connection master]
531 SET GTID_NEXT = 'dddddddd-dddd-dddd-dddd-dddddddddddd:8';
532 COMMIT;
533 SET GTID_NEXT = 'AUTOMATIC';
534 [connection server_3]
535 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:1,cccccccc-cccc-cccc-cccc-cccccccccccc:17,dddddddd-dddd-dddd-dddd-dddddddddddd:8')
536 0
537 [connection master]
538 ---- 7.5 (4) ----
539 [connection server_3]
540 SELECT WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:18,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3');
541 [connection server_3_1]
542 include/wait_for_wait_for_executed_gtid_set.inc
543 [connection master]
544 SET GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:18';
545 COMMIT;
546 SET GTID_NEXT = 'AUTOMATIC';
547 [connection server_3]
548 WAIT_FOR_EXECUTED_GTID_SET('cccccccc-cccc-cccc-cccc-cccccccccccc:18,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3')
549 0
550 [connection master]
551 ---- 7.6 (4) ----
552 [connection server_3]
553 SELECT WAIT_FOR_EXECUTED_GTID_SET('UUID:1');
554 [connection server_3_1]
555 include/wait_for_wait_for_executed_gtid_set.inc
556 [connection master]
557 SET GTID_NEXT = 'UUID:1';
558 COMMIT;
559 SET GTID_NEXT = 'AUTOMATIC';
560 [connection server_3]
561 WAIT_FOR_EXECUTED_GTID_SET('UUID:1')
562 0
563 [connection master]
564 ==== 8.1 SET GTID_PURGED ====
565 DROP TABLE t1;
566 include/rpl_sync.inc
567 include/rpl_stop_slaves.inc
568 RESET MASTER;
569 [connection master1]
570 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-1234567890');
571 [connection master]
572 include/wait_for_wait_for_executed_gtid_set.inc
573 SET GLOBAL GTID_PURGED = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-1234567890';
574 [connection master1]
575 WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-1234567890')
576 0
577 [connection master]
578 ==== 9. RESET MASTER ====
579 RESET MASTER;
580 [connection master1]
581 SELECT WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1,cccccccc-cccc-cccc-cccc-cccccccccccc:1');
582 [connection master]
583 include/wait_for_wait_for_executed_gtid_set.inc
584 SET GLOBAL GTID_PURGED = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
585 SET GTID_NEXT = 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1';
586 COMMIT;
587 SET GTID_NEXT = 'AUTOMATIC';
588 RESET MASTER;
589 SET SESSION GTID_NEXT = 'cccccccc-cccc-cccc-cccc-cccccccccccc:1';
590 COMMIT;
591 SET GTID_NEXT = 'AUTOMATIC';
592 SET SESSION GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
593 COMMIT;
594 SET GTID_NEXT = 'AUTOMATIC';
595 include/wait_for_wait_for_executed_gtid_set.inc
596 SET SESSION GTID_NEXT = 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1';
597 COMMIT;
598 SET GTID_NEXT = 'AUTOMATIC';
599 [connection master1]
600 WAIT_FOR_EXECUTED_GTID_SET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1,cccccccc-cccc-cccc-cccc-cccccccccccc:1')
601 0
602 [connection master]
603 ==== 10. Clean up ====
604 include/rpl_end.inc