Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_trx_boundary_parser_stmt.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_user_var_log_event');
102 include/sync_slave_io_with_master.inc
103 # Adding debug point 'stop_io_after_reading_user_var_log_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_user_var_log_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_user_var_log_event');
245 include/sync_slave_io_with_master.inc
246 # Adding debug point 'stop_io_after_reading_user_var_log_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_user_var_log_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 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
304 include/start_slave.inc
305 # Using InnoDB storage engine without auto positioning
306 ## Running the test with the SQL thread stopped
307 [connection slave]
308 include/stop_slave_sql.inc
309 [connection slave]
310 [connection master]
311 [connection slave]
312 include/gtid_step_reset_on_retrieved.inc
313 [connection master]
314 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=INNODB;
315 CREATE TABLE t2 (i INT) ENGINE=INNODB;
316 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
317 BEGIN;
318 INSERT INTO t2 (i) VALUES (-6);
319 INSERT INTO t2 (i) VALUES (-5);
320 INSERT INTO t2 (i) VALUES (-4);
321 COMMIT;
322 [connection master]
323 include/sync_slave_io_with_master.inc
324 [connection slave]
325 include/stop_slave_io.inc
326 include/start_slave_io.inc
327 [connection slave]
328 include/gtid_step_assert_on_retrieved.inc [count=4, only_count=0]
329 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
330 [connection master]
331 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
332 BEGIN;
333 INSERT INTO t2 (i) VALUES (-3);
334 INSERT INTO t2 (i) VALUES (-2);
335 COMMIT;
336 FLUSH LOGS;
337 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
338 BEGIN;
339 INSERT INTO t2 (i) VALUES (-1);
340 INSERT INTO t2 (i) VALUES (0);
341 COMMIT;
342 [connection master]
343 include/sync_slave_io_with_master.inc
344 [connection slave]
345 include/stop_slave_io.inc
346 include/start_slave_io.inc
347 [connection slave]
348 include/gtid_step_assert_on_retrieved.inc [count=4, only_count=0]
349 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
350 [connection slave]
351 [connection master]
352 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
353 include/sync_slave_io_with_master.inc
354 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
355 [connection master]
356 BEGIN;
357 INSERT INTO t2 VALUES (100 * 1 + 1);
358 SET @val= 100 * 1 + 2;
359 INSERT INTO t2 VALUES (@val);
360 COMMIT;
361 [connection slave]
362 include/wait_for_slave_io_to_stop.inc
363 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
364 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
365 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
366 [connection master]
367 INSERT INTO t2 VALUES (100 * 1 + 3);
368 [connection slave]
369 include/start_slave_io.inc
370 [connection master]
371 include/sync_slave_io_with_master.inc
372 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
373 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
374 [connection slave]
375 [connection master]
376 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
377 include/sync_slave_io_with_master.inc
378 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
379 [connection master]
380 BEGIN;
381 INSERT INTO t2 VALUES (100 * 2 + 1);
382 SET @val= 100 * 2 + 2;
383 INSERT INTO t2 VALUES (@val);
384 COMMIT;
385 [connection slave]
386 include/wait_for_slave_io_to_stop.inc
387 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
388 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
389 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
390 [connection master]
391 INSERT INTO t2 VALUES (100 * 2 + 3);
392 [connection slave]
393 include/start_slave_io.inc
394 [connection master]
395 include/sync_slave_io_with_master.inc
396 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
397 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
398 [connection slave]
399 [connection master]
400 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_user_var_log_event');
401 include/sync_slave_io_with_master.inc
402 # Adding debug point 'stop_io_after_reading_user_var_log_event' to @@GLOBAL.debug
403 [connection master]
404 BEGIN;
405 INSERT INTO t2 VALUES (100 * 3 + 1);
406 SET @val= 100 * 3 + 2;
407 INSERT INTO t2 VALUES (@val);
408 COMMIT;
409 [connection slave]
410 include/wait_for_slave_io_to_stop.inc
411 # Removing debug point 'stop_io_after_reading_user_var_log_event' from @@GLOBAL.debug
412 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
413 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
414 [connection master]
415 INSERT INTO t2 VALUES (100 * 3 + 3);
416 [connection slave]
417 include/start_slave_io.inc
418 [connection master]
419 include/sync_slave_io_with_master.inc
420 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
421 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
422 [connection slave]
423 [connection master]
424 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_xid_log_event');
425 include/sync_slave_io_with_master.inc
426 # Adding debug point 'stop_io_after_reading_xid_log_event' to @@GLOBAL.debug
427 [connection master]
428 BEGIN;
429 INSERT INTO t2 VALUES (100 * 4 + 1);
430 SET @val= 100 * 4 + 2;
431 INSERT INTO t2 VALUES (@val);
432 COMMIT;
433 [connection slave]
434 include/wait_for_slave_io_to_stop.inc
435 # Removing debug point 'stop_io_after_reading_xid_log_event' from @@GLOBAL.debug
436 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
437 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
438 [connection master]
439 INSERT INTO t2 VALUES (100 * 4 + 3);
440 [connection slave]
441 include/start_slave_io.inc
442 [connection master]
443 include/sync_slave_io_with_master.inc
444 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
445 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
446 [connection master]
447 DROP TABLE t1,t2;
448 ## Starting and syncing the SQL thread before next round
449 [connection slave]
450 include/start_slave_sql.inc
451 [connection master]
452 include/sync_slave_sql_with_master.inc
453 ## Running the test with the SQL thread started
454 [connection slave]
455 [connection master]
456 [connection slave]
457 include/gtid_step_reset.inc
458 [connection master]
459 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=INNODB;
460 CREATE TABLE t2 (i INT) ENGINE=INNODB;
461 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
462 BEGIN;
463 INSERT INTO t2 (i) VALUES (-6);
464 INSERT INTO t2 (i) VALUES (-5);
465 INSERT INTO t2 (i) VALUES (-4);
466 COMMIT;
467 [connection master]
468 include/sync_slave_sql_with_master.inc
469 include/diff_tables.inc [master:t1, slave:t1]
470 [connection slave]
471 include/stop_slave_io.inc
472 include/start_slave_io.inc
473 [connection slave]
474 include/gtid_step_assert.inc [count=4, only_count=0]
475 [connection master]
476 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
477 BEGIN;
478 INSERT INTO t2 (i) VALUES (-3);
479 INSERT INTO t2 (i) VALUES (-2);
480 COMMIT;
481 FLUSH LOGS;
482 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
483 BEGIN;
484 INSERT INTO t2 (i) VALUES (-1);
485 INSERT INTO t2 (i) VALUES (0);
486 COMMIT;
487 [connection master]
488 include/sync_slave_sql_with_master.inc
489 include/diff_tables.inc [master:t1, slave:t1]
490 [connection slave]
491 include/stop_slave_io.inc
492 include/start_slave_io.inc
493 [connection slave]
494 include/gtid_step_assert.inc [count=4, only_count=0]
495 [connection slave]
496 [connection master]
497 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
498 include/sync_slave_io_with_master.inc
499 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
500 [connection master]
501 BEGIN;
502 INSERT INTO t2 VALUES (100 * 1 + 1);
503 SET @val= 100 * 1 + 2;
504 INSERT INTO t2 VALUES (@val);
505 COMMIT;
506 [connection slave]
507 include/wait_for_slave_io_to_stop.inc
508 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
509 include/sync_slave_sql_with_io.inc
510 include/gtid_step_assert.inc [count=1, only_count=0]
511 [connection master]
512 INSERT INTO t2 VALUES (100 * 1 + 3);
513 [connection slave]
514 include/start_slave_io.inc
515 [connection master]
516 include/sync_slave_sql_with_master.inc
517 include/gtid_step_assert.inc [count=2, only_count=0]
518 [connection slave]
519 [connection master]
520 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
521 include/sync_slave_io_with_master.inc
522 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
523 [connection master]
524 BEGIN;
525 INSERT INTO t2 VALUES (100 * 2 + 1);
526 SET @val= 100 * 2 + 2;
527 INSERT INTO t2 VALUES (@val);
528 COMMIT;
529 [connection slave]
530 include/wait_for_slave_io_to_stop.inc
531 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
532 include/sync_slave_sql_with_io.inc
533 include/gtid_step_assert.inc [count=1, only_count=0]
534 [connection master]
535 INSERT INTO t2 VALUES (100 * 2 + 3);
536 [connection slave]
537 include/start_slave_io.inc
538 [connection master]
539 include/sync_slave_sql_with_master.inc
540 include/gtid_step_assert.inc [count=2, only_count=0]
541 [connection slave]
542 [connection master]
543 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_user_var_log_event');
544 include/sync_slave_io_with_master.inc
545 # Adding debug point 'stop_io_after_reading_user_var_log_event' to @@GLOBAL.debug
546 [connection master]
547 BEGIN;
548 INSERT INTO t2 VALUES (100 * 3 + 1);
549 SET @val= 100 * 3 + 2;
550 INSERT INTO t2 VALUES (@val);
551 COMMIT;
552 [connection slave]
553 include/wait_for_slave_io_to_stop.inc
554 # Removing debug point 'stop_io_after_reading_user_var_log_event' from @@GLOBAL.debug
555 include/sync_slave_sql_with_io.inc
556 include/gtid_step_assert.inc [count=1, only_count=0]
557 [connection master]
558 INSERT INTO t2 VALUES (100 * 3 + 3);
559 [connection slave]
560 include/start_slave_io.inc
561 [connection master]
562 include/sync_slave_sql_with_master.inc
563 include/gtid_step_assert.inc [count=2, only_count=0]
564 [connection slave]
565 [connection master]
566 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_xid_log_event');
567 include/sync_slave_io_with_master.inc
568 # Adding debug point 'stop_io_after_reading_xid_log_event' to @@GLOBAL.debug
569 [connection master]
570 BEGIN;
571 INSERT INTO t2 VALUES (100 * 4 + 1);
572 SET @val= 100 * 4 + 2;
573 INSERT INTO t2 VALUES (@val);
574 COMMIT;
575 [connection slave]
576 include/wait_for_slave_io_to_stop.inc
577 # Removing debug point 'stop_io_after_reading_xid_log_event' from @@GLOBAL.debug
578 include/sync_slave_sql_with_io.inc
579 include/gtid_step_assert.inc [count=2, only_count=0]
580 [connection master]
581 INSERT INTO t2 VALUES (100 * 4 + 3);
582 [connection slave]
583 include/start_slave_io.inc
584 [connection master]
585 include/sync_slave_sql_with_master.inc
586 include/gtid_step_assert.inc [count=1, only_count=0]
587 [connection master]
588 include/sync_slave_sql_with_master.inc
589 include/diff_tables.inc [master:t1, slave:t1]
590 [connection master]
591 DROP TABLE t1,t2;
592 include/sync_slave_sql_with_master.inc
593 [connection slave]
594 include/stop_slave.inc
595 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
596 include/start_slave.inc
597 include/rpl_end.inc