Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_xa_multiple_failures.result

raw
1 include/only_with_option.inc [GLOBAL.replica_parallel_type = 'LOGICAL_CLOCK']
2 include/only_with_option.inc [GLOBAL.replica_parallel_workers != 0]
3 include/only_with_option.inc [GLOBAL.binlog_order_commits = 1]
4 include/master-slave.inc
5 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
8 [connection master]
9 [connection slave]
10 include/save_sysvars.inc [
11 "GLOBAL.replica_preserve_commit_order",
12 "GLOBAL.replica_parallel_workers"
13 ]
14 SET @@GLOBAL.replica_preserve_commit_order = 0;
15 SET @@GLOBAL.replica_parallel_workers = 4;
16 include/start_slave.inc
17 [connection master]
18 include/suppress_messages.inc
19 # Connection 1 suppresses message <Found .* prepared XA transactions>.
20 # Connection 1 suppresses message <.*Checksum mismatch in datafile.*>.
21 # Connection 2 suppresses message <Found .* prepared XA transactions>.
22 # Connection 2 suppresses message <.*Checksum mismatch in datafile.*>.
23 CREATE TABLE t1 (c1 INT PRIMARY KEY);
24 XA START 'xid0';
25 INSERT INTO t1 VALUES (2);
26 XA END 'xid0';
27 XA PREPARE 'xid0';
28 XA COMMIT 'xid0';
29 include/sync_slave_sql_with_master.inc
30 include/save_binlog_position.inc
31 [connection master]
32 # Adding debug point 'set_commit_parent_100' to @@GLOBAL.debug
33 XA START 'xid1';
34 INSERT INTO t1 VALUES (3);
35 XA END 'xid1';
36 include/execute_to_conditional_timestamp_sync_point.inc [before_prepare_in_engines]
37 XA PREPARE 'xid1';
38 XA START 'xid2';
39 INSERT INTO t1 VALUES (4);
40 XA END 'xid2';
41 include/execute_to_conditional_timestamp_sync_point.inc [after_ha_prepare_low]
42 XA PREPARE 'xid2';
43 XA START 'xid3';
44 INSERT INTO t1 VALUES (5);
45 XA END 'xid3';
46 include/execute_to_conditional_timestamp_sync_point.inc [before_set_prepared_in_tc]
47 XA PREPARE 'xid3';
48 XA START 'xid4';
49 INSERT INTO t1 VALUES (6);
50 XA END 'xid4';
51 include/execute_to_conditional_timestamp_sync_point.inc [after_writing_to_tc_log]
52 XA PREPARE 'xid4';
53 [connection slave]
54 # Kill the server
55 # restart:--replica-preserve-commit-order=0
56 include/rpl_reconnect.inc
57 include/assert.inc [Found log message(s) for "Rolling back trx with id %, 1 rows to undo"]
58 include/assert.inc [Found 1 log message(s) for "Successfully rolled back 1, prepared 2 XA transaction"]
59 include/assert.inc [2 XA transaction(s) in PREPARED state]
60 include/start_slave.inc
61 [connection master]
62 include/sync_slave_sql_with_master.inc
63 [connection master]
64 XA ROLLBACK 'xid1';
65 XA ROLLBACK 'xid2';
66 XA ROLLBACK 'xid3';
67 XA ROLLBACK 'xid4';
68 include/sync_slave_sql_with_master.inc
69 [connection master]
70 XA START 'xid5';
71 INSERT INTO t1 VALUES (7);
72 XA END 'xid5';
73 XA PREPARE 'xid5';
74 XA START 'xid6';
75 INSERT INTO t1 VALUES (8);
76 XA END 'xid6';
77 XA PREPARE 'xid6';
78 XA START 'xid7';
79 INSERT INTO t1 VALUES (9);
80 XA END 'xid7';
81 XA PREPARE 'xid7';
82 include/sync_slave_sql_with_master.inc
83 include/execute_to_conditional_timestamp_sync_point.inc [before_commit_xa_trx]
84 XA COMMIT 'xid5';
85 include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook]
86 XA COMMIT 'xid6';
87 include/execute_to_conditional_timestamp_sync_point.inc [before_commit_in_engines]
88 XA COMMIT 'xid7';
89 [connection slave]
90 # Kill the server
91 # restart:--replica-preserve-commit-order=0
92 include/rpl_reconnect.inc
93 include/assert.inc [Found 1 log message(s) for "Successfully committed 1, prepared 2 XA transaction"]
94 include/assert.inc [2 XA transaction(s) in PREPARED state]
95 include/start_slave.inc
96 [connection master]
97 include/sync_slave_sql_with_master.inc
98 XA START 'xid8';
99 INSERT INTO t1 VALUES (10);
100 XA END 'xid8';
101 XA PREPARE 'xid8';
102 XA START 'xid9';
103 INSERT INTO t1 VALUES (11);
104 XA END 'xid9';
105 XA PREPARE 'xid9';
106 XA START 'xid10';
107 INSERT INTO t1 VALUES (12);
108 XA END 'xid10';
109 XA PREPARE 'xid10';
110 include/sync_slave_sql_with_master.inc
111 include/execute_to_conditional_timestamp_sync_point.inc [before_rollback_xa_trx]
112 XA ROLLBACK 'xid8';
113 include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook]
114 XA ROLLBACK 'xid9';
115 include/execute_to_conditional_timestamp_sync_point.inc [before_rollback_in_engines]
116 XA ROLLBACK 'xid10';
117 [connection slave]
118 # Kill the server
119 # restart:--replica-preserve-commit-order=0
120 include/rpl_reconnect.inc
121 include/assert.inc [Found 1 log message(s) for "Successfully rolled back 1, prepared 2 XA transaction"]
122 include/assert.inc [2 XA transaction(s) in PREPARED state]
123 include/start_slave.inc
124 [connection master]
125 UPDATE t1 SET c1 = 200 WHERE c1 = 2;
126 include/sync_slave_sql_with_master.inc
127 XA START 'xid11';
128 INSERT INTO t1 VALUES (13);
129 XA END 'xid11';
130 include/execute_to_conditional_timestamp_sync_point.inc [before_prepare_in_engines]
131 XA COMMIT 'xid11' ONE PHASE;
132 XA START 'xid12';
133 INSERT INTO t1 VALUES (14);
134 XA END 'xid12';
135 include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook]
136 XA COMMIT 'xid12' ONE PHASE;
137 XA START 'xid13';
138 INSERT INTO t1 VALUES (15);
139 XA END 'xid13';
140 include/execute_to_conditional_timestamp_sync_point.inc [before_commit_in_engines]
141 XA COMMIT 'xid13' ONE PHASE;
142 [connection slave]
143 # Kill the server
144 # restart:--replica-preserve-commit-order=0
145 include/rpl_reconnect.inc
146 include/assert.inc [Found log message(s) for "Rolling back trx with id %, 1 rows to undo"]
147 include/assert.inc [Found 1 log message(s) for "Successfully committed 1, rolled back 1 XA transaction"]
148 include/assert.inc [No XA transactions in PREPARED state]
149 include/restore_sysvars.inc
150 include/start_slave.inc
151 [connection master]
152 # Removing debug point 'set_commit_parent_100' from @@GLOBAL.debug
153 DROP TABLE t1;
154 include/rpl_end.inc