Debian Codegraph @

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