Debian Codegraph @

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

raw
1 include/only_with_option.inc [GLOBAL.xa_detach_on_prepare = 0]
2 CALL mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
3 include/gtid_utils.inc
4 RESET MASTER;
5 CREATE VIEW v_processlist as SELECT * FROM performance_schema.threads where type = 'FOREGROUND';
6 call mtr.add_suppression("Found 10 prepared XA transactions");
7 call mtr.add_suppression("Found 1 prepared XA transactions");
8 CREATE TABLE t (a INT) ENGINE=innodb;
9 SET @@sql_log_bin = OFF;
10 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
11 XA START 'trx1tmp';
12 INSERT INTO tmp1 SET a=1;
13 XA END 'trx1tmp';
14 XA PREPARE 'trx1tmp';
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 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 XA COMMIT 'trx1tmp';
28 ERROR XAE04: XAER_NOTA: Unknown XID
29 XA ROLLBACK 'trx1tmp';
30 ERROR XAE04: XAER_NOTA: Unknown XID
31 XA START 'trx1tmp';
32 ERROR XAE08: XAER_DUPID: The XID already exists
33 *** 3 prepared transactions must be in the list ***
34 XA RECOVER;
35 formatID gtrid_length bqual_length data
36 1 LEN1 LEN2 TRX_N
37 1 LEN1 LEN2 TRX_N
38 1 LEN1 LEN2 TRX_N
39 XA COMMIT 'trx1tmp';
40 KILL connection CONN_ID;
41 XA COMMIT 'trx3tmp';
42 XA START 'trx1ro1';
43 SELECT * from t ORDER BY a;
44 XA END 'trx1ro1';
45 XA PREPARE 'trx1ro1';
46 XA START 'trx2ro1';
47 SELECT * from t ORDER BY a;
48 XA END 'trx2ro1';
49 XA PREPARE 'trx2ro1';
50 XA START 'trx3ro1';
51 SELECT * from t ORDER BY a;
52 XA END 'trx3ro1';
53 XA PREPARE 'trx3ro1';
54 *** 4 prepared transactions must be in the list ***
55 XA RECOVER;
56 formatID gtrid_length bqual_length data
57 1 LEN1 LEN2 TRX_N
58 1 LEN1 LEN2 TRX_N
59 1 LEN1 LEN2 TRX_N
60 1 LEN1 LEN2 TRX_N
61 XA COMMIT 'trx1ro1';
62 KILL connection CONN_ID;
63 XA COMMIT 'trx3ro1';
64 XA START 'trx1ro2';
65 SELECT * from t ORDER BY a;
66 XA END 'trx1ro2';
67 XA PREPARE 'trx1ro2';
68 XA START 'trx2ro2';
69 SELECT * from t ORDER BY a;
70 XA END 'trx2ro2';
71 XA PREPARE 'trx2ro2';
72 XA START 'trx3ro2';
73 SELECT * from t ORDER BY a;
74 XA END 'trx3ro2';
75 XA PREPARE 'trx3ro2';
76 *** 5 prepared transactions must be in the list ***
77 XA RECOVER;
78 formatID gtrid_length bqual_length data
79 1 LEN1 LEN2 TRX_N
80 1 LEN1 LEN2 TRX_N
81 1 LEN1 LEN2 TRX_N
82 1 LEN1 LEN2 TRX_N
83 1 LEN1 LEN2 TRX_N
84 XA ROLLBACK 'trx1ro2';
85 KILL connection CONN_ID;
86 XA ROLLBACK 'trx3ro2';
87 XA START 'trx1empty1';
88 XA END 'trx1empty1';
89 XA PREPARE 'trx1empty1';
90 XA START 'trx2empty1';
91 XA END 'trx2empty1';
92 XA PREPARE 'trx2empty1';
93 XA START 'trx3empty1';
94 XA END 'trx3empty1';
95 XA PREPARE 'trx3empty1';
96 *** 6 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 1 LEN1 LEN2 TRX_N
105 XA COMMIT 'trx1empty1';
106 KILL connection CONN_ID;
107 XA COMMIT 'trx3empty1';
108 XA START 'trx1empty2';
109 XA END 'trx1empty2';
110 XA PREPARE 'trx1empty2';
111 XA START 'trx2empty2';
112 XA END 'trx2empty2';
113 XA PREPARE 'trx2empty2';
114 XA START 'trx3empty2';
115 XA END 'trx3empty2';
116 XA PREPARE 'trx3empty2';
117 *** 7 prepared transactions must be in the list ***
118 XA RECOVER;
119 formatID gtrid_length bqual_length data
120 1 LEN1 LEN2 TRX_N
121 1 LEN1 LEN2 TRX_N
122 1 LEN1 LEN2 TRX_N
123 1 LEN1 LEN2 TRX_N
124 1 LEN1 LEN2 TRX_N
125 1 LEN1 LEN2 TRX_N
126 1 LEN1 LEN2 TRX_N
127 XA ROLLBACK 'trx1empty2';
128 KILL connection CONN_ID;
129 XA ROLLBACK 'trx3empty2';
130 XA START 'trx1unprepared';
131 INSERT INTO t set a=0;
132 XA END 'trx1unprepared';
133 INSERT INTO t set a=0;
134 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
135 XA START 'trx1unprepared';
136 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
137 XA START 'trx1unprepared';
138 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
139 XA COMMIT 'trx1unprepared';
140 ERROR XAE04: XAER_NOTA: Unknown XID
141 SET @@binlog_format = 'STATEMENT';
142 XA START 'trx_0';
143 INSERT INTO t SET a=0;
144 XA END 'trx_0';
145 XA PREPARE 'trx_0';
146 SET @@binlog_format = 'STATEMENT';
147 SET @@binlog_format = 'ROW';
148 XA START 'trx_1';
149 INSERT INTO t SET a=1;
150 XA END 'trx_1';
151 XA PREPARE 'trx_1';
152 SET @@binlog_format = 'STATEMENT';
153 XA START 'trx_2';
154 INSERT INTO t SET a=2;
155 XA END 'trx_2';
156 XA PREPARE 'trx_2';
157 SET @@binlog_format = 'STATEMENT';
158 SET @@binlog_format = 'ROW';
159 XA START 'trx_3';
160 INSERT INTO t SET a=3;
161 XA END 'trx_3';
162 XA PREPARE 'trx_3';
163 SET @@binlog_format = 'STATEMENT';
164 XA START 'trx_4';
165 INSERT INTO t SET a=4;
166 XA END 'trx_4';
167 XA PREPARE 'trx_4';
168 SET @@binlog_format = 'STATEMENT';
169 SET @@binlog_format = 'ROW';
170 XA START 'trx_5';
171 INSERT INTO t SET a=5;
172 XA END 'trx_5';
173 XA PREPARE 'trx_5';
174 SET @@binlog_format = 'STATEMENT';
175 XA START 'trx_6';
176 INSERT INTO t SET a=6;
177 XA END 'trx_6';
178 XA PREPARE 'trx_6';
179 SET @@binlog_format = 'STATEMENT';
180 SET @@binlog_format = 'ROW';
181 XA START 'trx_7';
182 INSERT INTO t SET a=7;
183 XA END 'trx_7';
184 XA PREPARE 'trx_7';
185 SET @@binlog_format = 'STATEMENT';
186 XA START 'trx_8';
187 INSERT INTO t SET a=8;
188 XA END 'trx_8';
189 XA PREPARE 'trx_8';
190 SET @@binlog_format = 'STATEMENT';
191 SET @@binlog_format = 'ROW';
192 XA START 'trx_9';
193 INSERT INTO t SET a=9;
194 XA END 'trx_9';
195 XA PREPARE 'trx_9';
196 SET @@binlog_format = 'STATEMENT';
197 XA START 'trx_10';
198 INSERT INTO t SET a=10;
199 XA END 'trx_10';
200 XA PREPARE 'trx_10';
201 SET @@binlog_format = 'STATEMENT';
202 SET @@binlog_format = 'ROW';
203 XA START 'trx_11';
204 INSERT INTO t SET a=11;
205 XA END 'trx_11';
206 XA PREPARE 'trx_11';
207 SET @@binlog_format = 'STATEMENT';
208 XA START 'trx_12';
209 INSERT INTO t SET a=12;
210 XA END 'trx_12';
211 XA PREPARE 'trx_12';
212 SET @@binlog_format = 'STATEMENT';
213 SET @@binlog_format = 'ROW';
214 XA START 'trx_13';
215 INSERT INTO t SET a=13;
216 XA END 'trx_13';
217 XA PREPARE 'trx_13';
218 SET @@binlog_format = 'STATEMENT';
219 XA START 'trx_14';
220 INSERT INTO t SET a=14;
221 XA END 'trx_14';
222 XA PREPARE 'trx_14';
223 SET @@binlog_format = 'STATEMENT';
224 SET @@binlog_format = 'ROW';
225 XA START 'trx_15';
226 INSERT INTO t SET a=15;
227 XA END 'trx_15';
228 XA PREPARE 'trx_15';
229 KILL CONNECTION CONN_ID;
230 SET @@binlog_format = 'STATEMENT';
231 XA START 'trx_16';
232 INSERT INTO t SET a=16;
233 XA END 'trx_16';
234 XA PREPARE 'trx_16';
235 KILL CONNECTION CONN_ID;
236 SET @@binlog_format = 'STATEMENT';
237 SET @@binlog_format = 'ROW';
238 XA START 'trx_17';
239 INSERT INTO t SET a=17;
240 XA END 'trx_17';
241 XA PREPARE 'trx_17';
242 KILL CONNECTION CONN_ID;
243 SET @@binlog_format = 'STATEMENT';
244 XA START 'trx_18';
245 INSERT INTO t SET a=18;
246 XA END 'trx_18';
247 XA PREPARE 'trx_18';
248 KILL CONNECTION CONN_ID;
249 SET @@binlog_format = 'STATEMENT';
250 SET @@binlog_format = 'ROW';
251 XA START 'trx_19';
252 INSERT INTO t SET a=19;
253 XA END 'trx_19';
254 XA PREPARE 'trx_19';
255 KILL CONNECTION CONN_ID;
256 XA ROLLBACK 'trx_0';
257 XA ROLLBACK 'trx_1';
258 XA ROLLBACK 'trx_2';
259 XA ROLLBACK 'trx_3';
260 XA ROLLBACK 'trx_4';
261 XA COMMIT 'trx_5';
262 XA COMMIT 'trx_6';
263 XA COMMIT 'trx_7';
264 XA COMMIT 'trx_8';
265 XA COMMIT 'trx_9';
266 # restart
267 XA START 'new_trx_0';
268 INSERT INTO t SET a=0;
269 XA END 'new_trx_0';
270 XA PREPARE 'new_trx_0';
271 XA START 'new_trx_1';
272 INSERT INTO t SET a=1;
273 XA END 'new_trx_1';
274 XA PREPARE 'new_trx_1';
275 XA START 'new_trx_2';
276 INSERT INTO t SET a=2;
277 XA END 'new_trx_2';
278 XA PREPARE 'new_trx_2';
279 XA START 'new_trx_3';
280 INSERT INTO t SET a=3;
281 XA END 'new_trx_3';
282 XA PREPARE 'new_trx_3';
283 XA START 'new_trx_4';
284 INSERT INTO t SET a=4;
285 XA END 'new_trx_4';
286 XA PREPARE 'new_trx_4';
287 XA START 'new_trx_5';
288 INSERT INTO t SET a=5;
289 XA END 'new_trx_5';
290 XA PREPARE 'new_trx_5';
291 XA START 'new_trx_6';
292 INSERT INTO t SET a=6;
293 XA END 'new_trx_6';
294 XA PREPARE 'new_trx_6';
295 XA START 'new_trx_7';
296 INSERT INTO t SET a=7;
297 XA END 'new_trx_7';
298 XA PREPARE 'new_trx_7';
299 XA START 'new_trx_8';
300 INSERT INTO t SET a=8;
301 XA END 'new_trx_8';
302 XA PREPARE 'new_trx_8';
303 XA START 'new_trx_9';
304 INSERT INTO t SET a=9;
305 XA END 'new_trx_9';
306 XA PREPARE 'new_trx_9';
307 XA COMMIT 'new_trx_0';
308 XA COMMIT 'new_trx_1';
309 XA COMMIT 'new_trx_2';
310 XA COMMIT 'new_trx_3';
311 XA COMMIT 'new_trx_4';
312 XA COMMIT 'new_trx_5';
313 XA COMMIT 'new_trx_6';
314 XA COMMIT 'new_trx_7';
315 XA COMMIT 'new_trx_8';
316 XA COMMIT 'new_trx_9';
317 XA START 'trx_10';
318 ERROR XAE08: XAER_DUPID: The XID already exists
319 XA COMMIT 'trx_10';
320 XA START 'trx_11';
321 ERROR XAE08: XAER_DUPID: The XID already exists
322 XA COMMIT 'trx_11';
323 XA START 'trx_12';
324 ERROR XAE08: XAER_DUPID: The XID already exists
325 XA COMMIT 'trx_12';
326 XA START 'trx_13';
327 ERROR XAE08: XAER_DUPID: The XID already exists
328 XA COMMIT 'trx_13';
329 XA START 'trx_14';
330 ERROR XAE08: XAER_DUPID: The XID already exists
331 XA COMMIT 'trx_14';
332 XA START 'trx_15';
333 ERROR XAE08: XAER_DUPID: The XID already exists
334 XA ROLLBACK 'trx_15';
335 XA START 'trx_16';
336 ERROR XAE08: XAER_DUPID: The XID already exists
337 XA ROLLBACK 'trx_16';
338 XA START 'trx_17';
339 ERROR XAE08: XAER_DUPID: The XID already exists
340 XA ROLLBACK 'trx_17';
341 XA START 'trx_18';
342 ERROR XAE08: XAER_DUPID: The XID already exists
343 XA ROLLBACK 'trx_18';
344 XA START 'trx_19';
345 ERROR XAE08: XAER_DUPID: The XID already exists
346 XA ROLLBACK 'trx_19';
347 SELECT * FROM t;
348 a
349 5
350 6
351 7
352 8
353 9
354 10
355 11
356 12
357 13
358 14
359 0
360 1
361 2
362 3
363 4
364 5
365 6
366 7
367 8
368 9
369 XA ROLLBACK 'trx_20';
370 ERROR XAE04: XAER_NOTA: Unknown XID
371 XA ROLLBACK 'trx_19';
372 ERROR XAE04: XAER_NOTA: Unknown XID
373 XA ROLLBACK 'trx_18';
374 ERROR XAE04: XAER_NOTA: Unknown XID
375 XA ROLLBACK 'trx_17';
376 ERROR XAE04: XAER_NOTA: Unknown XID
377 XA ROLLBACK 'trx_16';
378 ERROR XAE04: XAER_NOTA: Unknown XID
379 XA ROLLBACK 'trx_15';
380 ERROR XAE04: XAER_NOTA: Unknown XID
381 XA ROLLBACK 'trx_14';
382 ERROR XAE04: XAER_NOTA: Unknown XID
383 XA ROLLBACK 'trx_13';
384 ERROR XAE04: XAER_NOTA: Unknown XID
385 XA ROLLBACK 'trx_12';
386 ERROR XAE04: XAER_NOTA: Unknown XID
387 XA ROLLBACK 'trx_11';
388 ERROR XAE04: XAER_NOTA: Unknown XID
389 SET @@sql_log_bin = OFF;
390 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
391 XA START 'trx1tmp';
392 INSERT INTO tmp1 SET a=1;
393 XA END 'trx1tmp';
394 XA PREPARE 'trx1tmp';
395 SET @@sql_log_bin = OFF;
396 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
397 XA START 'trx2tmp';
398 INSERT INTO tmp1 SET a=1;
399 XA END 'trx2tmp';
400 XA PREPARE 'trx2tmp';
401 SET @@sql_log_bin = OFF;
402 CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
403 XA START 'trx3tmp';
404 INSERT INTO tmp1 SET a=1;
405 XA END 'trx3tmp';
406 XA PREPARE 'trx3tmp';
407 XA COMMIT 'trx1tmp';
408 ERROR XAE04: XAER_NOTA: Unknown XID
409 XA ROLLBACK 'trx1tmp';
410 ERROR XAE04: XAER_NOTA: Unknown XID
411 XA START 'trx1tmp';
412 ERROR XAE08: XAER_DUPID: The XID already exists
413 *** 3 prepared transactions must be in the list ***
414 XA RECOVER;
415 formatID gtrid_length bqual_length data
416 1 LEN1 LEN2 TRX_N
417 1 LEN1 LEN2 TRX_N
418 1 LEN1 LEN2 TRX_N
419 XA COMMIT 'trx1tmp';
420 KILL connection CONN_ID;
421 XA COMMIT 'trx3tmp';
422 XA START 'trx1ro1';
423 SELECT * from t ORDER BY a;
424 XA END 'trx1ro1';
425 XA PREPARE 'trx1ro1';
426 XA START 'trx2ro1';
427 SELECT * from t ORDER BY a;
428 XA END 'trx2ro1';
429 XA PREPARE 'trx2ro1';
430 XA START 'trx3ro1';
431 SELECT * from t ORDER BY a;
432 XA END 'trx3ro1';
433 XA PREPARE 'trx3ro1';
434 *** 4 prepared transactions must be in the list ***
435 XA RECOVER;
436 formatID gtrid_length bqual_length data
437 1 LEN1 LEN2 TRX_N
438 1 LEN1 LEN2 TRX_N
439 1 LEN1 LEN2 TRX_N
440 1 LEN1 LEN2 TRX_N
441 XA COMMIT 'trx1ro1';
442 KILL connection CONN_ID;
443 XA COMMIT 'trx3ro1';
444 XA START 'trx1ro2';
445 SELECT * from t ORDER BY a;
446 XA END 'trx1ro2';
447 XA PREPARE 'trx1ro2';
448 XA START 'trx2ro2';
449 SELECT * from t ORDER BY a;
450 XA END 'trx2ro2';
451 XA PREPARE 'trx2ro2';
452 XA START 'trx3ro2';
453 SELECT * from t ORDER BY a;
454 XA END 'trx3ro2';
455 XA PREPARE 'trx3ro2';
456 *** 5 prepared transactions must be in the list ***
457 XA RECOVER;
458 formatID gtrid_length bqual_length data
459 1 LEN1 LEN2 TRX_N
460 1 LEN1 LEN2 TRX_N
461 1 LEN1 LEN2 TRX_N
462 1 LEN1 LEN2 TRX_N
463 1 LEN1 LEN2 TRX_N
464 XA ROLLBACK 'trx1ro2';
465 KILL connection CONN_ID;
466 XA ROLLBACK 'trx3ro2';
467 XA START 'trx1empty1';
468 XA END 'trx1empty1';
469 XA PREPARE 'trx1empty1';
470 XA START 'trx2empty1';
471 XA END 'trx2empty1';
472 XA PREPARE 'trx2empty1';
473 XA START 'trx3empty1';
474 XA END 'trx3empty1';
475 XA PREPARE 'trx3empty1';
476 *** 6 prepared transactions must be in the list ***
477 XA RECOVER;
478 formatID gtrid_length bqual_length data
479 1 LEN1 LEN2 TRX_N
480 1 LEN1 LEN2 TRX_N
481 1 LEN1 LEN2 TRX_N
482 1 LEN1 LEN2 TRX_N
483 1 LEN1 LEN2 TRX_N
484 1 LEN1 LEN2 TRX_N
485 XA COMMIT 'trx1empty1';
486 KILL connection CONN_ID;
487 XA COMMIT 'trx3empty1';
488 XA START 'trx1empty2';
489 XA END 'trx1empty2';
490 XA PREPARE 'trx1empty2';
491 XA START 'trx2empty2';
492 XA END 'trx2empty2';
493 XA PREPARE 'trx2empty2';
494 XA START 'trx3empty2';
495 XA END 'trx3empty2';
496 XA PREPARE 'trx3empty2';
497 *** 7 prepared transactions must be in the list ***
498 XA RECOVER;
499 formatID gtrid_length bqual_length data
500 1 LEN1 LEN2 TRX_N
501 1 LEN1 LEN2 TRX_N
502 1 LEN1 LEN2 TRX_N
503 1 LEN1 LEN2 TRX_N
504 1 LEN1 LEN2 TRX_N
505 1 LEN1 LEN2 TRX_N
506 1 LEN1 LEN2 TRX_N
507 XA ROLLBACK 'trx1empty2';
508 KILL connection CONN_ID;
509 XA ROLLBACK 'trx3empty2';
510 XA START 'trx1unprepared';
511 INSERT INTO t set a=0;
512 XA END 'trx1unprepared';
513 INSERT INTO t set a=0;
514 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
515 XA START 'trx1unprepared';
516 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
517 XA START 'trx1unprepared';
518 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state
519 XA COMMIT 'trx1unprepared';
520 ERROR XAE04: XAER_NOTA: Unknown XID
521 SET @@binlog_format = 'STATEMENT';
522 XA START 'trx_0';
523 INSERT INTO t SET a=0;
524 XA END 'trx_0';
525 XA PREPARE 'trx_0';
526 SET @@binlog_format = 'STATEMENT';
527 SET @@binlog_format = 'ROW';
528 XA START 'trx_1';
529 INSERT INTO t SET a=1;
530 XA END 'trx_1';
531 XA PREPARE 'trx_1';
532 SET @@binlog_format = 'STATEMENT';
533 XA START 'trx_2';
534 INSERT INTO t SET a=2;
535 XA END 'trx_2';
536 XA PREPARE 'trx_2';
537 SET @@binlog_format = 'STATEMENT';
538 SET @@binlog_format = 'ROW';
539 XA START 'trx_3';
540 INSERT INTO t SET a=3;
541 XA END 'trx_3';
542 XA PREPARE 'trx_3';
543 SET @@binlog_format = 'STATEMENT';
544 XA START 'trx_4';
545 INSERT INTO t SET a=4;
546 XA END 'trx_4';
547 XA PREPARE 'trx_4';
548 SET @@binlog_format = 'STATEMENT';
549 SET @@binlog_format = 'ROW';
550 XA START 'trx_5';
551 INSERT INTO t SET a=5;
552 XA END 'trx_5';
553 XA PREPARE 'trx_5';
554 SET @@binlog_format = 'STATEMENT';
555 XA START 'trx_6';
556 INSERT INTO t SET a=6;
557 XA END 'trx_6';
558 XA PREPARE 'trx_6';
559 SET @@binlog_format = 'STATEMENT';
560 SET @@binlog_format = 'ROW';
561 XA START 'trx_7';
562 INSERT INTO t SET a=7;
563 XA END 'trx_7';
564 XA PREPARE 'trx_7';
565 SET @@binlog_format = 'STATEMENT';
566 XA START 'trx_8';
567 INSERT INTO t SET a=8;
568 XA END 'trx_8';
569 XA PREPARE 'trx_8';
570 SET @@binlog_format = 'STATEMENT';
571 SET @@binlog_format = 'ROW';
572 XA START 'trx_9';
573 INSERT INTO t SET a=9;
574 XA END 'trx_9';
575 XA PREPARE 'trx_9';
576 SET @@binlog_format = 'STATEMENT';
577 XA START 'trx_10';
578 INSERT INTO t SET a=10;
579 XA END 'trx_10';
580 XA PREPARE 'trx_10';
581 SET @@binlog_format = 'STATEMENT';
582 SET @@binlog_format = 'ROW';
583 XA START 'trx_11';
584 INSERT INTO t SET a=11;
585 XA END 'trx_11';
586 XA PREPARE 'trx_11';
587 SET @@binlog_format = 'STATEMENT';
588 XA START 'trx_12';
589 INSERT INTO t SET a=12;
590 XA END 'trx_12';
591 XA PREPARE 'trx_12';
592 SET @@binlog_format = 'STATEMENT';
593 SET @@binlog_format = 'ROW';
594 XA START 'trx_13';
595 INSERT INTO t SET a=13;
596 XA END 'trx_13';
597 XA PREPARE 'trx_13';
598 SET @@binlog_format = 'STATEMENT';
599 XA START 'trx_14';
600 INSERT INTO t SET a=14;
601 XA END 'trx_14';
602 XA PREPARE 'trx_14';
603 SET @@binlog_format = 'STATEMENT';
604 SET @@binlog_format = 'ROW';
605 XA START 'trx_15';
606 INSERT INTO t SET a=15;
607 XA END 'trx_15';
608 XA PREPARE 'trx_15';
609 KILL CONNECTION CONN_ID;
610 SET @@binlog_format = 'STATEMENT';
611 XA START 'trx_16';
612 INSERT INTO t SET a=16;
613 XA END 'trx_16';
614 XA PREPARE 'trx_16';
615 KILL CONNECTION CONN_ID;
616 SET @@binlog_format = 'STATEMENT';
617 SET @@binlog_format = 'ROW';
618 XA START 'trx_17';
619 INSERT INTO t SET a=17;
620 XA END 'trx_17';
621 XA PREPARE 'trx_17';
622 KILL CONNECTION CONN_ID;
623 SET @@binlog_format = 'STATEMENT';
624 XA START 'trx_18';
625 INSERT INTO t SET a=18;
626 XA END 'trx_18';
627 XA PREPARE 'trx_18';
628 KILL CONNECTION CONN_ID;
629 SET @@binlog_format = 'STATEMENT';
630 SET @@binlog_format = 'ROW';
631 XA START 'trx_19';
632 INSERT INTO t SET a=19;
633 XA END 'trx_19';
634 XA PREPARE 'trx_19';
635 KILL CONNECTION CONN_ID;
636 XA ROLLBACK 'trx_0';
637 XA ROLLBACK 'trx_1';
638 XA ROLLBACK 'trx_2';
639 XA ROLLBACK 'trx_3';
640 XA ROLLBACK 'trx_4';
641 XA COMMIT 'trx_5';
642 XA COMMIT 'trx_6';
643 XA COMMIT 'trx_7';
644 XA COMMIT 'trx_8';
645 XA COMMIT 'trx_9';
646 # Kill and restart
647 XA START 'new_trx_0';
648 INSERT INTO t SET a=0;
649 XA END 'new_trx_0';
650 XA PREPARE 'new_trx_0';
651 XA START 'new_trx_1';
652 INSERT INTO t SET a=1;
653 XA END 'new_trx_1';
654 XA PREPARE 'new_trx_1';
655 XA START 'new_trx_2';
656 INSERT INTO t SET a=2;
657 XA END 'new_trx_2';
658 XA PREPARE 'new_trx_2';
659 XA START 'new_trx_3';
660 INSERT INTO t SET a=3;
661 XA END 'new_trx_3';
662 XA PREPARE 'new_trx_3';
663 XA START 'new_trx_4';
664 INSERT INTO t SET a=4;
665 XA END 'new_trx_4';
666 XA PREPARE 'new_trx_4';
667 XA START 'new_trx_5';
668 INSERT INTO t SET a=5;
669 XA END 'new_trx_5';
670 XA PREPARE 'new_trx_5';
671 XA START 'new_trx_6';
672 INSERT INTO t SET a=6;
673 XA END 'new_trx_6';
674 XA PREPARE 'new_trx_6';
675 XA START 'new_trx_7';
676 INSERT INTO t SET a=7;
677 XA END 'new_trx_7';
678 XA PREPARE 'new_trx_7';
679 XA START 'new_trx_8';
680 INSERT INTO t SET a=8;
681 XA END 'new_trx_8';
682 XA PREPARE 'new_trx_8';
683 XA START 'new_trx_9';
684 INSERT INTO t SET a=9;
685 XA END 'new_trx_9';
686 XA PREPARE 'new_trx_9';
687 XA COMMIT 'new_trx_0';
688 XA COMMIT 'new_trx_1';
689 XA COMMIT 'new_trx_2';
690 XA COMMIT 'new_trx_3';
691 XA COMMIT 'new_trx_4';
692 XA COMMIT 'new_trx_5';
693 XA COMMIT 'new_trx_6';
694 XA COMMIT 'new_trx_7';
695 XA COMMIT 'new_trx_8';
696 XA COMMIT 'new_trx_9';
697 XA START 'trx_10';
698 ERROR XAE08: XAER_DUPID: The XID already exists
699 XA COMMIT 'trx_10';
700 XA START 'trx_11';
701 ERROR XAE08: XAER_DUPID: The XID already exists
702 XA COMMIT 'trx_11';
703 XA START 'trx_12';
704 ERROR XAE08: XAER_DUPID: The XID already exists
705 XA COMMIT 'trx_12';
706 XA START 'trx_13';
707 ERROR XAE08: XAER_DUPID: The XID already exists
708 XA COMMIT 'trx_13';
709 XA START 'trx_14';
710 ERROR XAE08: XAER_DUPID: The XID already exists
711 XA COMMIT 'trx_14';
712 XA START 'trx_15';
713 ERROR XAE08: XAER_DUPID: The XID already exists
714 XA ROLLBACK 'trx_15';
715 XA START 'trx_16';
716 ERROR XAE08: XAER_DUPID: The XID already exists
717 XA ROLLBACK 'trx_16';
718 XA START 'trx_17';
719 ERROR XAE08: XAER_DUPID: The XID already exists
720 XA ROLLBACK 'trx_17';
721 XA START 'trx_18';
722 ERROR XAE08: XAER_DUPID: The XID already exists
723 XA ROLLBACK 'trx_18';
724 XA START 'trx_19';
725 ERROR XAE08: XAER_DUPID: The XID already exists
726 XA ROLLBACK 'trx_19';
727 SELECT * FROM t;
728 a
729 5
730 6
731 7
732 8
733 9
734 10
735 11
736 12
737 13
738 14
739 0
740 1
741 2
742 3
743 4
744 5
745 6
746 7
747 8
748 9
749 5
750 6
751 7
752 8
753 9
754 10
755 11
756 12
757 13
758 14
759 0
760 1
761 2
762 3
763 4
764 5
765 6
766 7
767 8
768 9
769 XA ROLLBACK 'trx_20';
770 ERROR XAE04: XAER_NOTA: Unknown XID
771 XA ROLLBACK 'trx_19';
772 ERROR XAE04: XAER_NOTA: Unknown XID
773 XA ROLLBACK 'trx_18';
774 ERROR XAE04: XAER_NOTA: Unknown XID
775 XA ROLLBACK 'trx_17';
776 ERROR XAE04: XAER_NOTA: Unknown XID
777 XA ROLLBACK 'trx_16';
778 ERROR XAE04: XAER_NOTA: Unknown XID
779 XA ROLLBACK 'trx_15';
780 ERROR XAE04: XAER_NOTA: Unknown XID
781 XA ROLLBACK 'trx_14';
782 ERROR XAE04: XAER_NOTA: Unknown XID
783 XA ROLLBACK 'trx_13';
784 ERROR XAE04: XAER_NOTA: Unknown XID
785 XA ROLLBACK 'trx_12';
786 ERROR XAE04: XAER_NOTA: Unknown XID
787 XA ROLLBACK 'trx_11';
788 ERROR XAE04: XAER_NOTA: Unknown XID
789 XA START 'one_phase_trx_0';
790 INSERT INTO t SET a=0;
791 XA END 'one_phase_trx_0';
792 XA COMMIT 'one_phase_trx_0' ONE PHASE;
793 XA START 'one_phase_trx_1';
794 INSERT INTO t SET a=1;
795 XA END 'one_phase_trx_1';
796 XA COMMIT 'one_phase_trx_1' ONE PHASE;
797 XA START 'one_phase_trx_2';
798 INSERT INTO t SET a=2;
799 XA END 'one_phase_trx_2';
800 XA COMMIT 'one_phase_trx_2' ONE PHASE;
801 XA START 'one_phase_trx_3';
802 INSERT INTO t SET a=3;
803 XA END 'one_phase_trx_3';
804 XA COMMIT 'one_phase_trx_3' ONE PHASE;
805 XA START 'one_phase_trx_4';
806 INSERT INTO t SET a=4;
807 XA END 'one_phase_trx_4';
808 XA COMMIT 'one_phase_trx_4' ONE PHASE;
809 DROP TABLE t;
810 DROP VIEW v_processlist;
811 include/show_binlog_events.inc
812 Log_name Pos Event_type Server_id End_log_pos Info
813 binlog.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'
814 binlog.000001 # Query # # BEGIN
815 binlog.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Found 10 prepared XA transactions' COLLATE 'utf8mb4_0900_ai_ci'))
816 binlog.000001 # Xid # # COMMIT /* XID */
817 binlog.000001 # Query # # BEGIN
818 binlog.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Found 1 prepared XA transactions' COLLATE 'utf8mb4_0900_ai_ci'))
819 binlog.000001 # Xid # # COMMIT /* XID */
820 binlog.000001 # Query # # use `test`; CREATE TABLE t (a INT) ENGINE=innodb
821 binlog.000001 # Query # # XA START X'7472785f30',X'',1
822 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=0
823 binlog.000001 # Query # # XA END X'7472785f30',X'',1
824 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f30',X'',1
825 binlog.000001 # Query # # XA START X'7472785f31',X'',1
826 binlog.000001 # Table_map # # table_id: # (test.t)
827 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
828 binlog.000001 # Query # # XA END X'7472785f31',X'',1
829 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f31',X'',1
830 binlog.000001 # Query # # XA START X'7472785f32',X'',1
831 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=2
832 binlog.000001 # Query # # XA END X'7472785f32',X'',1
833 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f32',X'',1
834 binlog.000001 # Query # # XA START X'7472785f33',X'',1
835 binlog.000001 # Table_map # # table_id: # (test.t)
836 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
837 binlog.000001 # Query # # XA END X'7472785f33',X'',1
838 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f33',X'',1
839 binlog.000001 # Query # # XA START X'7472785f34',X'',1
840 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=4
841 binlog.000001 # Query # # XA END X'7472785f34',X'',1
842 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f34',X'',1
843 binlog.000001 # Query # # XA START X'7472785f35',X'',1
844 binlog.000001 # Table_map # # table_id: # (test.t)
845 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
846 binlog.000001 # Query # # XA END X'7472785f35',X'',1
847 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f35',X'',1
848 binlog.000001 # Query # # XA START X'7472785f36',X'',1
849 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=6
850 binlog.000001 # Query # # XA END X'7472785f36',X'',1
851 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f36',X'',1
852 binlog.000001 # Query # # XA START X'7472785f37',X'',1
853 binlog.000001 # Table_map # # table_id: # (test.t)
854 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
855 binlog.000001 # Query # # XA END X'7472785f37',X'',1
856 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f37',X'',1
857 binlog.000001 # Query # # XA START X'7472785f38',X'',1
858 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=8
859 binlog.000001 # Query # # XA END X'7472785f38',X'',1
860 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f38',X'',1
861 binlog.000001 # Query # # XA START X'7472785f39',X'',1
862 binlog.000001 # Table_map # # table_id: # (test.t)
863 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
864 binlog.000001 # Query # # XA END X'7472785f39',X'',1
865 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f39',X'',1
866 binlog.000001 # Query # # XA START X'7472785f3130',X'',1
867 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=10
868 binlog.000001 # Query # # XA END X'7472785f3130',X'',1
869 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3130',X'',1
870 binlog.000001 # Query # # XA START X'7472785f3131',X'',1
871 binlog.000001 # Table_map # # table_id: # (test.t)
872 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
873 binlog.000001 # Query # # XA END X'7472785f3131',X'',1
874 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3131',X'',1
875 binlog.000001 # Query # # XA START X'7472785f3132',X'',1
876 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=12
877 binlog.000001 # Query # # XA END X'7472785f3132',X'',1
878 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3132',X'',1
879 binlog.000001 # Query # # XA START X'7472785f3133',X'',1
880 binlog.000001 # Table_map # # table_id: # (test.t)
881 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
882 binlog.000001 # Query # # XA END X'7472785f3133',X'',1
883 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3133',X'',1
884 binlog.000001 # Query # # XA START X'7472785f3134',X'',1
885 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=14
886 binlog.000001 # Query # # XA END X'7472785f3134',X'',1
887 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3134',X'',1
888 binlog.000001 # Query # # XA START X'7472785f3135',X'',1
889 binlog.000001 # Table_map # # table_id: # (test.t)
890 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
891 binlog.000001 # Query # # XA END X'7472785f3135',X'',1
892 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3135',X'',1
893 binlog.000001 # Query # # XA START X'7472785f3136',X'',1
894 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=16
895 binlog.000001 # Query # # XA END X'7472785f3136',X'',1
896 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3136',X'',1
897 binlog.000001 # Query # # XA START X'7472785f3137',X'',1
898 binlog.000001 # Table_map # # table_id: # (test.t)
899 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
900 binlog.000001 # Query # # XA END X'7472785f3137',X'',1
901 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3137',X'',1
902 binlog.000001 # Query # # XA START X'7472785f3138',X'',1
903 binlog.000001 # Query # # use `test`; INSERT INTO t SET a=18
904 binlog.000001 # Query # # XA END X'7472785f3138',X'',1
905 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3138',X'',1
906 binlog.000001 # Query # # XA START X'7472785f3139',X'',1
907 binlog.000001 # Table_map # # table_id: # (test.t)
908 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
909 binlog.000001 # Query # # XA END X'7472785f3139',X'',1
910 binlog.000001 # XA_prepare # # XA PREPARE X'7472785f3139',X'',1
911 binlog.000001 # Query # # XA ROLLBACK X'7472785f30',X'',1
912 binlog.000001 # Query # # XA ROLLBACK X'7472785f31',X'',1
913 binlog.000001 # Query # # XA ROLLBACK X'7472785f32',X'',1
914 binlog.000001 # Query # # XA ROLLBACK X'7472785f33',X'',1
915 binlog.000001 # Query # # XA ROLLBACK X'7472785f34',X'',1
916 binlog.000001 # Query # # XA COMMIT X'7472785f35',X'',1
917 binlog.000001 # Query # # XA COMMIT X'7472785f36',X'',1
918 binlog.000001 # Query # # XA COMMIT X'7472785f37',X'',1
919 binlog.000001 # Query # # XA COMMIT X'7472785f38',X'',1
920 binlog.000001 # Query # # XA COMMIT X'7472785f39',X'',1
921 binlog.000001 # Stop # #
922 include/assert.inc [committed gno 131]
923 RESET MASTER;
924 include/assert.inc [committed gno 131]
925 All transactions must be completed, to empty-list the following:
926 XA RECOVER;
927 formatID gtrid_length bqual_length data
928 CREATE TABLE t(a INT);
929 XA START 'xa1';
930 INSERT INTO t SET a = 1;
931 XA END 'xa1';
932 SET @@SESSION.pseudo_replica_mode=1;
933 ERROR HY000: The system variable pseudo_replica_mode cannot be set when there is an ongoing transaction.
934 XA PREPARE 'xa1';
935 # restart
936 XA ROLLBACK 'xa1';
937 XA START 'xa1';
938 INSERT INTO t SET a = 1;
939 XA END 'xa1';
940 XA PREPARE 'xa1';
941 SET @@SESSION.pseudo_replica_mode=1;
942 ERROR HY000: The system variable pseudo_replica_mode cannot be set when there is an ongoing transaction.
943 XA COMMIT 'xa1';
944 DROP TABLE t;
945 include/gtid_utils_end.inc