Debian Codegraph @

mysql-test/suite/binlog/r/binlog_xa_prepared_disconnect.result

raw
1 connection default;
2 RESET MASTER;
3 CREATE VIEW v_processlist as SELECT * FROM performance_schema.threads where type = 'FOREGROUND';
4 call mtr.add_suppression("Found 10 prepared XA transactions");
5 CREATE TABLE t (a INT) ENGINE=innodb;
6 INSERT INTO t VALUES(100);
7 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
8 SET @@sql_log_bin = OFF;
9 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
10 XA START 'trx1tmp';
11 INSERT INTO tmp1 SET a=1;
12 XA END 'trx1tmp';
13 XA PREPARE 'trx1tmp';
14 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
15 SET @@sql_log_bin = OFF;
16 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
17 XA START 'trx2tmp';
18 INSERT INTO tmp1 SET a=1;
19 XA END 'trx2tmp';
20 XA PREPARE 'trx2tmp';
21 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
22 SET @@sql_log_bin = OFF;
23 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
24 XA START 'trx3tmp';
25 INSERT INTO tmp1 SET a=1;
26 XA END 'trx3tmp';
27 XA PREPARE 'trx3tmp';
28 connection default;
29 XA COMMIT 'trx1tmp';
30 ERROR XAE04: XAER_NOTA: Unknown XID
31 XA ROLLBACK 'trx1tmp';
32 ERROR XAE04: XAER_NOTA: Unknown XID
33 XA START 'trx1tmp';
34 ERROR XAE08: XAER_DUPID: The XID already exists
35 connection default;
36 *** 3 prepared transactions must be in the list ***
37 XA RECOVER;
38 formatID gtrid_length bqual_length data
39 1 LEN1 LEN2 TRX_N
40 1 LEN1 LEN2 TRX_N
41 1 LEN1 LEN2 TRX_N
42 connection conn1tmp;
43 disconnect conn1tmp;
44 connection default;
45 XA COMMIT 'trx1tmp';
46 KILL connection CONN_ID;
47 XA COMMIT 'trx3tmp';
48 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
49 XA START 'trx1ro';
50 SELECT * from t ORDER BY a;
51 a
52 100
53 XA END 'trx1ro';
54 XA PREPARE 'trx1ro';
55 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
56 XA START 'trx2ro';
57 SELECT * from t ORDER BY a;
58 a
59 100
60 XA END 'trx2ro';
61 XA PREPARE 'trx2ro';
62 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
63 XA START 'trx3ro';
64 SELECT * from t ORDER BY a;
65 a
66 100
67 XA END 'trx3ro';
68 XA PREPARE 'trx3ro';
69 connection default;
70 *** 4 prepared transactions must be in the list ***
71 XA RECOVER;
72 formatID gtrid_length bqual_length data
73 1 LEN1 LEN2 TRX_N
74 1 LEN1 LEN2 TRX_N
75 1 LEN1 LEN2 TRX_N
76 1 LEN1 LEN2 TRX_N
77 connection conn1ro;
78 disconnect conn1ro;
79 connection default;
80 XA ROLLBACK 'trx1ro';
81 KILL connection CONN_ID;
82 XA ROLLBACK 'trx3ro';
83 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
84 XA START 'trx1empty';
85 XA END 'trx1empty';
86 XA PREPARE 'trx1empty';
87 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
88 XA START 'trx2empty';
89 XA END 'trx2empty';
90 XA PREPARE 'trx2empty';
91 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
92 XA START 'trx3empty';
93 XA END 'trx3empty';
94 XA PREPARE 'trx3empty';
95 connection default;
96 *** 5 prepared transactions must be in the list ***
97 XA RECOVER;
98 formatID gtrid_length bqual_length data
99 1 LEN1 LEN2 TRX_N
100 1 LEN1 LEN2 TRX_N
101 1 LEN1 LEN2 TRX_N
102 1 LEN1 LEN2 TRX_N
103 1 LEN1 LEN2 TRX_N
104 connection conn1empty;
105 disconnect conn1empty;
106 connection default;
107 XA COMMIT 'trx1empty';
108 KILL connection CONN_ID;
109 XA COMMIT 'trx3empty';
110 connect conn1$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
111 XA START 'trx1unprepared';
112 INSERT INTO t set a=0;
113 XA END 'trx1unprepared';
114 INSERT INTO t set a=0;
115 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
116 XA START 'trx1unprepared';
117 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
118 XA START 'trx1unprepared';
119 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
120 disconnect conn1unprepared;
121 connection default;
122 XA COMMIT 'trx1unprepared';
123 ERROR XAE04: XAER_NOTA: Unknown XID
124 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
125 SET @@binlog_format = STATEMENT;
126 XA START 'trx_0';
127 INSERT INTO t SET a=0;
128 XA END 'trx_0';
129 XA PREPARE 'trx_0';
130 disconnect conn0;
131 connection default;
132 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
133 SET @@binlog_format = STATEMENT;
134 SET @@binlog_format = ROW;
135 XA START 'trx_1';
136 INSERT INTO t SET a=1;
137 XA END 'trx_1';
138 XA PREPARE 'trx_1';
139 disconnect conn1;
140 connection default;
141 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
142 SET @@binlog_format = STATEMENT;
143 XA START 'trx_2';
144 INSERT INTO t SET a=2;
145 XA END 'trx_2';
146 XA PREPARE 'trx_2';
147 disconnect conn2;
148 connection default;
149 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
150 SET @@binlog_format = STATEMENT;
151 SET @@binlog_format = ROW;
152 XA START 'trx_3';
153 INSERT INTO t SET a=3;
154 XA END 'trx_3';
155 XA PREPARE 'trx_3';
156 disconnect conn3;
157 connection default;
158 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
159 SET @@binlog_format = STATEMENT;
160 XA START 'trx_4';
161 INSERT INTO t SET a=4;
162 XA END 'trx_4';
163 XA PREPARE 'trx_4';
164 disconnect conn4;
165 connection default;
166 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
167 SET @@binlog_format = STATEMENT;
168 SET @@binlog_format = ROW;
169 XA START 'trx_5';
170 INSERT INTO t SET a=5;
171 XA END 'trx_5';
172 XA PREPARE 'trx_5';
173 disconnect conn5;
174 connection default;
175 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
176 SET @@binlog_format = STATEMENT;
177 XA START 'trx_6';
178 INSERT INTO t SET a=6;
179 XA END 'trx_6';
180 XA PREPARE 'trx_6';
181 disconnect conn6;
182 connection default;
183 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
184 SET @@binlog_format = STATEMENT;
185 SET @@binlog_format = ROW;
186 XA START 'trx_7';
187 INSERT INTO t SET a=7;
188 XA END 'trx_7';
189 XA PREPARE 'trx_7';
190 disconnect conn7;
191 connection default;
192 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
193 SET @@binlog_format = STATEMENT;
194 XA START 'trx_8';
195 INSERT INTO t SET a=8;
196 XA END 'trx_8';
197 XA PREPARE 'trx_8';
198 disconnect conn8;
199 connection default;
200 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
201 SET @@binlog_format = STATEMENT;
202 SET @@binlog_format = ROW;
203 XA START 'trx_9';
204 INSERT INTO t SET a=9;
205 XA END 'trx_9';
206 XA PREPARE 'trx_9';
207 disconnect conn9;
208 connection default;
209 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
210 SET @@binlog_format = STATEMENT;
211 XA START 'trx_10';
212 INSERT INTO t SET a=10;
213 XA END 'trx_10';
214 XA PREPARE 'trx_10';
215 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
216 SET @@binlog_format = STATEMENT;
217 SET @@binlog_format = ROW;
218 XA START 'trx_11';
219 INSERT INTO t SET a=11;
220 XA END 'trx_11';
221 XA PREPARE 'trx_11';
222 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
223 SET @@binlog_format = STATEMENT;
224 XA START 'trx_12';
225 INSERT INTO t SET a=12;
226 XA END 'trx_12';
227 XA PREPARE 'trx_12';
228 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
229 SET @@binlog_format = STATEMENT;
230 SET @@binlog_format = ROW;
231 XA START 'trx_13';
232 INSERT INTO t SET a=13;
233 XA END 'trx_13';
234 XA PREPARE 'trx_13';
235 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
236 SET @@binlog_format = STATEMENT;
237 XA START 'trx_14';
238 INSERT INTO t SET a=14;
239 XA END 'trx_14';
240 XA PREPARE 'trx_14';
241 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
242 SET @@binlog_format = STATEMENT;
243 SET @@binlog_format = ROW;
244 XA START 'trx_15';
245 INSERT INTO t SET a=15;
246 XA END 'trx_15';
247 XA PREPARE 'trx_15';
248 connection default;
249 KILL CONNECTION CONN_ID;
250 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
251 SET @@binlog_format = STATEMENT;
252 XA START 'trx_16';
253 INSERT INTO t SET a=16;
254 XA END 'trx_16';
255 XA PREPARE 'trx_16';
256 connection default;
257 KILL CONNECTION CONN_ID;
258 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
259 SET @@binlog_format = STATEMENT;
260 SET @@binlog_format = ROW;
261 XA START 'trx_17';
262 INSERT INTO t SET a=17;
263 XA END 'trx_17';
264 XA PREPARE 'trx_17';
265 connection default;
266 KILL CONNECTION CONN_ID;
267 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
268 SET @@binlog_format = STATEMENT;
269 XA START 'trx_18';
270 INSERT INTO t SET a=18;
271 XA END 'trx_18';
272 XA PREPARE 'trx_18';
273 connection default;
274 KILL CONNECTION CONN_ID;
275 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
276 SET @@binlog_format = STATEMENT;
277 SET @@binlog_format = ROW;
278 XA START 'trx_19';
279 INSERT INTO t SET a=19;
280 XA END 'trx_19';
281 XA PREPARE 'trx_19';
282 connection default;
283 KILL CONNECTION CONN_ID;
284 connection default;
285 XA ROLLBACK 'trx_0';
286 XA ROLLBACK 'trx_1';
287 XA ROLLBACK 'trx_2';
288 XA ROLLBACK 'trx_3';
289 XA ROLLBACK 'trx_4';
290 XA COMMIT 'trx_5';
291 XA COMMIT 'trx_6';
292 XA COMMIT 'trx_7';
293 XA COMMIT 'trx_8';
294 XA COMMIT 'trx_9';
295 # restart
296 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
297 XA START 'new_trx_0';
298 INSERT INTO t SET a=0;
299 XA END 'new_trx_0';
300 XA PREPARE 'new_trx_0';
301 disconnect conn_restart_0;
302 connection default;
303 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
304 XA START 'new_trx_1';
305 INSERT INTO t SET a=1;
306 XA END 'new_trx_1';
307 XA PREPARE 'new_trx_1';
308 disconnect conn_restart_1;
309 connection default;
310 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
311 XA START 'new_trx_2';
312 INSERT INTO t SET a=2;
313 XA END 'new_trx_2';
314 XA PREPARE 'new_trx_2';
315 disconnect conn_restart_2;
316 connection default;
317 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
318 XA START 'new_trx_3';
319 INSERT INTO t SET a=3;
320 XA END 'new_trx_3';
321 XA PREPARE 'new_trx_3';
322 disconnect conn_restart_3;
323 connection default;
324 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
325 XA START 'new_trx_4';
326 INSERT INTO t SET a=4;
327 XA END 'new_trx_4';
328 XA PREPARE 'new_trx_4';
329 disconnect conn_restart_4;
330 connection default;
331 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
332 XA START 'new_trx_5';
333 INSERT INTO t SET a=5;
334 XA END 'new_trx_5';
335 XA PREPARE 'new_trx_5';
336 disconnect conn_restart_5;
337 connection default;
338 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
339 XA START 'new_trx_6';
340 INSERT INTO t SET a=6;
341 XA END 'new_trx_6';
342 XA PREPARE 'new_trx_6';
343 disconnect conn_restart_6;
344 connection default;
345 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
346 XA START 'new_trx_7';
347 INSERT INTO t SET a=7;
348 XA END 'new_trx_7';
349 XA PREPARE 'new_trx_7';
350 disconnect conn_restart_7;
351 connection default;
352 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
353 XA START 'new_trx_8';
354 INSERT INTO t SET a=8;
355 XA END 'new_trx_8';
356 XA PREPARE 'new_trx_8';
357 disconnect conn_restart_8;
358 connection default;
359 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
360 XA START 'new_trx_9';
361 INSERT INTO t SET a=9;
362 XA END 'new_trx_9';
363 XA PREPARE 'new_trx_9';
364 disconnect conn_restart_9;
365 connection default;
366 connection default;
367 XA COMMIT 'new_trx_0';
368 XA COMMIT 'new_trx_1';
369 XA COMMIT 'new_trx_2';
370 XA COMMIT 'new_trx_3';
371 XA COMMIT 'new_trx_4';
372 XA COMMIT 'new_trx_5';
373 XA COMMIT 'new_trx_6';
374 XA COMMIT 'new_trx_7';
375 XA COMMIT 'new_trx_8';
376 XA COMMIT 'new_trx_9';
377 XA START 'trx_10';
378 ERROR XAE08: XAER_DUPID: The XID already exists
379 XA COMMIT 'trx_10';
380 XA START 'trx_11';
381 ERROR XAE08: XAER_DUPID: The XID already exists
382 XA COMMIT 'trx_11';
383 XA START 'trx_12';
384 ERROR XAE08: XAER_DUPID: The XID already exists
385 XA COMMIT 'trx_12';
386 XA START 'trx_13';
387 ERROR XAE08: XAER_DUPID: The XID already exists
388 XA COMMIT 'trx_13';
389 XA START 'trx_14';
390 ERROR XAE08: XAER_DUPID: The XID already exists
391 XA COMMIT 'trx_14';
392 XA START 'trx_15';
393 ERROR XAE08: XAER_DUPID: The XID already exists
394 XA ROLLBACK 'trx_15';
395 XA START 'trx_16';
396 ERROR XAE08: XAER_DUPID: The XID already exists
397 XA ROLLBACK 'trx_16';
398 XA START 'trx_17';
399 ERROR XAE08: XAER_DUPID: The XID already exists
400 XA ROLLBACK 'trx_17';
401 XA START 'trx_18';
402 ERROR XAE08: XAER_DUPID: The XID already exists
403 XA ROLLBACK 'trx_18';
404 XA START 'trx_19';
405 ERROR XAE08: XAER_DUPID: The XID already exists
406 XA ROLLBACK 'trx_19';
407 SELECT * FROM t;
408 a
409 100
410 5
411 6
412 7
413 8
414 9
415 10
416 11
417 12
418 13
419 14
420 0
421 1
422 2
423 3
424 4
425 5
426 6
427 7
428 8
429 9
430 disconnect conn2tmp;
431 disconnect conn3tmp;
432 disconnect conn2ro;
433 disconnect conn3ro;
434 disconnect conn2empty;
435 disconnect conn3empty;
436 connection default;
437 XA ROLLBACK 'trx_20';
438 ERROR XAE04: XAER_NOTA: Unknown XID
439 disconnect conn19;
440 connection default;
441 XA ROLLBACK 'trx_19';
442 ERROR XAE04: XAER_NOTA: Unknown XID
443 disconnect conn18;
444 connection default;
445 XA ROLLBACK 'trx_18';
446 ERROR XAE04: XAER_NOTA: Unknown XID
447 disconnect conn17;
448 connection default;
449 XA ROLLBACK 'trx_17';
450 ERROR XAE04: XAER_NOTA: Unknown XID
451 disconnect conn16;
452 connection default;
453 XA ROLLBACK 'trx_16';
454 ERROR XAE04: XAER_NOTA: Unknown XID
455 disconnect conn15;
456 connection default;
457 XA ROLLBACK 'trx_15';
458 ERROR XAE04: XAER_NOTA: Unknown XID
459 disconnect conn14;
460 connection default;
461 XA ROLLBACK 'trx_14';
462 ERROR XAE04: XAER_NOTA: Unknown XID
463 disconnect conn13;
464 connection default;
465 XA ROLLBACK 'trx_13';
466 ERROR XAE04: XAER_NOTA: Unknown XID
467 disconnect conn12;
468 connection default;
469 XA ROLLBACK 'trx_12';
470 ERROR XAE04: XAER_NOTA: Unknown XID
471 disconnect conn11;
472 connection default;
473 XA ROLLBACK 'trx_11';
474 ERROR XAE04: XAER_NOTA: Unknown XID
475 disconnect conn10;
476 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
477 SET @@sql_log_bin = OFF;
478 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
479 XA START 'trx1tmp';
480 INSERT INTO tmp1 SET a=1;
481 XA END 'trx1tmp';
482 XA PREPARE 'trx1tmp';
483 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
484 SET @@sql_log_bin = OFF;
485 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
486 XA START 'trx2tmp';
487 INSERT INTO tmp1 SET a=1;
488 XA END 'trx2tmp';
489 XA PREPARE 'trx2tmp';
490 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
491 SET @@sql_log_bin = OFF;
492 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
493 XA START 'trx3tmp';
494 INSERT INTO tmp1 SET a=1;
495 XA END 'trx3tmp';
496 XA PREPARE 'trx3tmp';
497 connection default;
498 XA COMMIT 'trx1tmp';
499 ERROR XAE04: XAER_NOTA: Unknown XID
500 XA ROLLBACK 'trx1tmp';
501 ERROR XAE04: XAER_NOTA: Unknown XID
502 XA START 'trx1tmp';
503 ERROR XAE08: XAER_DUPID: The XID already exists
504 connection default;
505 *** 3 prepared transactions must be in the list ***
506 XA RECOVER;
507 formatID gtrid_length bqual_length data
508 1 LEN1 LEN2 TRX_N
509 1 LEN1 LEN2 TRX_N
510 1 LEN1 LEN2 TRX_N
511 connection conn1tmp;
512 disconnect conn1tmp;
513 connection default;
514 XA COMMIT 'trx1tmp';
515 KILL connection CONN_ID;
516 XA COMMIT 'trx3tmp';
517 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
518 XA START 'trx1ro';
519 SELECT * from t ORDER BY a;
520 a
521 0
522 1
523 2
524 3
525 4
526 5
527 5
528 6
529 6
530 7
531 7
532 8
533 8
534 9
535 9
536 10
537 11
538 12
539 13
540 14
541 100
542 XA END 'trx1ro';
543 XA PREPARE 'trx1ro';
544 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
545 XA START 'trx2ro';
546 SELECT * from t ORDER BY a;
547 a
548 0
549 1
550 2
551 3
552 4
553 5
554 5
555 6
556 6
557 7
558 7
559 8
560 8
561 9
562 9
563 10
564 11
565 12
566 13
567 14
568 100
569 XA END 'trx2ro';
570 XA PREPARE 'trx2ro';
571 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
572 XA START 'trx3ro';
573 SELECT * from t ORDER BY a;
574 a
575 0
576 1
577 2
578 3
579 4
580 5
581 5
582 6
583 6
584 7
585 7
586 8
587 8
588 9
589 9
590 10
591 11
592 12
593 13
594 14
595 100
596 XA END 'trx3ro';
597 XA PREPARE 'trx3ro';
598 connection default;
599 *** 4 prepared transactions must be in the list ***
600 XA RECOVER;
601 formatID gtrid_length bqual_length data
602 1 LEN1 LEN2 TRX_N
603 1 LEN1 LEN2 TRX_N
604 1 LEN1 LEN2 TRX_N
605 1 LEN1 LEN2 TRX_N
606 connection conn1ro;
607 disconnect conn1ro;
608 connection default;
609 XA ROLLBACK 'trx1ro';
610 KILL connection CONN_ID;
611 XA ROLLBACK 'trx3ro';
612 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
613 XA START 'trx1empty';
614 XA END 'trx1empty';
615 XA PREPARE 'trx1empty';
616 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
617 XA START 'trx2empty';
618 XA END 'trx2empty';
619 XA PREPARE 'trx2empty';
620 connect conn$index$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
621 XA START 'trx3empty';
622 XA END 'trx3empty';
623 XA PREPARE 'trx3empty';
624 connection default;
625 *** 5 prepared transactions must be in the list ***
626 XA RECOVER;
627 formatID gtrid_length bqual_length data
628 1 LEN1 LEN2 TRX_N
629 1 LEN1 LEN2 TRX_N
630 1 LEN1 LEN2 TRX_N
631 1 LEN1 LEN2 TRX_N
632 1 LEN1 LEN2 TRX_N
633 connection conn1empty;
634 disconnect conn1empty;
635 connection default;
636 XA COMMIT 'trx1empty';
637 KILL connection CONN_ID;
638 XA COMMIT 'trx3empty';
639 connect conn1$type, 127.0.0.1,root,,test,$MASTER_MYPORT,;
640 XA START 'trx1unprepared';
641 INSERT INTO t set a=0;
642 XA END 'trx1unprepared';
643 INSERT INTO t set a=0;
644 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
645 XA START 'trx1unprepared';
646 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
647 XA START 'trx1unprepared';
648 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
649 disconnect conn1unprepared;
650 connection default;
651 XA COMMIT 'trx1unprepared';
652 ERROR XAE04: XAER_NOTA: Unknown XID
653 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
654 SET @@binlog_format = STATEMENT;
655 XA START 'trx_0';
656 INSERT INTO t SET a=0;
657 XA END 'trx_0';
658 XA PREPARE 'trx_0';
659 disconnect conn0;
660 connection default;
661 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
662 SET @@binlog_format = STATEMENT;
663 SET @@binlog_format = ROW;
664 XA START 'trx_1';
665 INSERT INTO t SET a=1;
666 XA END 'trx_1';
667 XA PREPARE 'trx_1';
668 disconnect conn1;
669 connection default;
670 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
671 SET @@binlog_format = STATEMENT;
672 XA START 'trx_2';
673 INSERT INTO t SET a=2;
674 XA END 'trx_2';
675 XA PREPARE 'trx_2';
676 disconnect conn2;
677 connection default;
678 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
679 SET @@binlog_format = STATEMENT;
680 SET @@binlog_format = ROW;
681 XA START 'trx_3';
682 INSERT INTO t SET a=3;
683 XA END 'trx_3';
684 XA PREPARE 'trx_3';
685 disconnect conn3;
686 connection default;
687 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
688 SET @@binlog_format = STATEMENT;
689 XA START 'trx_4';
690 INSERT INTO t SET a=4;
691 XA END 'trx_4';
692 XA PREPARE 'trx_4';
693 disconnect conn4;
694 connection default;
695 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
696 SET @@binlog_format = STATEMENT;
697 SET @@binlog_format = ROW;
698 XA START 'trx_5';
699 INSERT INTO t SET a=5;
700 XA END 'trx_5';
701 XA PREPARE 'trx_5';
702 disconnect conn5;
703 connection default;
704 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
705 SET @@binlog_format = STATEMENT;
706 XA START 'trx_6';
707 INSERT INTO t SET a=6;
708 XA END 'trx_6';
709 XA PREPARE 'trx_6';
710 disconnect conn6;
711 connection default;
712 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
713 SET @@binlog_format = STATEMENT;
714 SET @@binlog_format = ROW;
715 XA START 'trx_7';
716 INSERT INTO t SET a=7;
717 XA END 'trx_7';
718 XA PREPARE 'trx_7';
719 disconnect conn7;
720 connection default;
721 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
722 SET @@binlog_format = STATEMENT;
723 XA START 'trx_8';
724 INSERT INTO t SET a=8;
725 XA END 'trx_8';
726 XA PREPARE 'trx_8';
727 disconnect conn8;
728 connection default;
729 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
730 SET @@binlog_format = STATEMENT;
731 SET @@binlog_format = ROW;
732 XA START 'trx_9';
733 INSERT INTO t SET a=9;
734 XA END 'trx_9';
735 XA PREPARE 'trx_9';
736 disconnect conn9;
737 connection default;
738 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
739 SET @@binlog_format = STATEMENT;
740 XA START 'trx_10';
741 INSERT INTO t SET a=10;
742 XA END 'trx_10';
743 XA PREPARE 'trx_10';
744 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
745 SET @@binlog_format = STATEMENT;
746 SET @@binlog_format = ROW;
747 XA START 'trx_11';
748 INSERT INTO t SET a=11;
749 XA END 'trx_11';
750 XA PREPARE 'trx_11';
751 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
752 SET @@binlog_format = STATEMENT;
753 XA START 'trx_12';
754 INSERT INTO t SET a=12;
755 XA END 'trx_12';
756 XA PREPARE 'trx_12';
757 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
758 SET @@binlog_format = STATEMENT;
759 SET @@binlog_format = ROW;
760 XA START 'trx_13';
761 INSERT INTO t SET a=13;
762 XA END 'trx_13';
763 XA PREPARE 'trx_13';
764 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
765 SET @@binlog_format = STATEMENT;
766 XA START 'trx_14';
767 INSERT INTO t SET a=14;
768 XA END 'trx_14';
769 XA PREPARE 'trx_14';
770 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
771 SET @@binlog_format = STATEMENT;
772 SET @@binlog_format = ROW;
773 XA START 'trx_15';
774 INSERT INTO t SET a=15;
775 XA END 'trx_15';
776 XA PREPARE 'trx_15';
777 connection default;
778 KILL CONNECTION CONN_ID;
779 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
780 SET @@binlog_format = STATEMENT;
781 XA START 'trx_16';
782 INSERT INTO t SET a=16;
783 XA END 'trx_16';
784 XA PREPARE 'trx_16';
785 connection default;
786 KILL CONNECTION CONN_ID;
787 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
788 SET @@binlog_format = STATEMENT;
789 SET @@binlog_format = ROW;
790 XA START 'trx_17';
791 INSERT INTO t SET a=17;
792 XA END 'trx_17';
793 XA PREPARE 'trx_17';
794 connection default;
795 KILL CONNECTION CONN_ID;
796 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
797 SET @@binlog_format = STATEMENT;
798 XA START 'trx_18';
799 INSERT INTO t SET a=18;
800 XA END 'trx_18';
801 XA PREPARE 'trx_18';
802 connection default;
803 KILL CONNECTION CONN_ID;
804 connect conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
805 SET @@binlog_format = STATEMENT;
806 SET @@binlog_format = ROW;
807 XA START 'trx_19';
808 INSERT INTO t SET a=19;
809 XA END 'trx_19';
810 XA PREPARE 'trx_19';
811 connection default;
812 KILL CONNECTION CONN_ID;
813 connection default;
814 XA ROLLBACK 'trx_0';
815 XA ROLLBACK 'trx_1';
816 XA ROLLBACK 'trx_2';
817 XA ROLLBACK 'trx_3';
818 XA ROLLBACK 'trx_4';
819 XA COMMIT 'trx_5';
820 XA COMMIT 'trx_6';
821 XA COMMIT 'trx_7';
822 XA COMMIT 'trx_8';
823 XA COMMIT 'trx_9';
824 # Kill and restart
825 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
826 XA START 'new_trx_0';
827 INSERT INTO t SET a=0;
828 XA END 'new_trx_0';
829 XA PREPARE 'new_trx_0';
830 disconnect conn_restart_0;
831 connection default;
832 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
833 XA START 'new_trx_1';
834 INSERT INTO t SET a=1;
835 XA END 'new_trx_1';
836 XA PREPARE 'new_trx_1';
837 disconnect conn_restart_1;
838 connection default;
839 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
840 XA START 'new_trx_2';
841 INSERT INTO t SET a=2;
842 XA END 'new_trx_2';
843 XA PREPARE 'new_trx_2';
844 disconnect conn_restart_2;
845 connection default;
846 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
847 XA START 'new_trx_3';
848 INSERT INTO t SET a=3;
849 XA END 'new_trx_3';
850 XA PREPARE 'new_trx_3';
851 disconnect conn_restart_3;
852 connection default;
853 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
854 XA START 'new_trx_4';
855 INSERT INTO t SET a=4;
856 XA END 'new_trx_4';
857 XA PREPARE 'new_trx_4';
858 disconnect conn_restart_4;
859 connection default;
860 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
861 XA START 'new_trx_5';
862 INSERT INTO t SET a=5;
863 XA END 'new_trx_5';
864 XA PREPARE 'new_trx_5';
865 disconnect conn_restart_5;
866 connection default;
867 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
868 XA START 'new_trx_6';
869 INSERT INTO t SET a=6;
870 XA END 'new_trx_6';
871 XA PREPARE 'new_trx_6';
872 disconnect conn_restart_6;
873 connection default;
874 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
875 XA START 'new_trx_7';
876 INSERT INTO t SET a=7;
877 XA END 'new_trx_7';
878 XA PREPARE 'new_trx_7';
879 disconnect conn_restart_7;
880 connection default;
881 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
882 XA START 'new_trx_8';
883 INSERT INTO t SET a=8;
884 XA END 'new_trx_8';
885 XA PREPARE 'new_trx_8';
886 disconnect conn_restart_8;
887 connection default;
888 connect conn_restart_$k, 127.0.0.1,root,,test,$MASTER_MYPORT,;
889 XA START 'new_trx_9';
890 INSERT INTO t SET a=9;
891 XA END 'new_trx_9';
892 XA PREPARE 'new_trx_9';
893 disconnect conn_restart_9;
894 connection default;
895 connection default;
896 XA COMMIT 'new_trx_0';
897 XA COMMIT 'new_trx_1';
898 XA COMMIT 'new_trx_2';
899 XA COMMIT 'new_trx_3';
900 XA COMMIT 'new_trx_4';
901 XA COMMIT 'new_trx_5';
902 XA COMMIT 'new_trx_6';
903 XA COMMIT 'new_trx_7';
904 XA COMMIT 'new_trx_8';
905 XA COMMIT 'new_trx_9';
906 XA START 'trx_10';
907 ERROR XAE08: XAER_DUPID: The XID already exists
908 XA COMMIT 'trx_10';
909 XA START 'trx_11';
910 ERROR XAE08: XAER_DUPID: The XID already exists
911 XA COMMIT 'trx_11';
912 XA START 'trx_12';
913 ERROR XAE08: XAER_DUPID: The XID already exists
914 XA COMMIT 'trx_12';
915 XA START 'trx_13';
916 ERROR XAE08: XAER_DUPID: The XID already exists
917 XA COMMIT 'trx_13';
918 XA START 'trx_14';
919 ERROR XAE08: XAER_DUPID: The XID already exists
920 XA COMMIT 'trx_14';
921 XA START 'trx_15';
922 ERROR XAE08: XAER_DUPID: The XID already exists
923 XA ROLLBACK 'trx_15';
924 XA START 'trx_16';
925 ERROR XAE08: XAER_DUPID: The XID already exists
926 XA ROLLBACK 'trx_16';
927 XA START 'trx_17';
928 ERROR XAE08: XAER_DUPID: The XID already exists
929 XA ROLLBACK 'trx_17';
930 XA START 'trx_18';
931 ERROR XAE08: XAER_DUPID: The XID already exists
932 XA ROLLBACK 'trx_18';
933 XA START 'trx_19';
934 ERROR XAE08: XAER_DUPID: The XID already exists
935 XA ROLLBACK 'trx_19';
936 SELECT * FROM t;
937 a
938 100
939 5
940 6
941 7
942 8
943 9
944 10
945 11
946 12
947 13
948 14
949 0
950 1
951 2
952 3
953 4
954 5
955 6
956 7
957 8
958 9
959 5
960 6
961 7
962 8
963 9
964 10
965 11
966 12
967 13
968 14
969 0
970 1
971 2
972 3
973 4
974 5
975 6
976 7
977 8
978 9
979 disconnect conn2tmp;
980 disconnect conn3tmp;
981 disconnect conn2ro;
982 disconnect conn3ro;
983 disconnect conn2empty;
984 disconnect conn3empty;
985 connection default;
986 XA ROLLBACK 'trx_20';
987 ERROR XAE04: XAER_NOTA: Unknown XID
988 disconnect conn19;
989 connection default;
990 XA ROLLBACK 'trx_19';
991 ERROR XAE04: XAER_NOTA: Unknown XID
992 disconnect conn18;
993 connection default;
994 XA ROLLBACK 'trx_18';
995 ERROR XAE04: XAER_NOTA: Unknown XID
996 disconnect conn17;
997 connection default;
998 XA ROLLBACK 'trx_17';
999 ERROR XAE04: XAER_NOTA: Unknown XID
1000 disconnect conn16;
1001 connection default;
1002 XA ROLLBACK 'trx_16';
1003 ERROR XAE04: XAER_NOTA: Unknown XID
1004 disconnect conn15;
1005 connection default;
1006 XA ROLLBACK 'trx_15';
1007 ERROR XAE04: XAER_NOTA: Unknown XID
1008 disconnect conn14;
1009 connection default;
1010 XA ROLLBACK 'trx_14';
1011 ERROR XAE04: XAER_NOTA: Unknown XID
1012 disconnect conn13;
1013 connection default;
1014 XA ROLLBACK 'trx_13';
1015 ERROR XAE04: XAER_NOTA: Unknown XID
1016 disconnect conn12;
1017 connection default;
1018 XA ROLLBACK 'trx_12';
1019 ERROR XAE04: XAER_NOTA: Unknown XID
1020 disconnect conn11;
1021 connection default;
1022 XA ROLLBACK 'trx_11';
1023 ERROR XAE04: XAER_NOTA: Unknown XID
1024 disconnect conn10;
1025 connection default;
1026 XA START 'one_phase_trx_0';
1027 INSERT INTO t SET a=0;
1028 XA END 'one_phase_trx_0';
1029 XA COMMIT 'one_phase_trx_0' ONE PHASE;
1030 XA START 'one_phase_trx_1';
1031 INSERT INTO t SET a=1;
1032 XA END 'one_phase_trx_1';
1033 XA COMMIT 'one_phase_trx_1' ONE PHASE;
1034 XA START 'one_phase_trx_2';
1035 INSERT INTO t SET a=2;
1036 XA END 'one_phase_trx_2';
1037 XA COMMIT 'one_phase_trx_2' ONE PHASE;
1038 XA START 'one_phase_trx_3';
1039 INSERT INTO t SET a=3;
1040 XA END 'one_phase_trx_3';
1041 XA COMMIT 'one_phase_trx_3' ONE PHASE;
1042 XA START 'one_phase_trx_4';
1043 INSERT INTO t SET a=4;
1044 XA END 'one_phase_trx_4';
1045 XA COMMIT 'one_phase_trx_4' ONE PHASE;
1046 SELECT SUM(a) FROM t;
1047 SUM(a)
1048 390
1049 DROP TABLE t;
1050 DROP VIEW v_processlist;
1051 include/show_binlog_events.inc
1052 Log_name Pos Event_type Server_id End_log_pos Info
1053 master-bin.000001 # Gtid # # GTID #-#-#
1054 master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_processlist` AS SELECT * FROM performance_schema.threads where type = 'FOREGROUND'
1055 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1056 master-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Found 10 prepared XA transactions' COLLATE 'utf8mb4_uca1400_ai_ci'))
1057 master-bin.000001 # Query # # COMMIT
1058 master-bin.000001 # Gtid # # GTID #-#-#
1059 master-bin.000001 # Query # # use `test`; CREATE TABLE t (a INT) ENGINE=innodb
1060 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1061 master-bin.000001 # Query # # use `test`; INSERT INTO t VALUES(100)
1062 master-bin.000001 # Xid # # COMMIT /* XID */
1063 master-bin.000001 # Gtid # # XA START X'7472785f30',X'',1 GTID #-#-#
1064 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=0
1065 master-bin.000001 # Query # # XA END X'7472785f30',X'',1
1066 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f30',X'',1
1067 master-bin.000001 # Gtid # # XA START X'7472785f31',X'',1 GTID #-#-#
1068 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=1
1069 master-bin.000001 # Table_map # # table_id: # (test.t)
1070 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1071 master-bin.000001 # Query # # XA END X'7472785f31',X'',1
1072 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f31',X'',1
1073 master-bin.000001 # Gtid # # XA START X'7472785f32',X'',1 GTID #-#-#
1074 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=2
1075 master-bin.000001 # Query # # XA END X'7472785f32',X'',1
1076 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f32',X'',1
1077 master-bin.000001 # Gtid # # XA START X'7472785f33',X'',1 GTID #-#-#
1078 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=3
1079 master-bin.000001 # Table_map # # table_id: # (test.t)
1080 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1081 master-bin.000001 # Query # # XA END X'7472785f33',X'',1
1082 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f33',X'',1
1083 master-bin.000001 # Gtid # # XA START X'7472785f34',X'',1 GTID #-#-#
1084 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=4
1085 master-bin.000001 # Query # # XA END X'7472785f34',X'',1
1086 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f34',X'',1
1087 master-bin.000001 # Gtid # # XA START X'7472785f35',X'',1 GTID #-#-#
1088 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=5
1089 master-bin.000001 # Table_map # # table_id: # (test.t)
1090 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1091 master-bin.000001 # Query # # XA END X'7472785f35',X'',1
1092 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f35',X'',1
1093 master-bin.000001 # Gtid # # XA START X'7472785f36',X'',1 GTID #-#-#
1094 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=6
1095 master-bin.000001 # Query # # XA END X'7472785f36',X'',1
1096 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f36',X'',1
1097 master-bin.000001 # Gtid # # XA START X'7472785f37',X'',1 GTID #-#-#
1098 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=7
1099 master-bin.000001 # Table_map # # table_id: # (test.t)
1100 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1101 master-bin.000001 # Query # # XA END X'7472785f37',X'',1
1102 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f37',X'',1
1103 master-bin.000001 # Gtid # # XA START X'7472785f38',X'',1 GTID #-#-#
1104 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=8
1105 master-bin.000001 # Query # # XA END X'7472785f38',X'',1
1106 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f38',X'',1
1107 master-bin.000001 # Gtid # # XA START X'7472785f39',X'',1 GTID #-#-#
1108 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=9
1109 master-bin.000001 # Table_map # # table_id: # (test.t)
1110 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1111 master-bin.000001 # Query # # XA END X'7472785f39',X'',1
1112 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f39',X'',1
1113 master-bin.000001 # Gtid # # XA START X'7472785f3130',X'',1 GTID #-#-#
1114 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=10
1115 master-bin.000001 # Query # # XA END X'7472785f3130',X'',1
1116 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3130',X'',1
1117 master-bin.000001 # Gtid # # XA START X'7472785f3131',X'',1 GTID #-#-#
1118 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=11
1119 master-bin.000001 # Table_map # # table_id: # (test.t)
1120 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1121 master-bin.000001 # Query # # XA END X'7472785f3131',X'',1
1122 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3131',X'',1
1123 master-bin.000001 # Gtid # # XA START X'7472785f3132',X'',1 GTID #-#-#
1124 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=12
1125 master-bin.000001 # Query # # XA END X'7472785f3132',X'',1
1126 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3132',X'',1
1127 master-bin.000001 # Gtid # # XA START X'7472785f3133',X'',1 GTID #-#-#
1128 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=13
1129 master-bin.000001 # Table_map # # table_id: # (test.t)
1130 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1131 master-bin.000001 # Query # # XA END X'7472785f3133',X'',1
1132 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3133',X'',1
1133 master-bin.000001 # Gtid # # XA START X'7472785f3134',X'',1 GTID #-#-#
1134 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=14
1135 master-bin.000001 # Query # # XA END X'7472785f3134',X'',1
1136 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3134',X'',1
1137 master-bin.000001 # Gtid # # XA START X'7472785f3135',X'',1 GTID #-#-#
1138 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=15
1139 master-bin.000001 # Table_map # # table_id: # (test.t)
1140 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1141 master-bin.000001 # Query # # XA END X'7472785f3135',X'',1
1142 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3135',X'',1
1143 master-bin.000001 # Gtid # # XA START X'7472785f3136',X'',1 GTID #-#-#
1144 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=16
1145 master-bin.000001 # Query # # XA END X'7472785f3136',X'',1
1146 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3136',X'',1
1147 master-bin.000001 # Gtid # # XA START X'7472785f3137',X'',1 GTID #-#-#
1148 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=17
1149 master-bin.000001 # Table_map # # table_id: # (test.t)
1150 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1151 master-bin.000001 # Query # # XA END X'7472785f3137',X'',1
1152 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3137',X'',1
1153 master-bin.000001 # Gtid # # XA START X'7472785f3138',X'',1 GTID #-#-#
1154 master-bin.000001 # Query # # use `test`; INSERT INTO t SET a=18
1155 master-bin.000001 # Query # # XA END X'7472785f3138',X'',1
1156 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3138',X'',1
1157 master-bin.000001 # Gtid # # XA START X'7472785f3139',X'',1 GTID #-#-#
1158 master-bin.000001 # Annotate_rows # # INSERT INTO t SET a=19
1159 master-bin.000001 # Table_map # # table_id: # (test.t)
1160 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1161 master-bin.000001 # Query # # XA END X'7472785f3139',X'',1
1162 master-bin.000001 # XA_prepare # # XA PREPARE X'7472785f3139',X'',1
1163 master-bin.000001 # Gtid # # GTID #-#-#
1164 master-bin.000001 # Query # # XA ROLLBACK X'7472785f30',X'',1
1165 master-bin.000001 # Gtid # # GTID #-#-#
1166 master-bin.000001 # Query # # XA ROLLBACK X'7472785f31',X'',1
1167 master-bin.000001 # Gtid # # GTID #-#-#
1168 master-bin.000001 # Query # # XA ROLLBACK X'7472785f32',X'',1
1169 master-bin.000001 # Gtid # # GTID #-#-#
1170 master-bin.000001 # Query # # XA ROLLBACK X'7472785f33',X'',1
1171 master-bin.000001 # Gtid # # GTID #-#-#
1172 master-bin.000001 # Query # # XA ROLLBACK X'7472785f34',X'',1
1173 master-bin.000001 # Gtid # # GTID #-#-#
1174 master-bin.000001 # Query # # XA COMMIT X'7472785f35',X'',1
1175 master-bin.000001 # Gtid # # GTID #-#-#
1176 master-bin.000001 # Query # # XA COMMIT X'7472785f36',X'',1
1177 master-bin.000001 # Gtid # # GTID #-#-#
1178 master-bin.000001 # Query # # XA COMMIT X'7472785f37',X'',1
1179 master-bin.000001 # Gtid # # GTID #-#-#
1180 master-bin.000001 # Query # # XA COMMIT X'7472785f38',X'',1
1181 master-bin.000001 # Gtid # # GTID #-#-#
1182 master-bin.000001 # Query # # XA COMMIT X'7472785f39',X'',1
1183 master-bin.000001 # Stop # #
1184 All transactions must be completed, to empty-list the following:
1185 XA RECOVER;
1186 formatID gtrid_length bqual_length data
1187 XA RECOVER;
1188 formatID gtrid_length bqual_length data