Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_trx_boundary_parser_row_myisam.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 MyISAM 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=MYISAM;
16 CREATE TABLE t2 (i INT) ENGINE=MYISAM;
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=6, 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=6, 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=3, 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=3, 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=3, only_count=0]
122 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
123 [connection master]
124 DROP TABLE t1,t2;
125 ## Starting and syncing the SQL thread before next round
126 [connection slave]
127 include/start_slave_sql.inc
128 [connection master]
129 include/sync_slave_sql_with_master.inc
130 ## Running the test with the SQL thread started
131 [connection slave]
132 [connection master]
133 [connection slave]
134 include/gtid_step_reset.inc
135 [connection master]
136 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM;
137 CREATE TABLE t2 (i INT) ENGINE=MYISAM;
138 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
139 BEGIN;
140 INSERT INTO t2 (i) VALUES (-6);
141 INSERT INTO t2 (i) VALUES (-5);
142 INSERT INTO t2 (i) VALUES (-4);
143 COMMIT;
144 [connection master]
145 include/sync_slave_sql_with_master.inc
146 include/diff_tables.inc [master:t1, slave:t1]
147 [connection slave]
148 include/stop_slave_io.inc
149 include/start_slave_io.inc
150 [connection slave]
151 include/gtid_step_assert.inc [count=6, only_count=0]
152 [connection master]
153 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
154 BEGIN;
155 INSERT INTO t2 (i) VALUES (-3);
156 INSERT INTO t2 (i) VALUES (-2);
157 COMMIT;
158 FLUSH LOGS;
159 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
160 BEGIN;
161 INSERT INTO t2 (i) VALUES (-1);
162 INSERT INTO t2 (i) VALUES (0);
163 COMMIT;
164 [connection master]
165 include/sync_slave_sql_with_master.inc
166 include/diff_tables.inc [master:t1, slave:t1]
167 [connection slave]
168 include/stop_slave_io.inc
169 include/start_slave_io.inc
170 [connection slave]
171 include/gtid_step_assert.inc [count=6, only_count=0]
172 [connection slave]
173 [connection master]
174 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
175 include/sync_slave_io_with_master.inc
176 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
177 [connection master]
178 BEGIN;
179 INSERT INTO t2 VALUES (100 * 1 + 1);
180 SET @val= 100 * 1 + 2;
181 INSERT INTO t2 VALUES (@val);
182 COMMIT;
183 [connection slave]
184 include/wait_for_slave_io_to_stop.inc
185 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
186 include/sync_slave_sql_with_io.inc
187 include/gtid_step_assert.inc [count=1, only_count=0]
188 [connection master]
189 INSERT INTO t2 VALUES (100 * 1 + 3);
190 [connection slave]
191 include/start_slave_io.inc
192 [connection master]
193 include/sync_slave_sql_with_master.inc
194 include/gtid_step_assert.inc [count=3, only_count=0]
195 [connection slave]
196 [connection master]
197 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
198 include/sync_slave_io_with_master.inc
199 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
200 [connection master]
201 BEGIN;
202 INSERT INTO t2 VALUES (100 * 2 + 1);
203 SET @val= 100 * 2 + 2;
204 INSERT INTO t2 VALUES (@val);
205 COMMIT;
206 [connection slave]
207 include/wait_for_slave_io_to_stop.inc
208 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
209 include/sync_slave_sql_with_io.inc
210 include/gtid_step_assert.inc [count=1, only_count=0]
211 [connection master]
212 INSERT INTO t2 VALUES (100 * 2 + 3);
213 [connection slave]
214 include/start_slave_io.inc
215 [connection master]
216 include/sync_slave_sql_with_master.inc
217 include/gtid_step_assert.inc [count=3, only_count=0]
218 [connection slave]
219 [connection master]
220 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event');
221 include/sync_slave_io_with_master.inc
222 # Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug
223 [connection master]
224 BEGIN;
225 INSERT INTO t2 VALUES (100 * 3 + 1);
226 SET @val= 100 * 3 + 2;
227 INSERT INTO t2 VALUES (@val);
228 COMMIT;
229 [connection slave]
230 include/wait_for_slave_io_to_stop.inc
231 # Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug
232 include/sync_slave_sql_with_io.inc
233 include/gtid_step_assert.inc [count=1, only_count=0]
234 [connection master]
235 INSERT INTO t2 VALUES (100 * 3 + 3);
236 [connection slave]
237 include/start_slave_io.inc
238 [connection master]
239 include/sync_slave_sql_with_master.inc
240 include/gtid_step_assert.inc [count=3, only_count=0]
241 [connection master]
242 include/sync_slave_sql_with_master.inc
243 include/diff_tables.inc [master:t1, slave:t1]
244 [connection master]
245 DROP TABLE t1,t2;
246 include/sync_slave_sql_with_master.inc
247 [connection slave]
248 include/stop_slave.inc
249 RESET MASTER;
250 RESET SLAVE;
251 Warnings:
252 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
253 [connection master]
254 RESET MASTER;
255 [connection slave]
256 include/stop_slave.inc
257 Warnings:
258 Note 3084 Replication thread(s) for channel '' are already stopped.
259 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
260 include/start_slave.inc
261 # Using MyISAM storage engine without auto positioning
262 ## Running the test with the SQL thread stopped
263 [connection slave]
264 include/stop_slave_sql.inc
265 [connection slave]
266 [connection master]
267 [connection slave]
268 include/gtid_step_reset_on_retrieved.inc
269 [connection master]
270 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM;
271 CREATE TABLE t2 (i INT) ENGINE=MYISAM;
272 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
273 BEGIN;
274 INSERT INTO t2 (i) VALUES (-6);
275 INSERT INTO t2 (i) VALUES (-5);
276 INSERT INTO t2 (i) VALUES (-4);
277 COMMIT;
278 [connection master]
279 include/sync_slave_io_with_master.inc
280 [connection slave]
281 include/stop_slave_io.inc
282 include/start_slave_io.inc
283 [connection slave]
284 include/gtid_step_assert_on_retrieved.inc [count=6, only_count=0]
285 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
286 [connection master]
287 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
288 BEGIN;
289 INSERT INTO t2 (i) VALUES (-3);
290 INSERT INTO t2 (i) VALUES (-2);
291 COMMIT;
292 FLUSH LOGS;
293 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
294 BEGIN;
295 INSERT INTO t2 (i) VALUES (-1);
296 INSERT INTO t2 (i) VALUES (0);
297 COMMIT;
298 [connection master]
299 include/sync_slave_io_with_master.inc
300 [connection slave]
301 include/stop_slave_io.inc
302 include/start_slave_io.inc
303 [connection slave]
304 include/gtid_step_assert_on_retrieved.inc [count=6, only_count=0]
305 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
306 [connection slave]
307 [connection master]
308 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
309 include/sync_slave_io_with_master.inc
310 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
311 [connection master]
312 BEGIN;
313 INSERT INTO t2 VALUES (100 * 1 + 1);
314 SET @val= 100 * 1 + 2;
315 INSERT INTO t2 VALUES (@val);
316 COMMIT;
317 [connection slave]
318 include/wait_for_slave_io_to_stop.inc
319 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
320 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
321 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
322 [connection master]
323 INSERT INTO t2 VALUES (100 * 1 + 3);
324 [connection slave]
325 include/start_slave_io.inc
326 [connection master]
327 include/sync_slave_io_with_master.inc
328 include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0]
329 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
330 [connection slave]
331 [connection master]
332 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
333 include/sync_slave_io_with_master.inc
334 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
335 [connection master]
336 BEGIN;
337 INSERT INTO t2 VALUES (100 * 2 + 1);
338 SET @val= 100 * 2 + 2;
339 INSERT INTO t2 VALUES (@val);
340 COMMIT;
341 [connection slave]
342 include/wait_for_slave_io_to_stop.inc
343 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
344 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
345 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
346 [connection master]
347 INSERT INTO t2 VALUES (100 * 2 + 3);
348 [connection slave]
349 include/start_slave_io.inc
350 [connection master]
351 include/sync_slave_io_with_master.inc
352 include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0]
353 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
354 [connection slave]
355 [connection master]
356 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event');
357 include/sync_slave_io_with_master.inc
358 # Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug
359 [connection master]
360 BEGIN;
361 INSERT INTO t2 VALUES (100 * 3 + 1);
362 SET @val= 100 * 3 + 2;
363 INSERT INTO t2 VALUES (@val);
364 COMMIT;
365 [connection slave]
366 include/wait_for_slave_io_to_stop.inc
367 # Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug
368 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
369 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
370 [connection master]
371 INSERT INTO t2 VALUES (100 * 3 + 3);
372 [connection slave]
373 include/start_slave_io.inc
374 [connection master]
375 include/sync_slave_io_with_master.inc
376 include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0]
377 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
378 [connection master]
379 DROP TABLE t1,t2;
380 ## Starting and syncing the SQL thread before next round
381 [connection slave]
382 include/start_slave_sql.inc
383 [connection master]
384 include/sync_slave_sql_with_master.inc
385 ## Running the test with the SQL thread started
386 [connection slave]
387 [connection master]
388 [connection slave]
389 include/gtid_step_reset.inc
390 [connection master]
391 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM;
392 CREATE TABLE t2 (i INT) ENGINE=MYISAM;
393 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
394 BEGIN;
395 INSERT INTO t2 (i) VALUES (-6);
396 INSERT INTO t2 (i) VALUES (-5);
397 INSERT INTO t2 (i) VALUES (-4);
398 COMMIT;
399 [connection master]
400 include/sync_slave_sql_with_master.inc
401 include/diff_tables.inc [master:t1, slave:t1]
402 [connection slave]
403 include/stop_slave_io.inc
404 include/start_slave_io.inc
405 [connection slave]
406 include/gtid_step_assert.inc [count=6, only_count=0]
407 [connection master]
408 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
409 BEGIN;
410 INSERT INTO t2 (i) VALUES (-3);
411 INSERT INTO t2 (i) VALUES (-2);
412 COMMIT;
413 FLUSH LOGS;
414 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
415 BEGIN;
416 INSERT INTO t2 (i) VALUES (-1);
417 INSERT INTO t2 (i) VALUES (0);
418 COMMIT;
419 [connection master]
420 include/sync_slave_sql_with_master.inc
421 include/diff_tables.inc [master:t1, slave:t1]
422 [connection slave]
423 include/stop_slave_io.inc
424 include/start_slave_io.inc
425 [connection slave]
426 include/gtid_step_assert.inc [count=6, only_count=0]
427 [connection slave]
428 [connection master]
429 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
430 include/sync_slave_io_with_master.inc
431 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
432 [connection master]
433 BEGIN;
434 INSERT INTO t2 VALUES (100 * 1 + 1);
435 SET @val= 100 * 1 + 2;
436 INSERT INTO t2 VALUES (@val);
437 COMMIT;
438 [connection slave]
439 include/wait_for_slave_io_to_stop.inc
440 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
441 include/sync_slave_sql_with_io.inc
442 include/gtid_step_assert.inc [count=1, only_count=0]
443 [connection master]
444 INSERT INTO t2 VALUES (100 * 1 + 3);
445 [connection slave]
446 include/start_slave_io.inc
447 [connection master]
448 include/sync_slave_sql_with_master.inc
449 include/gtid_step_assert.inc [count=3, only_count=0]
450 [connection slave]
451 [connection master]
452 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
453 include/sync_slave_io_with_master.inc
454 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
455 [connection master]
456 BEGIN;
457 INSERT INTO t2 VALUES (100 * 2 + 1);
458 SET @val= 100 * 2 + 2;
459 INSERT INTO t2 VALUES (@val);
460 COMMIT;
461 [connection slave]
462 include/wait_for_slave_io_to_stop.inc
463 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
464 include/sync_slave_sql_with_io.inc
465 include/gtid_step_assert.inc [count=1, only_count=0]
466 [connection master]
467 INSERT INTO t2 VALUES (100 * 2 + 3);
468 [connection slave]
469 include/start_slave_io.inc
470 [connection master]
471 include/sync_slave_sql_with_master.inc
472 include/gtid_step_assert.inc [count=3, only_count=0]
473 [connection slave]
474 [connection master]
475 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event');
476 include/sync_slave_io_with_master.inc
477 # Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug
478 [connection master]
479 BEGIN;
480 INSERT INTO t2 VALUES (100 * 3 + 1);
481 SET @val= 100 * 3 + 2;
482 INSERT INTO t2 VALUES (@val);
483 COMMIT;
484 [connection slave]
485 include/wait_for_slave_io_to_stop.inc
486 # Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug
487 include/sync_slave_sql_with_io.inc
488 include/gtid_step_assert.inc [count=1, only_count=0]
489 [connection master]
490 INSERT INTO t2 VALUES (100 * 3 + 3);
491 [connection slave]
492 include/start_slave_io.inc
493 [connection master]
494 include/sync_slave_sql_with_master.inc
495 include/gtid_step_assert.inc [count=3, only_count=0]
496 [connection master]
497 include/sync_slave_sql_with_master.inc
498 include/diff_tables.inc [master:t1, slave:t1]
499 [connection master]
500 DROP TABLE t1,t2;
501 include/sync_slave_sql_with_master.inc
502 [connection slave]
503 include/stop_slave.inc
504 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
505 include/start_slave.inc
506 include/rpl_end.inc