Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_check_gtid.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 call mtr.add_suppression("Recovery from source pos .*");
7 call mtr.add_suppression("Error in Log_event::read_log_event()");
8 call mtr.add_suppression("Failed to read information on Previous GTIDs.");
9 call mtr.add_suppression("Error reading GTIDs from binary log");
10 CREATE TABLE t1(id INTEGER) ENGINE= Innodb;
11 ==== Part 1 ====
12 include/rpl_reset.inc
13 ---- i=1 ----
14 BEGIN;
15 INSERT INTO t1 VALUES(1);
16 INSERT INTO t1 VALUES(2);
17 COMMIT;
18 extra/rpl_tests/rpl_check_gtid.inc
19 include/sync_slave_sql_with_master.inc
20 extra/rpl_tests/rpl_check_gtid.inc
21 extra/rpl_tests/rpl_check_gtid.inc
22 BEGIN;
23 INSERT INTO t1 VALUES(1);
24 INSERT INTO t1 VALUES(2);
25 COMMIT;
26 extra/rpl_tests/rpl_check_gtid.inc
27 FLUSH LOGS;
28 FLUSH LOGS;
29 ---- i=2 ----
30 BEGIN;
31 INSERT INTO t1 VALUES(1);
32 INSERT INTO t1 VALUES(2);
33 COMMIT;
34 extra/rpl_tests/rpl_check_gtid.inc
35 include/sync_slave_sql_with_master.inc
36 extra/rpl_tests/rpl_check_gtid.inc
37 extra/rpl_tests/rpl_check_gtid.inc
38 BEGIN;
39 INSERT INTO t1 VALUES(1);
40 INSERT INTO t1 VALUES(2);
41 COMMIT;
42 extra/rpl_tests/rpl_check_gtid.inc
43 FLUSH LOGS;
44 FLUSH LOGS;
45 ---- i=3 ----
46 BEGIN;
47 INSERT INTO t1 VALUES(1);
48 INSERT INTO t1 VALUES(2);
49 COMMIT;
50 extra/rpl_tests/rpl_check_gtid.inc
51 include/sync_slave_sql_with_master.inc
52 extra/rpl_tests/rpl_check_gtid.inc
53 extra/rpl_tests/rpl_check_gtid.inc
54 BEGIN;
55 INSERT INTO t1 VALUES(1);
56 INSERT INTO t1 VALUES(2);
57 COMMIT;
58 extra/rpl_tests/rpl_check_gtid.inc
59 FLUSH LOGS;
60 FLUSH LOGS;
61 ---- i=4 ----
62 BEGIN;
63 INSERT INTO t1 VALUES(1);
64 INSERT INTO t1 VALUES(2);
65 COMMIT;
66 extra/rpl_tests/rpl_check_gtid.inc
67 include/sync_slave_sql_with_master.inc
68 extra/rpl_tests/rpl_check_gtid.inc
69 extra/rpl_tests/rpl_check_gtid.inc
70 BEGIN;
71 INSERT INTO t1 VALUES(1);
72 INSERT INTO t1 VALUES(2);
73 COMMIT;
74 extra/rpl_tests/rpl_check_gtid.inc
75 FLUSH LOGS;
76 FLUSH LOGS;
77 ==== Part 2 ====
78 include/rpl_reset.inc
79 include/stop_slave.inc
80 include/start_slave.inc
81 BEGIN;
82 INSERT INTO t1 VALUES(0);
83 COMMIT;
84 include/sync_slave_sql_with_master.inc
85 ---- i=1 ----
86 [connection slave]
87 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
88 [connection master]
89 BEGIN;
90 INSERT INTO t1 VALUES(1);
91 INSERT INTO t1 VALUES(2);
92 COMMIT;
93 [connection slave]
94 Waiting for 3 more event(s) before flushing relaylog
95 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
96 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
97 Waiting for 2 more event(s) before flushing relaylog
98 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
99 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
100 Waiting for 1 more event(s) before flushing relaylog
101 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
102 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
103 FLUSH LOCAL RELAY LOGS;
104 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
105 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
106 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
107 [connection master]
108 include/sync_slave_sql_with_master.inc
109 extra/rpl_tests/rpl_check_gtid.inc
110 FLUSH LOGS;
111 ---- i=2 ----
112 [connection slave]
113 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
114 [connection master]
115 BEGIN;
116 INSERT INTO t1 VALUES(1);
117 INSERT INTO t1 VALUES(2);
118 COMMIT;
119 [connection slave]
120 Waiting for 3 more event(s) before flushing relaylog
121 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
122 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
123 Waiting for 2 more event(s) before flushing relaylog
124 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
125 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
126 Waiting for 1 more event(s) before flushing relaylog
127 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
128 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
129 FLUSH LOCAL RELAY LOGS;
130 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
131 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
132 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
133 [connection master]
134 include/sync_slave_sql_with_master.inc
135 extra/rpl_tests/rpl_check_gtid.inc
136 FLUSH LOGS;
137 ---- i=3 ----
138 [connection slave]
139 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
140 [connection master]
141 BEGIN;
142 INSERT INTO t1 VALUES(1);
143 INSERT INTO t1 VALUES(2);
144 COMMIT;
145 [connection slave]
146 Waiting for 3 more event(s) before flushing relaylog
147 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
148 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
149 Waiting for 2 more event(s) before flushing relaylog
150 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
151 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
152 Waiting for 1 more event(s) before flushing relaylog
153 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
154 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
155 FLUSH LOCAL RELAY LOGS;
156 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
157 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
158 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
159 [connection master]
160 include/sync_slave_sql_with_master.inc
161 extra/rpl_tests/rpl_check_gtid.inc
162 FLUSH LOGS;
163 ---- i=4 ----
164 [connection slave]
165 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
166 [connection master]
167 BEGIN;
168 INSERT INTO t1 VALUES(1);
169 INSERT INTO t1 VALUES(2);
170 COMMIT;
171 [connection slave]
172 Waiting for 3 more event(s) before flushing relaylog
173 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
174 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
175 Waiting for 2 more event(s) before flushing relaylog
176 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
177 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
178 Waiting for 1 more event(s) before flushing relaylog
179 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
180 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
181 FLUSH LOCAL RELAY LOGS;
182 SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event';
183 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
184 SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event';
185 [connection master]
186 include/sync_slave_sql_with_master.inc
187 extra/rpl_tests/rpl_check_gtid.inc
188 FLUSH LOGS;
189 ==== Part 3 ====
190 include/rpl_reset.inc
191 include/stop_slave.inc
192 SET GLOBAL debug="";
193 include/start_slave.inc
194 ---- i=1 ----
195 BEGIN;
196 INSERT INTO t1 VALUES(1);
197 INSERT INTO t1 VALUES(2);
198 COMMIT;
199 include/sync_slave_sql_with_master.inc
200 extra/rpl_tests/rpl_check_gtid.inc
201 extra/rpl_tests/rpl_check_gtid.inc
202 include/stop_slave.inc
203 include/rpl_restart_server.inc [server_number=2]
204 include/start_slave.inc
205 FLUSH LOGS;
206 FLUSH LOGS;
207 ---- i=2 ----
208 BEGIN;
209 INSERT INTO t1 VALUES(1);
210 INSERT INTO t1 VALUES(2);
211 COMMIT;
212 include/sync_slave_sql_with_master.inc
213 extra/rpl_tests/rpl_check_gtid.inc
214 extra/rpl_tests/rpl_check_gtid.inc
215 include/stop_slave.inc
216 include/rpl_restart_server.inc [server_number=2]
217 include/start_slave.inc
218 FLUSH LOGS;
219 FLUSH LOGS;
220 ---- i=3 ----
221 BEGIN;
222 INSERT INTO t1 VALUES(1);
223 INSERT INTO t1 VALUES(2);
224 COMMIT;
225 include/sync_slave_sql_with_master.inc
226 extra/rpl_tests/rpl_check_gtid.inc
227 extra/rpl_tests/rpl_check_gtid.inc
228 include/stop_slave.inc
229 include/rpl_restart_server.inc [server_number=2]
230 include/start_slave.inc
231 FLUSH LOGS;
232 FLUSH LOGS;
233 ---- i=4 ----
234 BEGIN;
235 INSERT INTO t1 VALUES(1);
236 INSERT INTO t1 VALUES(2);
237 COMMIT;
238 include/sync_slave_sql_with_master.inc
239 extra/rpl_tests/rpl_check_gtid.inc
240 extra/rpl_tests/rpl_check_gtid.inc
241 include/stop_slave.inc
242 include/rpl_restart_server.inc [server_number=2]
243 include/start_slave.inc
244 FLUSH LOGS;
245 FLUSH LOGS;
246 ==== Part 4 ====
247 include/rpl_reset.inc
248 ---- i=1 ----
249 BEGIN;
250 INSERT INTO t1 VALUES(1);
251 INSERT INTO t1 VALUES(2);
252 COMMIT;
253 extra/rpl_tests/rpl_check_gtid.inc
254 include/sync_slave_sql_with_master.inc
255 extra/rpl_tests/rpl_check_gtid.inc
256 extra/rpl_tests/rpl_check_gtid.inc
257 include/stop_slave.inc
258 include/rpl_restart_server.inc [server_number=1]
259 include/start_slave.inc
260 FLUSH LOGS;
261 FLUSH LOGS;
262 ---- i=2 ----
263 BEGIN;
264 INSERT INTO t1 VALUES(1);
265 INSERT INTO t1 VALUES(2);
266 COMMIT;
267 extra/rpl_tests/rpl_check_gtid.inc
268 include/sync_slave_sql_with_master.inc
269 extra/rpl_tests/rpl_check_gtid.inc
270 extra/rpl_tests/rpl_check_gtid.inc
271 include/stop_slave.inc
272 include/rpl_restart_server.inc [server_number=1]
273 include/start_slave.inc
274 FLUSH LOGS;
275 FLUSH LOGS;
276 ---- i=3 ----
277 BEGIN;
278 INSERT INTO t1 VALUES(1);
279 INSERT INTO t1 VALUES(2);
280 COMMIT;
281 extra/rpl_tests/rpl_check_gtid.inc
282 include/sync_slave_sql_with_master.inc
283 extra/rpl_tests/rpl_check_gtid.inc
284 extra/rpl_tests/rpl_check_gtid.inc
285 include/stop_slave.inc
286 include/rpl_restart_server.inc [server_number=1]
287 include/start_slave.inc
288 FLUSH LOGS;
289 FLUSH LOGS;
290 ---- i=4 ----
291 BEGIN;
292 INSERT INTO t1 VALUES(1);
293 INSERT INTO t1 VALUES(2);
294 COMMIT;
295 extra/rpl_tests/rpl_check_gtid.inc
296 include/sync_slave_sql_with_master.inc
297 extra/rpl_tests/rpl_check_gtid.inc
298 extra/rpl_tests/rpl_check_gtid.inc
299 include/stop_slave.inc
300 include/rpl_restart_server.inc [server_number=1]
301 include/start_slave.inc
302 FLUSH LOGS;
303 FLUSH LOGS;
304 ==== Part 5 ====
305 ---- i=1 ----
306 include/stop_slave.inc
307 RESET SLAVE;
308 Warnings:
309 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
310 RESET MASTER;
311 RESET MASTER;
312 include/start_slave.inc
313 BEGIN;
314 INSERT INTO t1 VALUES(1);
315 INSERT INTO t1 VALUES(2);
316 COMMIT;
317 BEGIN;
318 INSERT INTO t1 VALUES(1);
319 INSERT INTO t1 VALUES(2);
320 COMMIT;
321 include/sync_slave_sql_with_master.inc
322 extra/rpl_tests/rpl_check_gtid.inc
323 FLUSH LOGS;
324 FLUSH LOGS;
325 ---- i=2 ----
326 include/stop_slave.inc
327 RESET SLAVE;
328 Warnings:
329 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
330 RESET MASTER;
331 RESET MASTER;
332 include/start_slave.inc
333 BEGIN;
334 INSERT INTO t1 VALUES(1);
335 INSERT INTO t1 VALUES(2);
336 COMMIT;
337 BEGIN;
338 INSERT INTO t1 VALUES(1);
339 INSERT INTO t1 VALUES(2);
340 COMMIT;
341 include/sync_slave_sql_with_master.inc
342 extra/rpl_tests/rpl_check_gtid.inc
343 FLUSH LOGS;
344 FLUSH LOGS;
345 ---- i=3 ----
346 include/stop_slave.inc
347 RESET SLAVE;
348 Warnings:
349 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
350 RESET MASTER;
351 RESET MASTER;
352 include/start_slave.inc
353 BEGIN;
354 INSERT INTO t1 VALUES(1);
355 INSERT INTO t1 VALUES(2);
356 COMMIT;
357 BEGIN;
358 INSERT INTO t1 VALUES(1);
359 INSERT INTO t1 VALUES(2);
360 COMMIT;
361 include/sync_slave_sql_with_master.inc
362 extra/rpl_tests/rpl_check_gtid.inc
363 FLUSH LOGS;
364 FLUSH LOGS;
365 ---- i=4 ----
366 include/stop_slave.inc
367 RESET SLAVE;
368 Warnings:
369 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
370 RESET MASTER;
371 RESET MASTER;
372 include/start_slave.inc
373 BEGIN;
374 INSERT INTO t1 VALUES(1);
375 INSERT INTO t1 VALUES(2);
376 COMMIT;
377 BEGIN;
378 INSERT INTO t1 VALUES(1);
379 INSERT INTO t1 VALUES(2);
380 COMMIT;
381 include/sync_slave_sql_with_master.inc
382 extra/rpl_tests/rpl_check_gtid.inc
383 FLUSH LOGS;
384 FLUSH LOGS;
385 ==== Part 6 ====
386 include/stop_slave.inc
387 RESET SLAVE;
388 Warnings:
389 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
390 RESET MASTER;
391 RESET MASTER;
392 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1, SOURCE_LOG_FILE= 'master-bin.000001', SOURCE_LOG_POS= 4;
393 ERROR HY000: Parameters SOURCE_LOG_FILE, SOURCE_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when SOURCE_AUTO_POSITION is active.
394 include/start_slave.inc
395 ---- i=1 ----
396 BEGIN;
397 INSERT INTO t1 VALUES(1);
398 INSERT INTO t1 VALUES(2);
399 COMMIT;
400 BEGIN;
401 INSERT INTO t1 VALUES(1);
402 INSERT INTO t1 VALUES(2);
403 COMMIT;
404 SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1');
405 SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-2');
406 extra/rpl_tests/rpl_check_gtid.inc
407 include/stop_slave.inc
408 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'SLAVE_MASTER_HOST', SOURCE_AUTO_POSITION= 1;
409 include/start_slave.inc
410 FLUSH LOGS;
411 ---- i=2 ----
412 BEGIN;
413 INSERT INTO t1 VALUES(1);
414 INSERT INTO t1 VALUES(2);
415 COMMIT;
416 BEGIN;
417 INSERT INTO t1 VALUES(1);
418 INSERT INTO t1 VALUES(2);
419 COMMIT;
420 SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-3', 300);
421 SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-4', 300);
422 extra/rpl_tests/rpl_check_gtid.inc
423 include/stop_slave.inc
424 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'SLAVE_MASTER_HOST', SOURCE_AUTO_POSITION= 1;
425 include/start_slave.inc
426 FLUSH LOGS;
427 ---- i=3 ----
428 BEGIN;
429 INSERT INTO t1 VALUES(1);
430 INSERT INTO t1 VALUES(2);
431 COMMIT;
432 BEGIN;
433 INSERT INTO t1 VALUES(1);
434 INSERT INTO t1 VALUES(2);
435 COMMIT;
436 SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-5');
437 SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-6');
438 extra/rpl_tests/rpl_check_gtid.inc
439 include/stop_slave.inc
440 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'SLAVE_MASTER_HOST', SOURCE_AUTO_POSITION= 1;
441 include/start_slave.inc
442 FLUSH LOGS;
443 ---- i=4 ----
444 BEGIN;
445 INSERT INTO t1 VALUES(1);
446 INSERT INTO t1 VALUES(2);
447 COMMIT;
448 BEGIN;
449 INSERT INTO t1 VALUES(1);
450 INSERT INTO t1 VALUES(2);
451 COMMIT;
452 SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-7', 300);
453 SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-8', 300);
454 extra/rpl_tests/rpl_check_gtid.inc
455 include/stop_slave.inc
456 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'SLAVE_MASTER_HOST', SOURCE_AUTO_POSITION= 1;
457 include/start_slave.inc
458 FLUSH LOGS;
459 ==== Part 7 ====
460 include/stop_slave.inc
461 RESET SLAVE;
462 Warnings:
463 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
464 RESET MASTER;
465 RESET MASTER;
466 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'SLAVE_MASTER_HOST', SOURCE_AUTO_POSITION= 1;
467 ---- i=1 ----
468 BEGIN;
469 INSERT INTO t1 VALUES(1);
470 INSERT INTO t1 VALUES(2);
471 COMMIT;
472 BEGIN;
473 INSERT INTO t1 VALUES(1);
474 INSERT INTO t1 VALUES(2);
475 COMMIT;
476 START SLAVE UNTIL SQL_BEFORE_GTIDS= "MASTER_UUID:2";
477 include/wait_for_slave_sql_to_stop.inc
478 include/stop_slave.inc
479 extra/rpl_tests/rpl_check_gtid.inc
480 FLUSH LOGS;
481 ---- i=2 ----
482 BEGIN;
483 INSERT INTO t1 VALUES(1);
484 INSERT INTO t1 VALUES(2);
485 COMMIT;
486 BEGIN;
487 INSERT INTO t1 VALUES(1);
488 INSERT INTO t1 VALUES(2);
489 COMMIT;
490 START SLAVE UNTIL SQL_BEFORE_GTIDS= "MASTER_UUID:4";
491 include/wait_for_slave_sql_to_stop.inc
492 include/stop_slave.inc
493 extra/rpl_tests/rpl_check_gtid.inc
494 FLUSH LOGS;
495 ---- i=3 ----
496 BEGIN;
497 INSERT INTO t1 VALUES(1);
498 INSERT INTO t1 VALUES(2);
499 COMMIT;
500 BEGIN;
501 INSERT INTO t1 VALUES(1);
502 INSERT INTO t1 VALUES(2);
503 COMMIT;
504 START SLAVE UNTIL SQL_BEFORE_GTIDS= "MASTER_UUID:6";
505 include/wait_for_slave_sql_to_stop.inc
506 include/stop_slave.inc
507 extra/rpl_tests/rpl_check_gtid.inc
508 FLUSH LOGS;
509 ---- i=4 ----
510 BEGIN;
511 INSERT INTO t1 VALUES(1);
512 INSERT INTO t1 VALUES(2);
513 COMMIT;
514 BEGIN;
515 INSERT INTO t1 VALUES(1);
516 INSERT INTO t1 VALUES(2);
517 COMMIT;
518 START SLAVE UNTIL SQL_BEFORE_GTIDS= "MASTER_UUID:8";
519 include/wait_for_slave_sql_to_stop.inc
520 include/stop_slave.inc
521 extra/rpl_tests/rpl_check_gtid.inc
522 FLUSH LOGS;
523 ==== Part 8 ====
524 include/stop_slave.inc
525 Warnings:
526 Note 3084 Replication thread(s) for channel '' are already stopped.
527 RESET MASTER;
528 RESET SLAVE;
529 Warnings:
530 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
531 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_AUTO_POSITION= 0;
532 RESET MASTER;
533 include/start_slave.inc
534 ---- i=1 ----
535 BEGIN;
536 INSERT INTO t1 VALUES(1);
537 INSERT INTO t1 VALUES(2);
538 COMMIT;
539 include/sync_slave_sql_with_master.inc
540 extra/rpl_tests/rpl_check_gtid.inc
541 extra/rpl_tests/rpl_check_gtid.inc
542 include/stop_slave.inc
543 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,skip_writing_previous_gtids_log_event]
544 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1]
545 include/start_slave.inc
546 FLUSH LOGS;
547 FLUSH LOGS;
548 ---- i=2 ----
549 BEGIN;
550 INSERT INTO t1 VALUES(1);
551 INSERT INTO t1 VALUES(2);
552 COMMIT;
553 include/sync_slave_sql_with_master.inc
554 extra/rpl_tests/rpl_check_gtid.inc
555 extra/rpl_tests/rpl_check_gtid.inc
556 include/stop_slave.inc
557 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,skip_writing_previous_gtids_log_event]
558 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1]
559 include/start_slave.inc
560 FLUSH LOGS;
561 FLUSH LOGS;
562 ---- i=3 ----
563 BEGIN;
564 INSERT INTO t1 VALUES(1);
565 INSERT INTO t1 VALUES(2);
566 COMMIT;
567 include/sync_slave_sql_with_master.inc
568 extra/rpl_tests/rpl_check_gtid.inc
569 extra/rpl_tests/rpl_check_gtid.inc
570 include/stop_slave.inc
571 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,skip_writing_previous_gtids_log_event]
572 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1]
573 include/start_slave.inc
574 FLUSH LOGS;
575 FLUSH LOGS;
576 ---- i=4 ----
577 BEGIN;
578 INSERT INTO t1 VALUES(1);
579 INSERT INTO t1 VALUES(2);
580 COMMIT;
581 include/sync_slave_sql_with_master.inc
582 extra/rpl_tests/rpl_check_gtid.inc
583 extra/rpl_tests/rpl_check_gtid.inc
584 include/stop_slave.inc
585 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,skip_writing_previous_gtids_log_event]
586 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1]
587 include/start_slave.inc
588 FLUSH LOGS;
589 FLUSH LOGS;
590 ==== Part 9 ====
591 include/rpl_reset.inc
592 ---- i=1 ----
593 BEGIN;
594 INSERT INTO t1 VALUES(1);
595 INSERT INTO t1 VALUES(2);
596 COMMIT;
597 include/sync_slave_sql_with_master.inc
598 extra/rpl_tests/rpl_check_gtid.inc
599 extra/rpl_tests/rpl_check_gtid.inc
600 include/stop_slave.inc
601 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,write_partial_previous_gtids_log_event]
602 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1]
603 include/start_slave.inc
604 FLUSH LOGS;
605 FLUSH LOGS;
606 ---- i=2 ----
607 BEGIN;
608 INSERT INTO t1 VALUES(1);
609 INSERT INTO t1 VALUES(2);
610 COMMIT;
611 include/sync_slave_sql_with_master.inc
612 extra/rpl_tests/rpl_check_gtid.inc
613 extra/rpl_tests/rpl_check_gtid.inc
614 include/stop_slave.inc
615 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,write_partial_previous_gtids_log_event]
616 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1]
617 include/start_slave.inc
618 FLUSH LOGS;
619 FLUSH LOGS;
620 ---- i=3 ----
621 BEGIN;
622 INSERT INTO t1 VALUES(1);
623 INSERT INTO t1 VALUES(2);
624 COMMIT;
625 include/sync_slave_sql_with_master.inc
626 extra/rpl_tests/rpl_check_gtid.inc
627 extra/rpl_tests/rpl_check_gtid.inc
628 include/stop_slave.inc
629 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,write_partial_previous_gtids_log_event]
630 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1]
631 include/start_slave.inc
632 FLUSH LOGS;
633 FLUSH LOGS;
634 ---- i=4 ----
635 BEGIN;
636 INSERT INTO t1 VALUES(1);
637 INSERT INTO t1 VALUES(2);
638 COMMIT;
639 include/sync_slave_sql_with_master.inc
640 extra/rpl_tests/rpl_check_gtid.inc
641 extra/rpl_tests/rpl_check_gtid.inc
642 include/stop_slave.inc
643 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,write_partial_previous_gtids_log_event]
644 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1]
645 include/start_slave.inc
646 FLUSH LOGS;
647 FLUSH LOGS;
648 include/rpl_reset.inc
649 DROP TABLE t1;
650 # Failure on creating compression thread
651 include/sync_slave_sql_with_master.inc
652 include/stop_slave.inc
653 call mtr.add_suppression("Can not create thread to compress gtid_executed table .*");
654 include/rpl_restart_server.inc [server_number=2 parameters: --debug=d,simulate_create_compress_thread_failure]
655 include/assert.inc [compression thread is destroied;]
656 call mtr.add_suppression("Plugin 'InnoDB' will be forced to shutdown");
657 call mtr.add_suppression("Plugin 'InnoDB' has ref_count=.* after shutdown");
658 include/rpl_restart_server.inc [server_number=2]
659 include/start_slave.inc
660 include/rpl_end.inc