Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
5 SET @@session.binlog_direct_non_transactional_updates := if(floor(rand()*10)%2,'ON','OFF');
6 CREATE TABLE t (a INT) ENGINE=innodb;
7 CREATE TABLE tm (a INT) ENGINE=myisam;
8 === COMMIT ===
9 XA START 'xa_trx';
10 INSERT INTO tm VALUES (1);
11 INSERT INTO t VALUES (1);
12 XA END 'xa_trx';
13 XA PREPARE 'xa_trx';
14 XA COMMIT 'xa_trx' ;
15 XA START 'xa_trx';
16 INSERT INTO t VALUES (2);
17 INSERT INTO tm VALUES (2);
18 XA END 'xa_trx';
19 XA PREPARE 'xa_trx';
20 XA COMMIT 'xa_trx' ;
21 XA START 'xa_trx';
22 INSERT INTO tm VALUES (3);
23 XA END 'xa_trx';
24 XA PREPARE 'xa_trx';
25 XA COMMIT 'xa_trx' ;
26 CREATE TEMPORARY TABLE tmp_i LIKE t;
27 CREATE TEMPORARY TABLE tmp_m LIKE tm;
28 XA START 'xa_trx';
29 INSERT INTO t VALUES (4);
30 INSERT INTO tm VALUES (4);
31 INSERT INTO tmp_i VALUES (4);
32 INSERT INTO tmp_m VALUES (4);
33 INSERT INTO t SELECT * FROM tmp_i;
34 INSERT INTO tm SELECT * FROM tmp_m;
35 XA END 'xa_trx';
36 XA PREPARE 'xa_trx';
37 XA COMMIT 'xa_trx' ;
38 XA START 'xa_trx';
39 INSERT INTO tmp_i VALUES (5);
40 INSERT INTO tmp_m VALUES (5);
41 INSERT INTO t SELECT * FROM tmp_i;
42 INSERT INTO tm SELECT * FROM tmp_m;
43 INSERT INTO t VALUES (5);
44 INSERT INTO tm VALUES (5);
45 XA END 'xa_trx';
46 XA PREPARE 'xa_trx';
47 XA COMMIT 'xa_trx' ;
48 DROP TEMPORARY TABLE tmp_i;
49 DROP TEMPORARY TABLE tmp_m;
50 XA START 'xa_trx';
51 INSERT INTO t VALUES (6);
52 INSERT INTO tm VALUES (6);
53 CREATE TEMPORARY TABLE tmp_i LIKE t;
54 CREATE TEMPORARY TABLE tmp_m LIKE tm;
55 INSERT INTO tmp_i VALUES (6);
56 INSERT INTO tmp_m VALUES (6);
57 INSERT INTO t SELECT * FROM tmp_i;
58 INSERT INTO tm SELECT * FROM tmp_m;
59 XA END 'xa_trx';
60 XA PREPARE 'xa_trx';
61 XA COMMIT 'xa_trx' ;
62 DROP TEMPORARY TABLE tmp_i;
63 DROP TEMPORARY TABLE tmp_m;
64 XA START 'xa_trx';
65 CREATE TEMPORARY TABLE tmp_i LIKE t;
66 CREATE TEMPORARY TABLE tmp_m LIKE tm;
67 INSERT INTO tmp_i VALUES (7);
68 INSERT INTO tmp_m VALUES (7);
69 INSERT INTO t SELECT * FROM tmp_i;
70 INSERT INTO tm SELECT * FROM tmp_m;
71 INSERT INTO t VALUES (7);
72 INSERT INTO tm VALUES (7);
73 XA END 'xa_trx';
74 XA PREPARE 'xa_trx';
75 XA COMMIT 'xa_trx' ;
76 XA START 'xa_trx';
77 INSERT INTO t VALUES (8);
78 INSERT INTO tm VALUES (8);
79 INSERT INTO tmp_i VALUES (8);
80 INSERT INTO tmp_m VALUES (8);
81 INSERT INTO t SELECT * FROM tmp_i;
82 INSERT INTO tm SELECT * FROM tmp_m;
83 DROP TEMPORARY TABLE tmp_i;
84 DROP TEMPORARY TABLE tmp_m;
85 XA END 'xa_trx';
86 XA PREPARE 'xa_trx';
87 XA COMMIT 'xa_trx' ;
88 XA START 'xa_trx';
89 UPDATE t SET a = 99 where a = -1;
90 XA END 'xa_trx';
91 XA PREPARE 'xa_trx';
92 XA COMMIT 'xa_trx' ;
93 include/sync_slave_sql_with_master.inc
94 connection master;
95 === COMMIT ONE PHASE ===
96 XA START 'xa_trx';
97 INSERT INTO tm VALUES (1);
98 INSERT INTO t VALUES (1);
99 XA END 'xa_trx';
100 XA COMMIT 'xa_trx' ONE PHASE;
101 XA START 'xa_trx';
102 INSERT INTO t VALUES (2);
103 INSERT INTO tm VALUES (2);
104 XA END 'xa_trx';
105 XA COMMIT 'xa_trx' ONE PHASE;
106 XA START 'xa_trx';
107 INSERT INTO tm VALUES (3);
108 XA END 'xa_trx';
109 XA COMMIT 'xa_trx' ONE PHASE;
110 CREATE TEMPORARY TABLE tmp_i LIKE t;
111 CREATE TEMPORARY TABLE tmp_m LIKE tm;
112 XA START 'xa_trx';
113 INSERT INTO t VALUES (4);
114 INSERT INTO tm VALUES (4);
115 INSERT INTO tmp_i VALUES (4);
116 INSERT INTO tmp_m VALUES (4);
117 INSERT INTO t SELECT * FROM tmp_i;
118 INSERT INTO tm SELECT * FROM tmp_m;
119 XA END 'xa_trx';
120 XA COMMIT 'xa_trx' ONE PHASE;
121 XA START 'xa_trx';
122 INSERT INTO tmp_i VALUES (5);
123 INSERT INTO tmp_m VALUES (5);
124 INSERT INTO t SELECT * FROM tmp_i;
125 INSERT INTO tm SELECT * FROM tmp_m;
126 INSERT INTO t VALUES (5);
127 INSERT INTO tm VALUES (5);
128 XA END 'xa_trx';
129 XA COMMIT 'xa_trx' ONE PHASE;
130 DROP TEMPORARY TABLE tmp_i;
131 DROP TEMPORARY TABLE tmp_m;
132 XA START 'xa_trx';
133 INSERT INTO t VALUES (6);
134 INSERT INTO tm VALUES (6);
135 CREATE TEMPORARY TABLE tmp_i LIKE t;
136 CREATE TEMPORARY TABLE tmp_m LIKE tm;
137 INSERT INTO tmp_i VALUES (6);
138 INSERT INTO tmp_m VALUES (6);
139 INSERT INTO t SELECT * FROM tmp_i;
140 INSERT INTO tm SELECT * FROM tmp_m;
141 XA END 'xa_trx';
142 XA COMMIT 'xa_trx' ONE PHASE;
143 DROP TEMPORARY TABLE tmp_i;
144 DROP TEMPORARY TABLE tmp_m;
145 XA START 'xa_trx';
146 CREATE TEMPORARY TABLE tmp_i LIKE t;
147 CREATE TEMPORARY TABLE tmp_m LIKE tm;
148 INSERT INTO tmp_i VALUES (7);
149 INSERT INTO tmp_m VALUES (7);
150 INSERT INTO t SELECT * FROM tmp_i;
151 INSERT INTO tm SELECT * FROM tmp_m;
152 INSERT INTO t VALUES (7);
153 INSERT INTO tm VALUES (7);
154 XA END 'xa_trx';
155 XA COMMIT 'xa_trx' ONE PHASE;
156 XA START 'xa_trx';
157 INSERT INTO t VALUES (8);
158 INSERT INTO tm VALUES (8);
159 INSERT INTO tmp_i VALUES (8);
160 INSERT INTO tmp_m VALUES (8);
161 INSERT INTO t SELECT * FROM tmp_i;
162 INSERT INTO tm SELECT * FROM tmp_m;
163 DROP TEMPORARY TABLE tmp_i;
164 DROP TEMPORARY TABLE tmp_m;
165 XA END 'xa_trx';
166 XA COMMIT 'xa_trx' ONE PHASE;
167 XA START 'xa_trx';
168 UPDATE t SET a = 99 where a = -1;
169 XA END 'xa_trx';
170 XA COMMIT 'xa_trx' ONE PHASE;
171 include/sync_slave_sql_with_master.inc
172 connection master;
173 === ROLLBACK with PREPARE ===
174 XA START 'xa_trx';
175 INSERT INTO tm VALUES (1);
176 INSERT INTO t VALUES (1);
177 XA END 'xa_trx';
178 XA PREPARE 'xa_trx';
179 xa rollback 'xa_trx' ;
180 Warnings:
181 Warning 1196 Some non-transactional changed tables couldn't be rolled back
182 XA START 'xa_trx';
183 INSERT INTO t VALUES (2);
184 INSERT INTO tm VALUES (2);
185 XA END 'xa_trx';
186 XA PREPARE 'xa_trx';
187 xa rollback 'xa_trx' ;
188 Warnings:
189 Warning 1196 Some non-transactional changed tables couldn't be rolled back
190 XA START 'xa_trx';
191 INSERT INTO tm VALUES (3);
192 XA END 'xa_trx';
193 XA PREPARE 'xa_trx';
194 xa rollback 'xa_trx' ;
195 Warnings:
196 Warning 1196 Some non-transactional changed tables couldn't be rolled back
197 CREATE TEMPORARY TABLE tmp_i LIKE t;
198 CREATE TEMPORARY TABLE tmp_m LIKE tm;
199 XA START 'xa_trx';
200 INSERT INTO t VALUES (4);
201 INSERT INTO tm VALUES (4);
202 INSERT INTO tmp_i VALUES (4);
203 INSERT INTO tmp_m VALUES (4);
204 INSERT INTO t SELECT * FROM tmp_i;
205 INSERT INTO tm SELECT * FROM tmp_m;
206 XA END 'xa_trx';
207 XA PREPARE 'xa_trx';
208 xa rollback 'xa_trx' ;
209 Warnings:
210 Warning 1196 Some non-transactional changed tables couldn't be rolled back
211 XA START 'xa_trx';
212 INSERT INTO tmp_i VALUES (5);
213 INSERT INTO tmp_m VALUES (5);
214 INSERT INTO t SELECT * FROM tmp_i;
215 INSERT INTO tm SELECT * FROM tmp_m;
216 INSERT INTO t VALUES (5);
217 INSERT INTO tm VALUES (5);
218 XA END 'xa_trx';
219 XA PREPARE 'xa_trx';
220 xa rollback 'xa_trx' ;
221 Warnings:
222 Warning 1196 Some non-transactional changed tables couldn't be rolled back
223 DROP TEMPORARY TABLE tmp_i;
224 DROP TEMPORARY TABLE tmp_m;
225 XA START 'xa_trx';
226 INSERT INTO t VALUES (6);
227 INSERT INTO tm VALUES (6);
228 CREATE TEMPORARY TABLE tmp_i LIKE t;
229 CREATE TEMPORARY TABLE tmp_m LIKE tm;
230 INSERT INTO tmp_i VALUES (6);
231 INSERT INTO tmp_m VALUES (6);
232 INSERT INTO t SELECT * FROM tmp_i;
233 INSERT INTO tm SELECT * FROM tmp_m;
234 XA END 'xa_trx';
235 XA PREPARE 'xa_trx';
236 xa rollback 'xa_trx' ;
237 Warnings:
238 Warning 1196 Some non-transactional changed tables couldn't be rolled back
239 DROP TEMPORARY TABLE tmp_i;
240 DROP TEMPORARY TABLE tmp_m;
241 XA START 'xa_trx';
242 CREATE TEMPORARY TABLE tmp_i LIKE t;
243 CREATE TEMPORARY TABLE tmp_m LIKE tm;
244 INSERT INTO tmp_i VALUES (7);
245 INSERT INTO tmp_m VALUES (7);
246 INSERT INTO t SELECT * FROM tmp_i;
247 INSERT INTO tm SELECT * FROM tmp_m;
248 INSERT INTO t VALUES (7);
249 INSERT INTO tm VALUES (7);
250 XA END 'xa_trx';
251 XA PREPARE 'xa_trx';
252 xa rollback 'xa_trx' ;
253 Warnings:
254 Warning 1196 Some non-transactional changed tables couldn't be rolled back
255 XA START 'xa_trx';
256 INSERT INTO t VALUES (8);
257 INSERT INTO tm VALUES (8);
258 INSERT INTO tmp_i VALUES (8);
259 INSERT INTO tmp_m VALUES (8);
260 INSERT INTO t SELECT * FROM tmp_i;
261 INSERT INTO tm SELECT * FROM tmp_m;
262 DROP TEMPORARY TABLE tmp_i;
263 DROP TEMPORARY TABLE tmp_m;
264 XA END 'xa_trx';
265 XA PREPARE 'xa_trx';
266 xa rollback 'xa_trx' ;
267 Warnings:
268 Warning 1196 Some non-transactional changed tables couldn't be rolled back
269 XA START 'xa_trx';
270 UPDATE t SET a = 99 where a = -1;
271 XA END 'xa_trx';
272 XA PREPARE 'xa_trx';
273 xa rollback 'xa_trx' ;
274 include/sync_slave_sql_with_master.inc
275 connection master;
276 === ROLLBACK with no PREPARE ===
277 XA START 'xa_trx';
278 INSERT INTO tm VALUES (1);
279 INSERT INTO t VALUES (1);
280 XA END 'xa_trx';
281 xa rollback 'xa_trx' ;
282 Warnings:
283 Warning 1196 Some non-transactional changed tables couldn't be rolled back
284 XA START 'xa_trx';
285 INSERT INTO t VALUES (2);
286 INSERT INTO tm VALUES (2);
287 XA END 'xa_trx';
288 xa rollback 'xa_trx' ;
289 Warnings:
290 Warning 1196 Some non-transactional changed tables couldn't be rolled back
291 XA START 'xa_trx';
292 INSERT INTO tm VALUES (3);
293 XA END 'xa_trx';
294 xa rollback 'xa_trx' ;
295 Warnings:
296 Warning 1196 Some non-transactional changed tables couldn't be rolled back
297 CREATE TEMPORARY TABLE tmp_i LIKE t;
298 CREATE TEMPORARY TABLE tmp_m LIKE tm;
299 XA START 'xa_trx';
300 INSERT INTO t VALUES (4);
301 INSERT INTO tm VALUES (4);
302 INSERT INTO tmp_i VALUES (4);
303 INSERT INTO tmp_m VALUES (4);
304 INSERT INTO t SELECT * FROM tmp_i;
305 INSERT INTO tm SELECT * FROM tmp_m;
306 XA END 'xa_trx';
307 xa rollback 'xa_trx' ;
308 Warnings:
309 Warning 1196 Some non-transactional changed tables couldn't be rolled back
310 XA START 'xa_trx';
311 INSERT INTO tmp_i VALUES (5);
312 INSERT INTO tmp_m VALUES (5);
313 INSERT INTO t SELECT * FROM tmp_i;
314 INSERT INTO tm SELECT * FROM tmp_m;
315 INSERT INTO t VALUES (5);
316 INSERT INTO tm VALUES (5);
317 XA END 'xa_trx';
318 xa rollback 'xa_trx' ;
319 Warnings:
320 Warning 1196 Some non-transactional changed tables couldn't be rolled back
321 DROP TEMPORARY TABLE tmp_i;
322 DROP TEMPORARY TABLE tmp_m;
323 XA START 'xa_trx';
324 INSERT INTO t VALUES (6);
325 INSERT INTO tm VALUES (6);
326 CREATE TEMPORARY TABLE tmp_i LIKE t;
327 CREATE TEMPORARY TABLE tmp_m LIKE tm;
328 INSERT INTO tmp_i VALUES (6);
329 INSERT INTO tmp_m VALUES (6);
330 INSERT INTO t SELECT * FROM tmp_i;
331 INSERT INTO tm SELECT * FROM tmp_m;
332 XA END 'xa_trx';
333 xa rollback 'xa_trx' ;
334 Warnings:
335 Warning 1196 Some non-transactional changed tables couldn't be rolled back
336 DROP TEMPORARY TABLE tmp_i;
337 DROP TEMPORARY TABLE tmp_m;
338 XA START 'xa_trx';
339 CREATE TEMPORARY TABLE tmp_i LIKE t;
340 CREATE TEMPORARY TABLE tmp_m LIKE tm;
341 INSERT INTO tmp_i VALUES (7);
342 INSERT INTO tmp_m VALUES (7);
343 INSERT INTO t SELECT * FROM tmp_i;
344 INSERT INTO tm SELECT * FROM tmp_m;
345 INSERT INTO t VALUES (7);
346 INSERT INTO tm VALUES (7);
347 XA END 'xa_trx';
348 xa rollback 'xa_trx' ;
349 Warnings:
350 Warning 1196 Some non-transactional changed tables couldn't be rolled back
351 XA START 'xa_trx';
352 INSERT INTO t VALUES (8);
353 INSERT INTO tm VALUES (8);
354 INSERT INTO tmp_i VALUES (8);
355 INSERT INTO tmp_m VALUES (8);
356 INSERT INTO t SELECT * FROM tmp_i;
357 INSERT INTO tm SELECT * FROM tmp_m;
358 DROP TEMPORARY TABLE tmp_i;
359 DROP TEMPORARY TABLE tmp_m;
360 XA END 'xa_trx';
361 xa rollback 'xa_trx' ;
362 Warnings:
363 Warning 1196 Some non-transactional changed tables couldn't be rolled back
364 XA START 'xa_trx';
365 UPDATE t SET a = 99 where a = -1;
366 XA END 'xa_trx';
367 xa rollback 'xa_trx' ;
368 include/sync_slave_sql_with_master.inc
369 include/diff_tables.inc [master:tm, slave:tm]
370 connection master;
371 DROP TABLE t, tm;
372 include/sync_slave_sql_with_master.inc
373 include/rpl_end.inc