Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_trx_boundary_parser_stmt_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_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=2, 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 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_user_var_log_event');
221 include/sync_slave_io_with_master.inc
222 # Adding debug point 'stop_io_after_reading_user_var_log_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_user_var_log_event' from @@GLOBAL.debug
232 include/sync_slave_sql_with_io.inc
233 include/gtid_step_assert.inc [count=2, 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=2, 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 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
257 include/start_slave.inc
258 # Using MyISAM storage engine without auto positioning
259 ## Running the test with the SQL thread stopped
260 [connection slave]
261 include/stop_slave_sql.inc
262 [connection slave]
263 [connection master]
264 [connection slave]
265 include/gtid_step_reset_on_retrieved.inc
266 [connection master]
267 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM;
268 CREATE TABLE t2 (i INT) ENGINE=MYISAM;
269 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
270 BEGIN;
271 INSERT INTO t2 (i) VALUES (-6);
272 INSERT INTO t2 (i) VALUES (-5);
273 INSERT INTO t2 (i) VALUES (-4);
274 COMMIT;
275 [connection master]
276 include/sync_slave_io_with_master.inc
277 [connection slave]
278 include/stop_slave_io.inc
279 include/start_slave_io.inc
280 [connection slave]
281 include/gtid_step_assert_on_retrieved.inc [count=6, only_count=0]
282 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
283 [connection master]
284 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
285 BEGIN;
286 INSERT INTO t2 (i) VALUES (-3);
287 INSERT INTO t2 (i) VALUES (-2);
288 COMMIT;
289 FLUSH LOGS;
290 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
291 BEGIN;
292 INSERT INTO t2 (i) VALUES (-1);
293 INSERT INTO t2 (i) VALUES (0);
294 COMMIT;
295 [connection master]
296 include/sync_slave_io_with_master.inc
297 [connection slave]
298 include/stop_slave_io.inc
299 include/start_slave_io.inc
300 [connection slave]
301 include/gtid_step_assert_on_retrieved.inc [count=6, only_count=0]
302 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
303 [connection slave]
304 [connection master]
305 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
306 include/sync_slave_io_with_master.inc
307 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
308 [connection master]
309 BEGIN;
310 INSERT INTO t2 VALUES (100 * 1 + 1);
311 SET @val= 100 * 1 + 2;
312 INSERT INTO t2 VALUES (@val);
313 COMMIT;
314 [connection slave]
315 include/wait_for_slave_io_to_stop.inc
316 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
317 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
318 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
319 [connection master]
320 INSERT INTO t2 VALUES (100 * 1 + 3);
321 [connection slave]
322 include/start_slave_io.inc
323 [connection master]
324 include/sync_slave_io_with_master.inc
325 include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0]
326 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
327 [connection slave]
328 [connection master]
329 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
330 include/sync_slave_io_with_master.inc
331 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
332 [connection master]
333 BEGIN;
334 INSERT INTO t2 VALUES (100 * 2 + 1);
335 SET @val= 100 * 2 + 2;
336 INSERT INTO t2 VALUES (@val);
337 COMMIT;
338 [connection slave]
339 include/wait_for_slave_io_to_stop.inc
340 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
341 include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0]
342 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
343 [connection master]
344 INSERT INTO t2 VALUES (100 * 2 + 3);
345 [connection slave]
346 include/start_slave_io.inc
347 [connection master]
348 include/sync_slave_io_with_master.inc
349 include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0]
350 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
351 [connection slave]
352 [connection master]
353 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_user_var_log_event');
354 include/sync_slave_io_with_master.inc
355 # Adding debug point 'stop_io_after_reading_user_var_log_event' to @@GLOBAL.debug
356 [connection master]
357 BEGIN;
358 INSERT INTO t2 VALUES (100 * 3 + 1);
359 SET @val= 100 * 3 + 2;
360 INSERT INTO t2 VALUES (@val);
361 COMMIT;
362 [connection slave]
363 include/wait_for_slave_io_to_stop.inc
364 # Removing debug point 'stop_io_after_reading_user_var_log_event' from @@GLOBAL.debug
365 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
366 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
367 [connection master]
368 INSERT INTO t2 VALUES (100 * 3 + 3);
369 [connection slave]
370 include/start_slave_io.inc
371 [connection master]
372 include/sync_slave_io_with_master.inc
373 include/gtid_step_assert_on_retrieved.inc [count=2, only_count=0]
374 Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set)
375 [connection master]
376 DROP TABLE t1,t2;
377 ## Starting and syncing the SQL thread before next round
378 [connection slave]
379 include/start_slave_sql.inc
380 [connection master]
381 include/sync_slave_sql_with_master.inc
382 ## Running the test with the SQL thread started
383 [connection slave]
384 [connection master]
385 [connection slave]
386 include/gtid_step_reset.inc
387 [connection master]
388 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM;
389 CREATE TABLE t2 (i INT) ENGINE=MYISAM;
390 INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log');
391 BEGIN;
392 INSERT INTO t2 (i) VALUES (-6);
393 INSERT INTO t2 (i) VALUES (-5);
394 INSERT INTO t2 (i) VALUES (-4);
395 COMMIT;
396 [connection master]
397 include/sync_slave_sql_with_master.inc
398 include/diff_tables.inc [master:t1, slave:t1]
399 [connection slave]
400 include/stop_slave_io.inc
401 include/start_slave_io.inc
402 [connection slave]
403 include/gtid_step_assert.inc [count=6, only_count=0]
404 [connection master]
405 INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions');
406 BEGIN;
407 INSERT INTO t2 (i) VALUES (-3);
408 INSERT INTO t2 (i) VALUES (-2);
409 COMMIT;
410 FLUSH LOGS;
411 INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master');
412 BEGIN;
413 INSERT INTO t2 (i) VALUES (-1);
414 INSERT INTO t2 (i) VALUES (0);
415 COMMIT;
416 [connection master]
417 include/sync_slave_sql_with_master.inc
418 include/diff_tables.inc [master:t1, slave:t1]
419 [connection slave]
420 include/stop_slave_io.inc
421 include/start_slave_io.inc
422 [connection slave]
423 include/gtid_step_assert.inc [count=6, only_count=0]
424 [connection slave]
425 [connection master]
426 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event');
427 include/sync_slave_io_with_master.inc
428 # Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug
429 [connection master]
430 BEGIN;
431 INSERT INTO t2 VALUES (100 * 1 + 1);
432 SET @val= 100 * 1 + 2;
433 INSERT INTO t2 VALUES (@val);
434 COMMIT;
435 [connection slave]
436 include/wait_for_slave_io_to_stop.inc
437 # Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug
438 include/sync_slave_sql_with_io.inc
439 include/gtid_step_assert.inc [count=1, only_count=0]
440 [connection master]
441 INSERT INTO t2 VALUES (100 * 1 + 3);
442 [connection slave]
443 include/start_slave_io.inc
444 [connection master]
445 include/sync_slave_sql_with_master.inc
446 include/gtid_step_assert.inc [count=3, only_count=0]
447 [connection slave]
448 [connection master]
449 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event');
450 include/sync_slave_io_with_master.inc
451 # Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug
452 [connection master]
453 BEGIN;
454 INSERT INTO t2 VALUES (100 * 2 + 1);
455 SET @val= 100 * 2 + 2;
456 INSERT INTO t2 VALUES (@val);
457 COMMIT;
458 [connection slave]
459 include/wait_for_slave_io_to_stop.inc
460 # Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug
461 include/sync_slave_sql_with_io.inc
462 include/gtid_step_assert.inc [count=1, only_count=0]
463 [connection master]
464 INSERT INTO t2 VALUES (100 * 2 + 3);
465 [connection slave]
466 include/start_slave_io.inc
467 [connection master]
468 include/sync_slave_sql_with_master.inc
469 include/gtid_step_assert.inc [count=3, only_count=0]
470 [connection slave]
471 [connection master]
472 INSERT INTO t1 (info) VALUES ('stop_io_after_reading_user_var_log_event');
473 include/sync_slave_io_with_master.inc
474 # Adding debug point 'stop_io_after_reading_user_var_log_event' to @@GLOBAL.debug
475 [connection master]
476 BEGIN;
477 INSERT INTO t2 VALUES (100 * 3 + 1);
478 SET @val= 100 * 3 + 2;
479 INSERT INTO t2 VALUES (@val);
480 COMMIT;
481 [connection slave]
482 include/wait_for_slave_io_to_stop.inc
483 # Removing debug point 'stop_io_after_reading_user_var_log_event' from @@GLOBAL.debug
484 include/sync_slave_sql_with_io.inc
485 include/gtid_step_assert.inc [count=2, only_count=0]
486 [connection master]
487 INSERT INTO t2 VALUES (100 * 3 + 3);
488 [connection slave]
489 include/start_slave_io.inc
490 [connection master]
491 include/sync_slave_sql_with_master.inc
492 include/gtid_step_assert.inc [count=2, only_count=0]
493 [connection master]
494 include/sync_slave_sql_with_master.inc
495 include/diff_tables.inc [master:t1, slave:t1]
496 [connection master]
497 DROP TABLE t1,t2;
498 include/sync_slave_sql_with_master.inc
499 [connection slave]
500 include/stop_slave.inc
501 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
502 include/start_slave.inc
503 include/rpl_end.inc