Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_xa_multiple_failures.result

raw
1 include/only_with_option.inc [GLOBAL.binlog_order_commits = 1]
2 include/suppress_messages.inc
3 # Connection 1 suppresses message <Found .* prepared XA transactions>.
4 # Connection 1 suppresses message <.*Checksum mismatch in datafile.*>.
5 CREATE TABLE t1 (c1 INT PRIMARY KEY);
6 XA START 'xid0';
7 INSERT INTO t1 VALUES (2);
8 XA END 'xid0';
9 XA PREPARE 'xid0';
10 XA COMMIT 'xid0';
11 include/save_binlog_position.inc
12 XA START 'xid1';
13 INSERT INTO t1 VALUES (3);
14 XA END 'xid1';
15 include/execute_to_conditional_timestamp_sync_point.inc [before_prepare_in_engines]
16 XA PREPARE 'xid1';
17 XA START 'xid2';
18 INSERT INTO t1 VALUES (4);
19 XA END 'xid2';
20 include/execute_to_conditional_timestamp_sync_point.inc [after_ha_prepare_low]
21 XA PREPARE 'xid2';
22 XA START 'xid3';
23 INSERT INTO t1 VALUES (5);
24 XA END 'xid3';
25 include/execute_to_conditional_timestamp_sync_point.inc [before_set_prepared_in_tc]
26 XA PREPARE 'xid3';
27 XA START 'xid4';
28 INSERT INTO t1 VALUES (6);
29 XA END 'xid4';
30 include/execute_to_conditional_timestamp_sync_point.inc [after_writing_to_tc_log]
31 XA PREPARE 'xid4';
32 # Kill the server
33 # restart
34 include/assert.inc [Found log message(s) for "Rolling back trx with id %, 1 rows to undo"]
35 include/assert.inc [Found 1 log message(s) for "Successfully rolled back 1, prepared 2 XA transaction"]
36 include/assert.inc [2 XA transaction(s) in PREPARED state]
37 XA ROLLBACK 'xid3';
38 XA ROLLBACK 'xid4';
39 XA START 'xid5';
40 INSERT INTO t1 VALUES (7);
41 XA END 'xid5';
42 XA PREPARE 'xid5';
43 include/execute_to_conditional_timestamp_sync_point.inc [before_commit_xa_trx]
44 XA COMMIT 'xid5';
45 XA START 'xid6';
46 INSERT INTO t1 VALUES (8);
47 XA END 'xid6';
48 XA PREPARE 'xid6';
49 include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook]
50 XA COMMIT 'xid6';
51 XA START 'xid7';
52 INSERT INTO t1 VALUES (9);
53 XA END 'xid7';
54 XA PREPARE 'xid7';
55 include/execute_to_conditional_timestamp_sync_point.inc [before_commit_in_engines]
56 XA COMMIT 'xid7';
57 # Kill the server
58 # restart
59 include/assert.inc [Found 1 log message(s) for "Successfully committed 1, prepared 2 XA transaction"]
60 include/assert.inc [2 XA transaction(s) in PREPARED state]
61 XA ROLLBACK 'xid5';
62 XA ROLLBACK 'xid6';
63 XA START 'xid8';
64 INSERT INTO t1 VALUES (10);
65 XA END 'xid8';
66 XA PREPARE 'xid8';
67 include/execute_to_conditional_timestamp_sync_point.inc [before_rollback_xa_trx]
68 XA ROLLBACK 'xid8';
69 XA START 'xid9';
70 INSERT INTO t1 VALUES (11);
71 XA END 'xid9';
72 XA PREPARE 'xid9';
73 include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook]
74 XA ROLLBACK 'xid9';
75 XA START 'xid10';
76 INSERT INTO t1 VALUES (12);
77 XA END 'xid10';
78 XA PREPARE 'xid10';
79 include/execute_to_conditional_timestamp_sync_point.inc [before_rollback_in_engines]
80 XA ROLLBACK 'xid10';
81 # Kill the server
82 # restart
83 include/assert.inc [Found 1 log message(s) for "Successfully rolled back 1, prepared 2 XA transaction"]
84 include/assert.inc [2 XA transaction(s) in PREPARED state]
85 XA ROLLBACK 'xid8';
86 XA ROLLBACK 'xid9';
87 XA START 'xid11';
88 INSERT INTO t1 VALUES (13);
89 XA END 'xid11';
90 include/execute_to_conditional_timestamp_sync_point.inc [before_prepare_in_engines]
91 XA COMMIT 'xid11' ONE PHASE;
92 XA START 'xid12';
93 INSERT INTO t1 VALUES (14);
94 XA END 'xid12';
95 include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook]
96 XA COMMIT 'xid12' ONE PHASE;
97 XA START 'xid13';
98 INSERT INTO t1 VALUES (15);
99 XA END 'xid13';
100 include/execute_to_conditional_timestamp_sync_point.inc [before_commit_in_engines]
101 XA COMMIT 'xid13' ONE PHASE;
102 # Kill the server
103 # restart
104 include/assert.inc [Found log message(s) for "Rolling back trx with id %, 1 rows to undo"]
105 include/assert.inc [Found 1 log message(s) for "Successfully committed 1, rolled back 1 XA transaction"]
106 include/assert.inc [No XA transactions in PREPARED state]
107 DROP TABLE t1;