Debian Codegraph @

mysql-test/suite/rpl/r/rpl_xa_survive_disconnect_lsu_off.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 call mtr.add_suppression("Found 2 prepared XA transactions");
5 CREATE VIEW v_processlist as SELECT * FROM performance_schema.threads where type = 'FOREGROUND';
6 CREATE DATABASE d1;
7 CREATE DATABASE d2;
8 CREATE TABLE d1.t (a INT) ENGINE=innodb;
9 CREATE TABLE d2.t (a INT) ENGINE=innodb;
10 INSERT INTO d1.t VALUES(100);
11 connect master_conn1, 127.0.0.1,root,,test,$MASTER_MYPORT,;
12 SET @@session.binlog_format= statement;
13 XA START '1-stmt';
14 INSERT INTO d1.t VALUES (1);
15 XA END '1-stmt';
16 XA PREPARE '1-stmt';
17 disconnect master_conn1;
18 connection master;
19 connect master_conn2, 127.0.0.1,root,,test,$MASTER_MYPORT,;
20 SET @@session.binlog_format= row;
21 XA START '1-row';
22 INSERT INTO d2.t VALUES (1);
23 XA END '1-row';
24 XA PREPARE '1-row';
25 disconnect master_conn2;
26 connection master;
27 XA START '2';
28 INSERT INTO d1.t VALUES (2);
29 XA END '2';
30 XA PREPARE '2';
31 XA COMMIT '2';
32 XA COMMIT '1-row';
33 XA COMMIT '1-stmt';
34 include/show_binlog_events.inc
35 Log_name Pos Event_type Server_id End_log_pos Info
36 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
37 master-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Found 2 prepared XA transactions' COLLATE 'utf8mb4_uca1400_ai_ci'))
38 master-bin.000001 # Query # # COMMIT
39 master-bin.000001 # Gtid # # GTID #-#-#
40 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'
41 master-bin.000001 # Gtid # # GTID #-#-#
42 master-bin.000001 # Query # # CREATE DATABASE d1
43 master-bin.000001 # Gtid # # GTID #-#-#
44 master-bin.000001 # Query # # CREATE DATABASE d2
45 master-bin.000001 # Gtid # # GTID #-#-#
46 master-bin.000001 # Query # # use `test`; CREATE TABLE d1.t (a INT) ENGINE=innodb
47 master-bin.000001 # Gtid # # GTID #-#-#
48 master-bin.000001 # Query # # use `test`; CREATE TABLE d2.t (a INT) ENGINE=innodb
49 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
50 master-bin.000001 # Query # # use `test`; INSERT INTO d1.t VALUES(100)
51 master-bin.000001 # Xid # # COMMIT /* XID */
52 master-bin.000001 # Gtid # # XA START X'312d73746d74',X'',1 GTID #-#-#
53 master-bin.000001 # Query # # use `test`; INSERT INTO d1.t VALUES (1)
54 master-bin.000001 # Query # # XA END X'312d73746d74',X'',1
55 master-bin.000001 # XA_prepare # # XA PREPARE X'312d73746d74',X'',1
56 master-bin.000001 # Gtid # # XA START X'312d726f77',X'',1 GTID #-#-#
57 master-bin.000001 # Annotate_rows # # INSERT INTO d2.t VALUES (1)
58 master-bin.000001 # Table_map # # table_id: # (d2.t)
59 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
60 master-bin.000001 # Query # # XA END X'312d726f77',X'',1
61 master-bin.000001 # XA_prepare # # XA PREPARE X'312d726f77',X'',1
62 master-bin.000001 # Gtid # # XA START X'32',X'',1 GTID #-#-#
63 master-bin.000001 # Query # # use `test`; INSERT INTO d1.t VALUES (2)
64 master-bin.000001 # Query # # XA END X'32',X'',1
65 master-bin.000001 # XA_prepare # # XA PREPARE X'32',X'',1
66 master-bin.000001 # Gtid # # GTID #-#-#
67 master-bin.000001 # Query # # XA COMMIT X'32',X'',1
68 master-bin.000001 # Gtid # # GTID #-#-#
69 master-bin.000001 # Query # # XA COMMIT X'312d726f77',X'',1
70 master-bin.000001 # Gtid # # GTID #-#-#
71 master-bin.000001 # Query # # XA COMMIT X'312d73746d74',X'',1
72 include/sync_slave_sql_with_master.inc
73 include/stop_slave.inc
74 connection master;
75 connect master2, 127.0.0.1,root,,test,$MASTER_MYPORT,;
76 connection master2;
77 SET @@session.binlog_format= statement;
78 XA START '3-stmt';
79 INSERT INTO d1.t VALUES (3);
80 XA END '3-stmt';
81 XA PREPARE '3-stmt';
82 disconnect master2;
83 connect master2, 127.0.0.1,root,,test,$MASTER_MYPORT,;
84 connection master2;
85 SET @@session.binlog_format= row;
86 XA START '3-row';
87 INSERT INTO d2.t VALUES (4);
88 XA END '3-row';
89 XA PREPARE '3-row';
90 disconnect master2;
91 connection master;
92 connect master2, 127.0.0.1,root,,test,$MASTER_MYPORT,;
93 connection master2;
94 XA START '4';
95 SELECT * FROM d1.t;
96 a
97 100
98 1
99 2
100 XA END '4';
101 XA PREPARE '4';
102 disconnect master2;
103 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
104 XA START 'bulk_trx_10';
105 INSERT INTO d1.t VALUES (10);
106 INSERT INTO d2.t VALUES (10);
107 XA END 'bulk_trx_10';
108 XA PREPARE 'bulk_trx_10';
109 disconnect master_bulk_conn10;
110 connection master;
111 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
112 XA START 'bulk_trx_9';
113 INSERT INTO d1.t VALUES (9);
114 INSERT INTO d2.t VALUES (9);
115 XA END 'bulk_trx_9';
116 XA PREPARE 'bulk_trx_9';
117 disconnect master_bulk_conn9;
118 connection master;
119 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
120 XA START 'bulk_trx_8';
121 INSERT INTO d1.t VALUES (8);
122 INSERT INTO d2.t VALUES (8);
123 XA END 'bulk_trx_8';
124 XA PREPARE 'bulk_trx_8';
125 disconnect master_bulk_conn8;
126 connection master;
127 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
128 XA START 'bulk_trx_7';
129 INSERT INTO d1.t VALUES (7);
130 INSERT INTO d2.t VALUES (7);
131 XA END 'bulk_trx_7';
132 XA PREPARE 'bulk_trx_7';
133 disconnect master_bulk_conn7;
134 connection master;
135 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
136 XA START 'bulk_trx_6';
137 INSERT INTO d1.t VALUES (6);
138 INSERT INTO d2.t VALUES (6);
139 XA END 'bulk_trx_6';
140 XA PREPARE 'bulk_trx_6';
141 disconnect master_bulk_conn6;
142 connection master;
143 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
144 XA START 'bulk_trx_5';
145 INSERT INTO d1.t VALUES (5);
146 INSERT INTO d2.t VALUES (5);
147 XA END 'bulk_trx_5';
148 XA PREPARE 'bulk_trx_5';
149 disconnect master_bulk_conn5;
150 connection master;
151 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
152 XA START 'bulk_trx_4';
153 INSERT INTO d1.t VALUES (4);
154 INSERT INTO d2.t VALUES (4);
155 XA END 'bulk_trx_4';
156 XA PREPARE 'bulk_trx_4';
157 disconnect master_bulk_conn4;
158 connection master;
159 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
160 XA START 'bulk_trx_3';
161 INSERT INTO d1.t VALUES (3);
162 INSERT INTO d2.t VALUES (3);
163 XA END 'bulk_trx_3';
164 XA PREPARE 'bulk_trx_3';
165 disconnect master_bulk_conn3;
166 connection master;
167 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
168 XA START 'bulk_trx_2';
169 INSERT INTO d1.t VALUES (2);
170 INSERT INTO d2.t VALUES (2);
171 XA END 'bulk_trx_2';
172 XA PREPARE 'bulk_trx_2';
173 disconnect master_bulk_conn2;
174 connection master;
175 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
176 XA START 'bulk_trx_1';
177 INSERT INTO d1.t VALUES (1);
178 INSERT INTO d2.t VALUES (1);
179 XA END 'bulk_trx_1';
180 XA PREPARE 'bulk_trx_1';
181 disconnect master_bulk_conn1;
182 connection master;
183 connection slave;
184 include/start_slave.inc
185 connection master;
186 include/sync_slave_sql_with_master.inc
187 include/stop_slave.inc
188 connection master;
189 XA COMMIT 'bulk_trx_10';
190 XA ROLLBACK 'bulk_trx_9';
191 XA COMMIT 'bulk_trx_8';
192 XA ROLLBACK 'bulk_trx_7';
193 XA COMMIT 'bulk_trx_6';
194 XA ROLLBACK 'bulk_trx_5';
195 XA COMMIT 'bulk_trx_4';
196 XA ROLLBACK 'bulk_trx_3';
197 XA COMMIT 'bulk_trx_2';
198 XA ROLLBACK 'bulk_trx_1';
199 include/rpl_restart_server.inc [server_number=1]
200 connection slave;
201 include/start_slave.inc
202 connection master;
203 *** '3-stmt','3-row' xa-transactions must be in the list ***
204 XA RECOVER;
205 formatID gtrid_length bqual_length data
206 1 6 0 3-stmt
207 1 5 0 3-row
208 XA COMMIT '3-stmt';
209 XA ROLLBACK '3-row';
210 include/sync_slave_sql_with_master.inc
211 connection master;
212 connect master_conn2, 127.0.0.1,root,,test,$MASTER_MYPORT,;
213 XA START '0123456789012345678901234567890123456789012345678901234567890124','0123456789012345678901234567890123456789012345678901234567890124',2147483647;
214 INSERT INTO d1.t VALUES (64);
215 XA END '0123456789012345678901234567890123456789012345678901234567890124','0123456789012345678901234567890123456789012345678901234567890124',2147483647;
216 XA PREPARE '0123456789012345678901234567890123456789012345678901234567890124','0123456789012345678901234567890123456789012345678901234567890124',2147483647;
217 disconnect master_conn2;
218 connection master;
219 connect master_conn3, 127.0.0.1,root,,test,$MASTER_MYPORT,;
220 XA START X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF',X'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',0;
221 INSERT INTO d1.t VALUES (0);
222 XA END X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF',X'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',0;
223 XA PREPARE X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF',X'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',0;
224 disconnect master_conn3;
225 connection master;
226 disconnect master_conn4;
227 connection master;
228 XA COMMIT '0123456789012345678901234567890123456789012345678901234567890124','0123456789012345678901234567890123456789012345678901234567890124',2147483647;
229 XA COMMIT X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF',X'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',0;
230 XA COMMIT 'RANDOM XID'
231 include/sync_slave_sql_with_master.inc
232 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
233 connection master_bulk_conn10;
234 XA START 'one_phase_10';
235 INSERT INTO d1.t VALUES (10);
236 INSERT INTO d2.t VALUES (10);
237 XA END 'one_phase_10';
238 XA COMMIT 'one_phase_10' ONE PHASE;
239 disconnect master_bulk_conn10;
240 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
241 connection master_bulk_conn9;
242 XA START 'one_phase_9';
243 INSERT INTO d1.t VALUES (9);
244 INSERT INTO d2.t VALUES (9);
245 XA END 'one_phase_9';
246 XA COMMIT 'one_phase_9' ONE PHASE;
247 disconnect master_bulk_conn9;
248 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
249 connection master_bulk_conn8;
250 XA START 'one_phase_8';
251 INSERT INTO d1.t VALUES (8);
252 INSERT INTO d2.t VALUES (8);
253 XA END 'one_phase_8';
254 XA COMMIT 'one_phase_8' ONE PHASE;
255 disconnect master_bulk_conn8;
256 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
257 connection master_bulk_conn7;
258 XA START 'one_phase_7';
259 INSERT INTO d1.t VALUES (7);
260 INSERT INTO d2.t VALUES (7);
261 XA END 'one_phase_7';
262 XA COMMIT 'one_phase_7' ONE PHASE;
263 disconnect master_bulk_conn7;
264 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
265 connection master_bulk_conn6;
266 XA START 'one_phase_6';
267 INSERT INTO d1.t VALUES (6);
268 INSERT INTO d2.t VALUES (6);
269 XA END 'one_phase_6';
270 XA COMMIT 'one_phase_6' ONE PHASE;
271 disconnect master_bulk_conn6;
272 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
273 connection master_bulk_conn5;
274 XA START 'one_phase_5';
275 INSERT INTO d1.t VALUES (5);
276 INSERT INTO d2.t VALUES (5);
277 XA END 'one_phase_5';
278 XA COMMIT 'one_phase_5' ONE PHASE;
279 disconnect master_bulk_conn5;
280 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
281 connection master_bulk_conn4;
282 XA START 'one_phase_4';
283 INSERT INTO d1.t VALUES (4);
284 INSERT INTO d2.t VALUES (4);
285 XA END 'one_phase_4';
286 XA COMMIT 'one_phase_4' ONE PHASE;
287 disconnect master_bulk_conn4;
288 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
289 connection master_bulk_conn3;
290 XA START 'one_phase_3';
291 INSERT INTO d1.t VALUES (3);
292 INSERT INTO d2.t VALUES (3);
293 XA END 'one_phase_3';
294 XA COMMIT 'one_phase_3' ONE PHASE;
295 disconnect master_bulk_conn3;
296 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
297 connection master_bulk_conn2;
298 XA START 'one_phase_2';
299 INSERT INTO d1.t VALUES (2);
300 INSERT INTO d2.t VALUES (2);
301 XA END 'one_phase_2';
302 XA COMMIT 'one_phase_2' ONE PHASE;
303 disconnect master_bulk_conn2;
304 connect master_bulk_conn$i, 127.0.0.1,root,,test,$MASTER_MYPORT,;
305 connection master_bulk_conn1;
306 XA START 'one_phase_1';
307 INSERT INTO d1.t VALUES (1);
308 INSERT INTO d2.t VALUES (1);
309 XA END 'one_phase_1';
310 XA COMMIT 'one_phase_1' ONE PHASE;
311 disconnect master_bulk_conn1;
312 connection master;
313 include/sync_slave_sql_with_master.inc
314 include/diff_tables.inc [master:d1.t, slave:d1.t]
315 include/diff_tables.inc [master:d2.t, slave:d2.t]
316 connection master;
317 DELETE FROM d1.t;
318 DELETE FROM d2.t;
319 DROP TABLE d1.t, d2.t;
320 DROP DATABASE d1;
321 DROP DATABASE d2;
322 DROP VIEW v_processlist;
323 include/sync_slave_sql_with_master.inc
324 include/rpl_end.inc