Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_trx_boundary_parser_row.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 # Using InnoDB storage engine
7 ## Running the test with the SQL thread stopped
8 [connection slave]
9 include/stop_slave_sql.inc
10 [connection slave]
11 [connection master]
12 [connection slave]
13 include/gtid_step_reset_on_retrieved.inc
14 [connection master]
15 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=INNODB;
16 CREATE TABLE t2 (i INT) ENGINE=INNODB;
17 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
18 BEGIN;
19 INSERT INTO t2 (i) VALUES (-6);
20 INSERT INTO t2 (i) VALUES (-5);
21 INSERT INTO t2 (i) VALUES (-4);
22 COMMIT;
23 [connection master]
24 include/sync_slave_io_with_master.inc
25 [connection slave]
26 include/stop_slave_io.inc
27 include/start_slave_io.inc
28 [connection slave]
29 include/gtid_step_assert_on_retrieved.inc [count=4, only_count=0]
30 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
31 [connection master]
32 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
33 BEGIN;
34 INSERT INTO t2 (i) VALUES (-3);
35 INSERT INTO t2 (i) VALUES (-2);
36 COMMIT;
37 FLUSH LOGS;
38 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
39 BEGIN;
40 INSERT INTO t2 (i) VALUES (-1);
41 INSERT INTO t2 (i) VALUES (0);
42 COMMIT;
43 [connection master]
44 include/sync_slave_io_with_master.inc
45 [connection slave]
46 include/stop_slave_io.inc
47 include/start_slave_io.inc
48 [connection slave]
49 include/gtid_step_assert_on_retrieved.inc [count=4, only_count=0]
50 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
51 [connection slave]
52 [connection master]
53 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
54 include/sync_slave_io_with_master.inc
55 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
56 [connection master]
57 BEGIN;
58 INSERT INTO t2 VALUES (100 * 1 + 1);
59 SET @val= 100 * 1 + 2;
60 INSERT INTO t2 VALUES (@val);
61 COMMIT;
62 [connection slave]
63 include/wait_for_slave_io_to_stop.inc
64 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
65 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
66 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
67 [connection master]
68 INSERT INTO t2 VALUES (100 * 1 + 3);
69 [connection slave]
70 include/start_slave_io.inc
71 [connection master]
72 include/sync_slave_io_with_master.inc
73 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
74 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
75 [connection slave]
76 [connection master]
77 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
78 include/sync_slave_io_with_master.inc
79 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
80 [connection master]
81 BEGIN;
82 INSERT INTO t2 VALUES (100 * 2 + 1);
83 SET @val= 100 * 2 + 2;
84 INSERT INTO t2 VALUES (@val);
85 COMMIT;
86 [connection slave]
87 include/wait_for_slave_io_to_stop.inc
88 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
89 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
90 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
91 [connection master]
92 INSERT INTO t2 VALUES (100 * 2 + 3);
93 [connection slave]
94 include/start_slave_io.inc
95 [connection master]
96 include/sync_slave_io_with_master.inc
97 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
98 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
99 [connection slave]
100 [connection master]
101 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event');
102 include/sync_slave_io_with_master.inc
103 # Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug
104 [connection master]
105 BEGIN;
106 INSERT INTO t2 VALUES (100 * 3 + 1);
107 SET @val= 100 * 3 + 2;
108 INSERT INTO t2 VALUES (@val);
109 COMMIT;
110 [connection slave]
111 include/wait_for_slave_io_to_stop.inc
112 # Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug
113 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
114 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
115 [connection master]
116 INSERT INTO t2 VALUES (100 * 3 + 3);
117 [connection slave]
118 include/start_slave_io.inc
119 [connection master]
120 include/sync_slave_io_with_master.inc
121 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
122 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
123 [connection slave]
124 [connection master]
125 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_xid_log_event');
126 include/sync_slave_io_with_master.inc
127 # Adding debug point 'stop_io_after_reading_xid_log_event' to @@GLOBAL.debug
128 [connection master]
129 BEGIN;
130 INSERT INTO t2 VALUES (100 * 4 + 1);
131 SET @val= 100 * 4 + 2;
132 INSERT INTO t2 VALUES (@val);
133 COMMIT;
134 [connection slave]
135 include/wait_for_slave_io_to_stop.inc
136 # Removing debug point 'stop_io_after_reading_xid_log_event' from @@GLOBAL.debug
137 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
138 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
139 [connection master]
140 INSERT INTO t2 VALUES (100 * 4 + 3);
141 [connection slave]
142 include/start_slave_io.inc
143 [connection master]
144 include/sync_slave_io_with_master.inc
145 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
146 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
147 [connection master]
148 DROP TABLE t1,t2;
149 ## Starting and syncing the SQL thread before next round
150 [connection slave]
151 include/start_slave_sql.inc
152 [connection master]
153 include/sync_slave_sql_with_master.inc
154 ## Running the test with the SQL thread started
155 [connection slave]
156 [connection master]
157 [connection slave]
158 include/gtid_step_reset.inc
159 [connection master]
160 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=INNODB;
161 CREATE TABLE t2 (i INT) ENGINE=INNODB;
162 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
163 BEGIN;
164 INSERT INTO t2 (i) VALUES (-6);
165 INSERT INTO t2 (i) VALUES (-5);
166 INSERT INTO t2 (i) VALUES (-4);
167 COMMIT;
168 [connection master]
169 include/sync_slave_sql_with_master.inc
170 include/diff_tables.inc [master:t1, slave:t1]
171 [connection slave]
172 include/stop_slave_io.inc
173 include/start_slave_io.inc
174 [connection slave]
175 include/gtid_step_assert.inc [count=4, only_count=0]
176 [connection master]
177 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
178 BEGIN;
179 INSERT INTO t2 (i) VALUES (-3);
180 INSERT INTO t2 (i) VALUES (-2);
181 COMMIT;
182 FLUSH LOGS;
183 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
184 BEGIN;
185 INSERT INTO t2 (i) VALUES (-1);
186 INSERT INTO t2 (i) VALUES (0);
187 COMMIT;
188 [connection master]
189 include/sync_slave_sql_with_master.inc
190 include/diff_tables.inc [master:t1, slave:t1]
191 [connection slave]
192 include/stop_slave_io.inc
193 include/start_slave_io.inc
194 [connection slave]
195 include/gtid_step_assert.inc [count=4, only_count=0]
196 [connection slave]
197 [connection master]
198 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
199 include/sync_slave_io_with_master.inc
200 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
201 [connection master]
202 BEGIN;
203 INSERT INTO t2 VALUES (100 * 1 + 1);
204 SET @val= 100 * 1 + 2;
205 INSERT INTO t2 VALUES (@val);
206 COMMIT;
207 [connection slave]
208 include/wait_for_slave_io_to_stop.inc
209 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
210 include/sync_slave_sql_with_io.inc
211 include/gtid_step_assert.inc [count=1, only_count=0]
212 [connection master]
213 INSERT INTO t2 VALUES (100 * 1 + 3);
214 [connection slave]
215 include/start_slave_io.inc
216 [connection master]
217 include/sync_slave_sql_with_master.inc
218 include/gtid_step_assert.inc [count=2, only_count=0]
219 [connection slave]
220 [connection master]
221 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
222 include/sync_slave_io_with_master.inc
223 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
224 [connection master]
225 BEGIN;
226 INSERT INTO t2 VALUES (100 * 2 + 1);
227 SET @val= 100 * 2 + 2;
228 INSERT INTO t2 VALUES (@val);
229 COMMIT;
230 [connection slave]
231 include/wait_for_slave_io_to_stop.inc
232 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
233 include/sync_slave_sql_with_io.inc
234 include/gtid_step_assert.inc [count=1, only_count=0]
235 [connection master]
236 INSERT INTO t2 VALUES (100 * 2 + 3);
237 [connection slave]
238 include/start_slave_io.inc
239 [connection master]
240 include/sync_slave_sql_with_master.inc
241 include/gtid_step_assert.inc [count=2, only_count=0]
242 [connection slave]
243 [connection master]
244 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event');
245 include/sync_slave_io_with_master.inc
246 # Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug
247 [connection master]
248 BEGIN;
249 INSERT INTO t2 VALUES (100 * 3 + 1);
250 SET @val= 100 * 3 + 2;
251 INSERT INTO t2 VALUES (@val);
252 COMMIT;
253 [connection slave]
254 include/wait_for_slave_io_to_stop.inc
255 # Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug
256 include/sync_slave_sql_with_io.inc
257 include/gtid_step_assert.inc [count=1, only_count=0]
258 [connection master]
259 INSERT INTO t2 VALUES (100 * 3 + 3);
260 [connection slave]
261 include/start_slave_io.inc
262 [connection master]
263 include/sync_slave_sql_with_master.inc
264 include/gtid_step_assert.inc [count=2, only_count=0]
265 [connection slave]
266 [connection master]
267 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_xid_log_event');
268 include/sync_slave_io_with_master.inc
269 # Adding debug point 'stop_io_after_reading_xid_log_event' to @@GLOBAL.debug
270 [connection master]
271 BEGIN;
272 INSERT INTO t2 VALUES (100 * 4 + 1);
273 SET @val= 100 * 4 + 2;
274 INSERT INTO t2 VALUES (@val);
275 COMMIT;
276 [connection slave]
277 include/wait_for_slave_io_to_stop.inc
278 # Removing debug point 'stop_io_after_reading_xid_log_event' from @@GLOBAL.debug
279 include/sync_slave_sql_with_io.inc
280 include/gtid_step_assert.inc [count=2, only_count=0]
281 [connection master]
282 INSERT INTO t2 VALUES (100 * 4 + 3);
283 [connection slave]
284 include/start_slave_io.inc
285 [connection master]
286 include/sync_slave_sql_with_master.inc
287 include/gtid_step_assert.inc [count=1, only_count=0]
288 [connection master]
289 include/sync_slave_sql_with_master.inc
290 include/diff_tables.inc [master:t1, slave:t1]
291 [connection master]
292 DROP TABLE t1,t2;
293 include/sync_slave_sql_with_master.inc
294 [connection slave]
295 include/stop_slave.inc
296 RESET MASTER;
297 RESET SLAVE;
298 Warnings:
299 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
300 [connection master]
301 RESET MASTER;
302 [connection slave]
303 include/stop_slave.inc
304 Warnings:
305 Note 3084 Replication thread(s) for channel '' are already stopped.
306 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
307 include/start_slave.inc
308 # Using InnoDB storage engine without auto positioning
309 ## Running the test with the SQL thread stopped
310 [connection slave]
311 include/stop_slave_sql.inc
312 [connection slave]
313 [connection master]
314 [connection slave]
315 include/gtid_step_reset_on_retrieved.inc
316 [connection master]
317 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=INNODB;
318 CREATE TABLE t2 (i INT) ENGINE=INNODB;
319 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
320 BEGIN;
321 INSERT INTO t2 (i) VALUES (-6);
322 INSERT INTO t2 (i) VALUES (-5);
323 INSERT INTO t2 (i) VALUES (-4);
324 COMMIT;
325 [connection master]
326 include/sync_slave_io_with_master.inc
327 [connection slave]
328 include/stop_slave_io.inc
329 include/start_slave_io.inc
330 [connection slave]
331 include/gtid_step_assert_on_retrieved.inc [count=4, only_count=0]
332 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
333 [connection master]
334 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
335 BEGIN;
336 INSERT INTO t2 (i) VALUES (-3);
337 INSERT INTO t2 (i) VALUES (-2);
338 COMMIT;
339 FLUSH LOGS;
340 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
341 BEGIN;
342 INSERT INTO t2 (i) VALUES (-1);
343 INSERT INTO t2 (i) VALUES (0);
344 COMMIT;
345 [connection master]
346 include/sync_slave_io_with_master.inc
347 [connection slave]
348 include/stop_slave_io.inc
349 include/start_slave_io.inc
350 [connection slave]
351 include/gtid_step_assert_on_retrieved.inc [count=4, only_count=0]
352 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
353 [connection slave]
354 [connection master]
355 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
356 include/sync_slave_io_with_master.inc
357 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
358 [connection master]
359 BEGIN;
360 INSERT INTO t2 VALUES (100 * 1 + 1);
361 SET @val= 100 * 1 + 2;
362 INSERT INTO t2 VALUES (@val);
363 COMMIT;
364 [connection slave]
365 include/wait_for_slave_io_to_stop.inc
366 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
367 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
368 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
369 [connection master]
370 INSERT INTO t2 VALUES (100 * 1 + 3);
371 [connection slave]
372 include/start_slave_io.inc
373 [connection master]
374 include/sync_slave_io_with_master.inc
375 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
376 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
377 [connection slave]
378 [connection master]
379 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
380 include/sync_slave_io_with_master.inc
381 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
382 [connection master]
383 BEGIN;
384 INSERT INTO t2 VALUES (100 * 2 + 1);
385 SET @val= 100 * 2 + 2;
386 INSERT INTO t2 VALUES (@val);
387 COMMIT;
388 [connection slave]
389 include/wait_for_slave_io_to_stop.inc
390 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
391 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
392 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
393 [connection master]
394 INSERT INTO t2 VALUES (100 * 2 + 3);
395 [connection slave]
396 include/start_slave_io.inc
397 [connection master]
398 include/sync_slave_io_with_master.inc
399 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
400 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
401 [connection slave]
402 [connection master]
403 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event');
404 include/sync_slave_io_with_master.inc
405 # Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug
406 [connection master]
407 BEGIN;
408 INSERT INTO t2 VALUES (100 * 3 + 1);
409 SET @val= 100 * 3 + 2;
410 INSERT INTO t2 VALUES (@val);
411 COMMIT;
412 [connection slave]
413 include/wait_for_slave_io_to_stop.inc
414 # Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug
415 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
416 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
417 [connection master]
418 INSERT INTO t2 VALUES (100 * 3 + 3);
419 [connection slave]
420 include/start_slave_io.inc
421 [connection master]
422 include/sync_slave_io_with_master.inc
423 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
424 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
425 [connection slave]
426 [connection master]
427 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_xid_log_event');
428 include/sync_slave_io_with_master.inc
429 # Adding debug point 'stop_io_after_reading_xid_log_event' to @@GLOBAL.debug
430 [connection master]
431 BEGIN;
432 INSERT INTO t2 VALUES (100 * 4 + 1);
433 SET @val= 100 * 4 + 2;
434 INSERT INTO t2 VALUES (@val);
435 COMMIT;
436 [connection slave]
437 include/wait_for_slave_io_to_stop.inc
438 # Removing debug point 'stop_io_after_reading_xid_log_event' from @@GLOBAL.debug
439 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
440 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
441 [connection master]
442 INSERT INTO t2 VALUES (100 * 4 + 3);
443 [connection slave]
444 include/start_slave_io.inc
445 [connection master]
446 include/sync_slave_io_with_master.inc
447 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
448 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
449 [connection master]
450 DROP TABLE t1,t2;
451 ## Starting and syncing the SQL thread before next round
452 [connection slave]
453 include/start_slave_sql.inc
454 [connection master]
455 include/sync_slave_sql_with_master.inc
456 ## Running the test with the SQL thread started
457 [connection slave]
458 [connection master]
459 [connection slave]
460 include/gtid_step_reset.inc
461 [connection master]
462 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=INNODB;
463 CREATE TABLE t2 (i INT) ENGINE=INNODB;
464 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
465 BEGIN;
466 INSERT INTO t2 (i) VALUES (-6);
467 INSERT INTO t2 (i) VALUES (-5);
468 INSERT INTO t2 (i) VALUES (-4);
469 COMMIT;
470 [connection master]
471 include/sync_slave_sql_with_master.inc
472 include/diff_tables.inc [master:t1, slave:t1]
473 [connection slave]
474 include/stop_slave_io.inc
475 include/start_slave_io.inc
476 [connection slave]
477 include/gtid_step_assert.inc [count=4, only_count=0]
478 [connection master]
479 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
480 BEGIN;
481 INSERT INTO t2 (i) VALUES (-3);
482 INSERT INTO t2 (i) VALUES (-2);
483 COMMIT;
484 FLUSH LOGS;
485 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
486 BEGIN;
487 INSERT INTO t2 (i) VALUES (-1);
488 INSERT INTO t2 (i) VALUES (0);
489 COMMIT;
490 [connection master]
491 include/sync_slave_sql_with_master.inc
492 include/diff_tables.inc [master:t1, slave:t1]
493 [connection slave]
494 include/stop_slave_io.inc
495 include/start_slave_io.inc
496 [connection slave]
497 include/gtid_step_assert.inc [count=4, only_count=0]
498 [connection slave]
499 [connection master]
500 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
501 include/sync_slave_io_with_master.inc
502 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
503 [connection master]
504 BEGIN;
505 INSERT INTO t2 VALUES (100 * 1 + 1);
506 SET @val= 100 * 1 + 2;
507 INSERT INTO t2 VALUES (@val);
508 COMMIT;
509 [connection slave]
510 include/wait_for_slave_io_to_stop.inc
511 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
512 include/sync_slave_sql_with_io.inc
513 include/gtid_step_assert.inc [count=1, only_count=0]
514 [connection master]
515 INSERT INTO t2 VALUES (100 * 1 + 3);
516 [connection slave]
517 include/start_slave_io.inc
518 [connection master]
519 include/sync_slave_sql_with_master.inc
520 include/gtid_step_assert.inc [count=2, only_count=0]
521 [connection slave]
522 [connection master]
523 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
524 include/sync_slave_io_with_master.inc
525 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
526 [connection master]
527 BEGIN;
528 INSERT INTO t2 VALUES (100 * 2 + 1);
529 SET @val= 100 * 2 + 2;
530 INSERT INTO t2 VALUES (@val);
531 COMMIT;
532 [connection slave]
533 include/wait_for_slave_io_to_stop.inc
534 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
535 include/sync_slave_sql_with_io.inc
536 include/gtid_step_assert.inc [count=1, only_count=0]
537 [connection master]
538 INSERT INTO t2 VALUES (100 * 2 + 3);
539 [connection slave]
540 include/start_slave_io.inc
541 [connection master]
542 include/sync_slave_sql_with_master.inc
543 include/gtid_step_assert.inc [count=2, only_count=0]
544 [connection slave]
545 [connection master]
546 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event');
547 include/sync_slave_io_with_master.inc
548 # Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug
549 [connection master]
550 BEGIN;
551 INSERT INTO t2 VALUES (100 * 3 + 1);
552 SET @val= 100 * 3 + 2;
553 INSERT INTO t2 VALUES (@val);
554 COMMIT;
555 [connection slave]
556 include/wait_for_slave_io_to_stop.inc
557 # Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug
558 include/sync_slave_sql_with_io.inc
559 include/gtid_step_assert.inc [count=1, only_count=0]
560 [connection master]
561 INSERT INTO t2 VALUES (100 * 3 + 3);
562 [connection slave]
563 include/start_slave_io.inc
564 [connection master]
565 include/sync_slave_sql_with_master.inc
566 include/gtid_step_assert.inc [count=2, only_count=0]
567 [connection slave]
568 [connection master]
569 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_xid_log_event');
570 include/sync_slave_io_with_master.inc
571 # Adding debug point 'stop_io_after_reading_xid_log_event' to @@GLOBAL.debug
572 [connection master]
573 BEGIN;
574 INSERT INTO t2 VALUES (100 * 4 + 1);
575 SET @val= 100 * 4 + 2;
576 INSERT INTO t2 VALUES (@val);
577 COMMIT;
578 [connection slave]
579 include/wait_for_slave_io_to_stop.inc
580 # Removing debug point 'stop_io_after_reading_xid_log_event' from @@GLOBAL.debug
581 include/sync_slave_sql_with_io.inc
582 include/gtid_step_assert.inc [count=2, only_count=0]
583 [connection master]
584 INSERT INTO t2 VALUES (100 * 4 + 3);
585 [connection slave]
586 include/start_slave_io.inc
587 [connection master]
588 include/sync_slave_sql_with_master.inc
589 include/gtid_step_assert.inc [count=1, only_count=0]
590 [connection master]
591 include/sync_slave_sql_with_master.inc
592 include/diff_tables.inc [master:t1, slave:t1]
593 [connection master]
594 DROP TABLE t1,t2;
595 include/sync_slave_sql_with_master.inc
596 [connection slave]
597 include/stop_slave.inc
598 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
599 include/start_slave.inc
600 include/rpl_end.inc