Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_gtid_next_xa.result

raw
1 SET GLOBAL xa_detach_on_prepare = OFF;
2 call mtr.add_suppression("The transaction owned GTID is already in the gtid_executed table");
3 CALL mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
4 include/rpl_init.inc [topology=none]
5 include/rpl_default_connections.inc
6 call mtr.add_suppression("Found 1 prepared XA transactions");
7 include/rpl_set_gtid_mode.inc [ON_PERMISSIVE on servers 1]
8 CREATE TABLE t1 (a INT);
9 ---- XID 1, COMMIT: AUTOMATIC + AUTOMATIC ----
10 [connection master]
11 SET GTID_NEXT= 'AUTOMATIC';
12 XA START '1';
13 INSERT INTO t1 VALUES(1);
14 Warnings:
15 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
16 XA END '1';
17 XA PREPARE '1';
18 include/assert.inc [Thread should not own any GTID.]
19 [connection master1]
20 include/assert.inc [No thread should own any GTID.]
21 include/assert.inc [No thread should hold anonymous ownership.]
22 [connection master]
23 error=0
24 SET GTID_NEXT= 'AUTOMATIC';
25 XA COMMIT '1' ;
26 include/assert.inc [Thread should not own any GTID.]
27 include/assert.inc [No thread should own any GTID.]
28 include/assert.inc [No thread should hold anonymous ownership.]
29 ROLLBACK;
30 SET GTID_NEXT = 'AUTOMATIC';
31 ---- XID 2, COMMIT: AUTOMATIC + aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2 ----
32 [connection master]
33 SET GTID_NEXT= 'AUTOMATIC';
34 XA START '2';
35 INSERT INTO t1 VALUES(2);
36 Warnings:
37 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
38 XA END '2';
39 XA PREPARE '2';
40 include/assert.inc [Thread should not own any GTID.]
41 [connection master1]
42 include/assert.inc [No thread should own any GTID.]
43 include/assert.inc [No thread should hold anonymous ownership.]
44 [connection master]
45 error=0
46 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
47 XA COMMIT '2' ;
48 include/assert.inc [Thread should not own any GTID.]
49 include/assert.inc [No thread should own any GTID.]
50 include/assert.inc [No thread should hold anonymous ownership.]
51 ROLLBACK;
52 SET GTID_NEXT = 'AUTOMATIC';
53 ---- XID 3, COMMIT: AUTOMATIC + ANONYMOUS ----
54 [connection master]
55 SET GTID_NEXT= 'AUTOMATIC';
56 XA START '3';
57 INSERT INTO t1 VALUES(3);
58 Warnings:
59 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
60 XA END '3';
61 XA PREPARE '3';
62 include/assert.inc [Thread should not own any GTID.]
63 [connection master1]
64 include/assert.inc [No thread should own any GTID.]
65 include/assert.inc [No thread should hold anonymous ownership.]
66 [connection master]
67 error=0
68 SET GTID_NEXT= 'ANONYMOUS';
69 XA COMMIT '3' ;
70 include/assert.inc [Thread should not own any GTID.]
71 include/assert.inc [No thread should own any GTID.]
72 include/assert.inc [No thread should hold anonymous ownership.]
73 ROLLBACK;
74 SET GTID_NEXT = 'AUTOMATIC';
75 ---- XID 4, COMMIT: AUTOMATIC + none ----
76 [connection master]
77 SET GTID_NEXT= 'AUTOMATIC';
78 XA START '4';
79 INSERT INTO t1 VALUES(4);
80 Warnings:
81 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
82 XA END '4';
83 XA PREPARE '4';
84 include/assert.inc [Thread should not own any GTID.]
85 [connection master1]
86 include/assert.inc [No thread should own any GTID.]
87 include/assert.inc [No thread should hold anonymous ownership.]
88 [connection master]
89 error=0
90 XA COMMIT '4' ;
91 include/assert.inc [Thread should not own any GTID.]
92 include/assert.inc [No thread should own any GTID.]
93 include/assert.inc [No thread should hold anonymous ownership.]
94 ROLLBACK;
95 SET GTID_NEXT = 'AUTOMATIC';
96 ---- XID 5, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5 + AUTOMATIC ----
97 [connection master]
98 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5';
99 XA START '5';
100 INSERT INTO t1 VALUES(5);
101 Warnings:
102 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
103 XA END '5';
104 XA PREPARE '5';
105 include/assert.inc [Thread should not own any GTID.]
106 [connection master1]
107 include/assert.inc [No thread should own any GTID.]
108 include/assert.inc [No thread should hold anonymous ownership.]
109 [connection master]
110 error=0
111 SET GTID_NEXT= 'AUTOMATIC';
112 XA COMMIT '5' ;
113 include/assert.inc [Thread should not own any GTID.]
114 include/assert.inc [No thread should own any GTID.]
115 include/assert.inc [No thread should hold anonymous ownership.]
116 ROLLBACK;
117 SET GTID_NEXT = 'AUTOMATIC';
118 ---- XID 6, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:6 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:6 ----
119 [connection master]
120 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:6';
121 XA START '6';
122 INSERT INTO t1 VALUES(6);
123 Warnings:
124 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
125 XA END '6';
126 XA PREPARE '6';
127 include/assert.inc [Thread should not own any GTID.]
128 [connection master1]
129 include/assert.inc [No thread should own any GTID.]
130 include/assert.inc [No thread should hold anonymous ownership.]
131 [connection master]
132 error=0
133 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:6';
134 XA COMMIT '6' ;
135 include/assert.inc [Thread should not own any GTID.]
136 include/assert.inc [No thread should own any GTID.]
137 include/assert.inc [No thread should hold anonymous ownership.]
138 ROLLBACK;
139 SET GTID_NEXT = 'AUTOMATIC';
140 ---- XID 7, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:7 + ANONYMOUS ----
141 [connection master]
142 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:7';
143 XA START '7';
144 INSERT INTO t1 VALUES(7);
145 Warnings:
146 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
147 XA END '7';
148 XA PREPARE '7';
149 include/assert.inc [Thread should not own any GTID.]
150 [connection master1]
151 include/assert.inc [No thread should own any GTID.]
152 include/assert.inc [No thread should hold anonymous ownership.]
153 [connection master]
154 error=0
155 SET GTID_NEXT= 'ANONYMOUS';
156 XA COMMIT '7' ;
157 include/assert.inc [Thread should not own any GTID.]
158 include/assert.inc [No thread should own any GTID.]
159 include/assert.inc [No thread should hold anonymous ownership.]
160 ROLLBACK;
161 SET GTID_NEXT = 'AUTOMATIC';
162 ---- XID 8, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:8 + none ----
163 [connection master]
164 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:8';
165 XA START '8';
166 INSERT INTO t1 VALUES(8);
167 Warnings:
168 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
169 XA END '8';
170 XA PREPARE '8';
171 include/assert.inc [Thread should not own any GTID.]
172 [connection master1]
173 include/assert.inc [No thread should own any GTID.]
174 include/assert.inc [No thread should hold anonymous ownership.]
175 [connection master]
176 error=1837
177 XA COMMIT '8';
178 ERROR HY000: When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:8'.
179 [connection master1]
180 include/assert.inc [No thread should own any GTID.]
181 include/assert.inc [No thread should hold anonymous ownership.]
182 [connection master]
183 SET GTID_NEXT = 'AUTOMATIC';
184 XA COMMIT '8' ;
185 include/assert.inc [Thread should not own any GTID.]
186 include/assert.inc [No thread should own any GTID.]
187 include/assert.inc [No thread should hold anonymous ownership.]
188 ROLLBACK;
189 SET GTID_NEXT = 'AUTOMATIC';
190 ---- XID 9, COMMIT: ANONYMOUS + AUTOMATIC ----
191 [connection master]
192 SET GTID_NEXT= 'ANONYMOUS';
193 XA START '9';
194 INSERT INTO t1 VALUES(9);
195 Warnings:
196 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
197 XA END '9';
198 XA PREPARE '9';
199 include/assert.inc [Thread should not own any GTID.]
200 [connection master1]
201 include/assert.inc [No thread should own any GTID.]
202 include/assert.inc [No thread should hold anonymous ownership.]
203 [connection master]
204 error=0
205 SET GTID_NEXT= 'AUTOMATIC';
206 XA COMMIT '9' ;
207 include/assert.inc [Thread should not own any GTID.]
208 include/assert.inc [No thread should own any GTID.]
209 include/assert.inc [No thread should hold anonymous ownership.]
210 ROLLBACK;
211 SET GTID_NEXT = 'AUTOMATIC';
212 ---- XID 10, COMMIT: ANONYMOUS + aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10 ----
213 [connection master]
214 SET GTID_NEXT= 'ANONYMOUS';
215 XA START '10';
216 INSERT INTO t1 VALUES(10);
217 Warnings:
218 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
219 XA END '10';
220 XA PREPARE '10';
221 include/assert.inc [Thread should not own any GTID.]
222 [connection master1]
223 include/assert.inc [No thread should own any GTID.]
224 include/assert.inc [No thread should hold anonymous ownership.]
225 [connection master]
226 error=0
227 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10';
228 XA COMMIT '10' ;
229 include/assert.inc [Thread should not own any GTID.]
230 include/assert.inc [No thread should own any GTID.]
231 include/assert.inc [No thread should hold anonymous ownership.]
232 ROLLBACK;
233 SET GTID_NEXT = 'AUTOMATIC';
234 ---- XID 11, COMMIT: ANONYMOUS + ANONYMOUS ----
235 [connection master]
236 SET GTID_NEXT= 'ANONYMOUS';
237 XA START '11';
238 INSERT INTO t1 VALUES(11);
239 Warnings:
240 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
241 XA END '11';
242 XA PREPARE '11';
243 include/assert.inc [Thread should not own any GTID.]
244 [connection master1]
245 include/assert.inc [No thread should own any GTID.]
246 include/assert.inc [No thread should hold anonymous ownership.]
247 [connection master]
248 error=0
249 SET GTID_NEXT= 'ANONYMOUS';
250 XA COMMIT '11' ;
251 include/assert.inc [Thread should not own any GTID.]
252 include/assert.inc [No thread should own any GTID.]
253 include/assert.inc [No thread should hold anonymous ownership.]
254 ROLLBACK;
255 SET GTID_NEXT = 'AUTOMATIC';
256 ---- XID 12, COMMIT: ANONYMOUS + none ----
257 [connection master]
258 SET GTID_NEXT= 'ANONYMOUS';
259 XA START '12';
260 INSERT INTO t1 VALUES(12);
261 Warnings:
262 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
263 XA END '12';
264 XA PREPARE '12';
265 include/assert.inc [Thread should not own any GTID.]
266 [connection master1]
267 include/assert.inc [No thread should own any GTID.]
268 include/assert.inc [No thread should hold anonymous ownership.]
269 [connection master]
270 error=0
271 XA COMMIT '12' ;
272 include/assert.inc [Thread should not own any GTID.]
273 include/assert.inc [No thread should own any GTID.]
274 include/assert.inc [No thread should hold anonymous ownership.]
275 ROLLBACK;
276 SET GTID_NEXT = 'AUTOMATIC';
277 ---- XID 13, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:13 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:13 ----
278 [connection master]
279 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:13';
280 XA START '13';
281 INSERT INTO t1 VALUES(13);
282 Warnings:
283 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
284 XA END '13';
285 XA COMMIT '13' one phase;
286 include/assert.inc [Thread should not own any GTID.]
287 include/assert.inc [No thread should own any GTID.]
288 include/assert.inc [No thread should hold anonymous ownership.]
289 ROLLBACK;
290 SET GTID_NEXT = 'AUTOMATIC';
291 SET @@SESSION.innodb_lock_wait_timeout = 1;
292 ---- XID 14, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:14 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:14 ----
293 [connection master]
294 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:14';
295 XA START '14';
296 INSERT INTO t1 VALUES(14);
297 Warnings:
298 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
299 XA END '14';
300 SET @@SESSION.debug = "+d,simulate_xa_rm_error";
301 XA COMMIT '14' one phase;
302 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
303 SET @@SESSION.debug = "-d,simulate_xa_rm_error";
304 include/assert.inc [Thread should not own any GTID.]
305 include/assert.inc [No thread should own any GTID.]
306 include/assert.inc [No thread should hold anonymous ownership.]
307 ROLLBACK;
308 SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
309 SET GTID_NEXT = 'AUTOMATIC';
310 SET @@SESSION.innodb_lock_wait_timeout = 1;
311 ---- XID 15, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:15 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:15 ----
312 [connection master]
313 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:15';
314 SET @@SESSION.debug = "+d,simulate_xa_failure_prepare";
315 XA START '15';
316 INSERT INTO t1 VALUES(15);
317 Warnings:
318 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
319 XA END '15';
320 XA PREPARE '15';
321 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
322 [connection master]
323 SHOW WARNINGS;
324 Level Code Message
325 Error 1402 XA_RBROLLBACK: Transaction branch was rolled back
326 SET @@SESSION.debug = "-d,simulate_xa_failure_prepare";
327 include/assert.inc [Thread should not own any GTID.]
328 [connection master1]
329 include/assert.inc [No thread should own any GTID.]
330 include/assert.inc [No thread should hold anonymous ownership.]
331 [connection master]
332 error=
333 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:15';
334 XA COMMIT '15' ;
335 ERROR XAE04: XAER_NOTA: Unknown XID
336 include/assert.inc [Thread should not own any GTID.]
337 include/assert.inc [No thread should own any GTID.]
338 include/assert.inc [No thread should hold anonymous ownership.]
339 ROLLBACK;
340 SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
341 SET GTID_NEXT = 'AUTOMATIC';
342 SET @@SESSION.innodb_lock_wait_timeout = 1;
343 ---- XID 16, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:16 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:16 ----
344 [connection master]
345 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:16';
346 XA START '16';
347 INSERT INTO t1 VALUES(16);
348 Warnings:
349 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
350 XA END '16';
351 XA PREPARE '16';
352 include/assert.inc [Thread should not own any GTID.]
353 [connection master1]
354 include/assert.inc [No thread should own any GTID.]
355 include/assert.inc [No thread should hold anonymous ownership.]
356 [connection master]
357 error=
358 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:16';
359 SET @@SESSION.debug = "+d,simulate_xa_rm_error";
360 XA COMMIT '16' ;
361 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
362 SET @@SESSION.debug = "-d,simulate_xa_rm_error";
363 include/assert.inc [Thread should not own any GTID.]
364 include/assert.inc [No thread should own any GTID.]
365 include/assert.inc [No thread should hold anonymous ownership.]
366 ROLLBACK;
367 SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
368 SET GTID_NEXT = 'AUTOMATIC';
369 SET @@SESSION.innodb_lock_wait_timeout = 1;
370 ---- XID 17, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:17 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:17 ----
371 [connection master]
372 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:17';
373 XA START '17';
374 INSERT INTO t1 VALUES(17);
375 Warnings:
376 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
377 XA END '17';
378 XA PREPARE '17';
379 include/assert.inc [Thread should not own any GTID.]
380 [connection master1]
381 include/assert.inc [No thread should own any GTID.]
382 include/assert.inc [No thread should hold anonymous ownership.]
383 include/rpl_restart_server.inc [server_number=1]
384 include/rpl_set_gtid_mode.inc [ON_PERMISSIVE on servers 1]
385 [connection master]
386 SET @@SESSION.innodb_lock_wait_timeout = 1;
387 SELECT count(*) as one FROM mysql.gtid_executed WHERE source_uuid = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa' AND interval_end = 17;
388 one
389 1
390 SELECT sum(interval_end+1)-sum(interval_start) as "count" FROM mysql.gtid_executed FOR UPDATE;
391 count
392 20
393 Warnings:
394 Warning 3129 Please do not modify the gtid_executed table. This is a mysql internal system table to store GTIDs for committed transactions. Modifying it can lead to an inconsistent GTID state.
395 [connection master]
396 error=
397 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:17';
398 SET @@SESSION.debug = "+d,simulate_xa_rm_error";
399 XA COMMIT '17' ;
400 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
401 SET @@SESSION.debug = "-d,simulate_xa_rm_error";
402 include/assert.inc [Thread should not own any GTID.]
403 include/assert.inc [No thread should own any GTID.]
404 include/assert.inc [No thread should hold anonymous ownership.]
405 ROLLBACK;
406 SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
407 SET GTID_NEXT = 'AUTOMATIC';
408 ---- XID 18, ROLLBACK: AUTOMATIC + AUTOMATIC ----
409 [connection master]
410 SET GTID_NEXT= 'AUTOMATIC';
411 XA START '18';
412 INSERT INTO t1 VALUES(18);
413 Warnings:
414 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
415 XA END '18';
416 XA PREPARE '18';
417 include/assert.inc [Thread should not own any GTID.]
418 [connection master1]
419 include/assert.inc [No thread should own any GTID.]
420 include/assert.inc [No thread should hold anonymous ownership.]
421 [connection master]
422 error=0
423 SET GTID_NEXT= 'AUTOMATIC';
424 XA ROLLBACK '18' ;
425 include/assert.inc [Thread should not own any GTID.]
426 include/assert.inc [No thread should own any GTID.]
427 include/assert.inc [No thread should hold anonymous ownership.]
428 ROLLBACK;
429 SET GTID_NEXT = 'AUTOMATIC';
430 ---- XID 19, ROLLBACK: AUTOMATIC + aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:19 ----
431 [connection master]
432 SET GTID_NEXT= 'AUTOMATIC';
433 XA START '19';
434 INSERT INTO t1 VALUES(19);
435 Warnings:
436 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
437 XA END '19';
438 XA PREPARE '19';
439 include/assert.inc [Thread should not own any GTID.]
440 [connection master1]
441 include/assert.inc [No thread should own any GTID.]
442 include/assert.inc [No thread should hold anonymous ownership.]
443 [connection master]
444 error=0
445 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:19';
446 XA ROLLBACK '19' ;
447 include/assert.inc [Thread should not own any GTID.]
448 include/assert.inc [No thread should own any GTID.]
449 include/assert.inc [No thread should hold anonymous ownership.]
450 ROLLBACK;
451 SET GTID_NEXT = 'AUTOMATIC';
452 ---- XID 20, ROLLBACK: AUTOMATIC + ANONYMOUS ----
453 [connection master]
454 SET GTID_NEXT= 'AUTOMATIC';
455 XA START '20';
456 INSERT INTO t1 VALUES(20);
457 Warnings:
458 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
459 XA END '20';
460 XA PREPARE '20';
461 include/assert.inc [Thread should not own any GTID.]
462 [connection master1]
463 include/assert.inc [No thread should own any GTID.]
464 include/assert.inc [No thread should hold anonymous ownership.]
465 [connection master]
466 error=0
467 SET GTID_NEXT= 'ANONYMOUS';
468 XA ROLLBACK '20' ;
469 include/assert.inc [Thread should not own any GTID.]
470 include/assert.inc [No thread should own any GTID.]
471 include/assert.inc [No thread should hold anonymous ownership.]
472 ROLLBACK;
473 SET GTID_NEXT = 'AUTOMATIC';
474 ---- XID 21, ROLLBACK: AUTOMATIC + none ----
475 [connection master]
476 SET GTID_NEXT= 'AUTOMATIC';
477 XA START '21';
478 INSERT INTO t1 VALUES(21);
479 Warnings:
480 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
481 XA END '21';
482 XA PREPARE '21';
483 include/assert.inc [Thread should not own any GTID.]
484 [connection master1]
485 include/assert.inc [No thread should own any GTID.]
486 include/assert.inc [No thread should hold anonymous ownership.]
487 [connection master]
488 error=0
489 XA ROLLBACK '21' ;
490 include/assert.inc [Thread should not own any GTID.]
491 include/assert.inc [No thread should own any GTID.]
492 include/assert.inc [No thread should hold anonymous ownership.]
493 ROLLBACK;
494 SET GTID_NEXT = 'AUTOMATIC';
495 ---- XID 22, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:22 + AUTOMATIC ----
496 [connection master]
497 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:22';
498 XA START '22';
499 INSERT INTO t1 VALUES(22);
500 Warnings:
501 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
502 XA END '22';
503 XA PREPARE '22';
504 include/assert.inc [Thread should not own any GTID.]
505 [connection master1]
506 include/assert.inc [No thread should own any GTID.]
507 include/assert.inc [No thread should hold anonymous ownership.]
508 [connection master]
509 error=0
510 SET GTID_NEXT= 'AUTOMATIC';
511 XA ROLLBACK '22' ;
512 include/assert.inc [Thread should not own any GTID.]
513 include/assert.inc [No thread should own any GTID.]
514 include/assert.inc [No thread should hold anonymous ownership.]
515 ROLLBACK;
516 SET GTID_NEXT = 'AUTOMATIC';
517 ---- XID 23, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:23 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:23 ----
518 [connection master]
519 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:23';
520 XA START '23';
521 INSERT INTO t1 VALUES(23);
522 Warnings:
523 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
524 XA END '23';
525 XA PREPARE '23';
526 include/assert.inc [Thread should not own any GTID.]
527 [connection master1]
528 include/assert.inc [No thread should own any GTID.]
529 include/assert.inc [No thread should hold anonymous ownership.]
530 [connection master]
531 error=0
532 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:23';
533 XA ROLLBACK '23' ;
534 include/assert.inc [Thread should not own any GTID.]
535 include/assert.inc [No thread should own any GTID.]
536 include/assert.inc [No thread should hold anonymous ownership.]
537 ROLLBACK;
538 SET GTID_NEXT = 'AUTOMATIC';
539 ---- XID 24, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:24 + ANONYMOUS ----
540 [connection master]
541 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:24';
542 XA START '24';
543 INSERT INTO t1 VALUES(24);
544 Warnings:
545 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
546 XA END '24';
547 XA PREPARE '24';
548 include/assert.inc [Thread should not own any GTID.]
549 [connection master1]
550 include/assert.inc [No thread should own any GTID.]
551 include/assert.inc [No thread should hold anonymous ownership.]
552 [connection master]
553 error=0
554 SET GTID_NEXT= 'ANONYMOUS';
555 XA ROLLBACK '24' ;
556 include/assert.inc [Thread should not own any GTID.]
557 include/assert.inc [No thread should own any GTID.]
558 include/assert.inc [No thread should hold anonymous ownership.]
559 ROLLBACK;
560 SET GTID_NEXT = 'AUTOMATIC';
561 ---- XID 25, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:25 + none ----
562 [connection master]
563 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:25';
564 XA START '25';
565 INSERT INTO t1 VALUES(25);
566 Warnings:
567 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
568 XA END '25';
569 XA PREPARE '25';
570 include/assert.inc [Thread should not own any GTID.]
571 [connection master1]
572 include/assert.inc [No thread should own any GTID.]
573 include/assert.inc [No thread should hold anonymous ownership.]
574 [connection master]
575 error=1837
576 XA ROLLBACK '25';
577 ERROR HY000: When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:25'.
578 [connection master1]
579 include/assert.inc [No thread should own any GTID.]
580 include/assert.inc [No thread should hold anonymous ownership.]
581 [connection master]
582 SET GTID_NEXT = 'AUTOMATIC';
583 XA ROLLBACK '25' ;
584 include/assert.inc [Thread should not own any GTID.]
585 include/assert.inc [No thread should own any GTID.]
586 include/assert.inc [No thread should hold anonymous ownership.]
587 ROLLBACK;
588 SET GTID_NEXT = 'AUTOMATIC';
589 ---- XID 26, ROLLBACK: ANONYMOUS + AUTOMATIC ----
590 [connection master]
591 SET GTID_NEXT= 'ANONYMOUS';
592 XA START '26';
593 INSERT INTO t1 VALUES(26);
594 Warnings:
595 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
596 XA END '26';
597 XA PREPARE '26';
598 include/assert.inc [Thread should not own any GTID.]
599 [connection master1]
600 include/assert.inc [No thread should own any GTID.]
601 include/assert.inc [No thread should hold anonymous ownership.]
602 [connection master]
603 error=0
604 SET GTID_NEXT= 'AUTOMATIC';
605 XA ROLLBACK '26' ;
606 include/assert.inc [Thread should not own any GTID.]
607 include/assert.inc [No thread should own any GTID.]
608 include/assert.inc [No thread should hold anonymous ownership.]
609 ROLLBACK;
610 SET GTID_NEXT = 'AUTOMATIC';
611 ---- XID 27, ROLLBACK: ANONYMOUS + aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:27 ----
612 [connection master]
613 SET GTID_NEXT= 'ANONYMOUS';
614 XA START '27';
615 INSERT INTO t1 VALUES(27);
616 Warnings:
617 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
618 XA END '27';
619 XA PREPARE '27';
620 include/assert.inc [Thread should not own any GTID.]
621 [connection master1]
622 include/assert.inc [No thread should own any GTID.]
623 include/assert.inc [No thread should hold anonymous ownership.]
624 [connection master]
625 error=0
626 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:27';
627 XA ROLLBACK '27' ;
628 include/assert.inc [Thread should not own any GTID.]
629 include/assert.inc [No thread should own any GTID.]
630 include/assert.inc [No thread should hold anonymous ownership.]
631 ROLLBACK;
632 SET GTID_NEXT = 'AUTOMATIC';
633 ---- XID 28, ROLLBACK: ANONYMOUS + ANONYMOUS ----
634 [connection master]
635 SET GTID_NEXT= 'ANONYMOUS';
636 XA START '28';
637 INSERT INTO t1 VALUES(28);
638 Warnings:
639 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
640 XA END '28';
641 XA PREPARE '28';
642 include/assert.inc [Thread should not own any GTID.]
643 [connection master1]
644 include/assert.inc [No thread should own any GTID.]
645 include/assert.inc [No thread should hold anonymous ownership.]
646 [connection master]
647 error=0
648 SET GTID_NEXT= 'ANONYMOUS';
649 XA ROLLBACK '28' ;
650 include/assert.inc [Thread should not own any GTID.]
651 include/assert.inc [No thread should own any GTID.]
652 include/assert.inc [No thread should hold anonymous ownership.]
653 ROLLBACK;
654 SET GTID_NEXT = 'AUTOMATIC';
655 ---- XID 29, ROLLBACK: ANONYMOUS + none ----
656 [connection master]
657 SET GTID_NEXT= 'ANONYMOUS';
658 XA START '29';
659 INSERT INTO t1 VALUES(29);
660 Warnings:
661 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
662 XA END '29';
663 XA PREPARE '29';
664 include/assert.inc [Thread should not own any GTID.]
665 [connection master1]
666 include/assert.inc [No thread should own any GTID.]
667 include/assert.inc [No thread should hold anonymous ownership.]
668 [connection master]
669 error=0
670 XA ROLLBACK '29' ;
671 include/assert.inc [Thread should not own any GTID.]
672 include/assert.inc [No thread should own any GTID.]
673 include/assert.inc [No thread should hold anonymous ownership.]
674 ROLLBACK;
675 SET GTID_NEXT = 'AUTOMATIC';
676 ---- XID 30, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:30 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:30 ----
677 [connection master]
678 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:30';
679 XA START '30';
680 INSERT INTO t1 VALUES(30);
681 Warnings:
682 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
683 XA END '30';
684 XA ROLLBACK '30' ;
685 include/assert.inc [Thread should not own any GTID.]
686 include/assert.inc [No thread should own any GTID.]
687 include/assert.inc [No thread should hold anonymous ownership.]
688 ROLLBACK;
689 SET GTID_NEXT = 'AUTOMATIC';
690 SET @@SESSION.innodb_lock_wait_timeout = 1;
691 ---- XID 31, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:31 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:31 ----
692 [connection master]
693 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:31';
694 XA START '31';
695 INSERT INTO t1 VALUES(31);
696 Warnings:
697 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
698 XA END '31';
699 SET @@SESSION.debug = "+d,simulate_xa_rm_error";
700 XA ROLLBACK '31' ;
701 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
702 SET @@SESSION.debug = "-d,simulate_xa_rm_error";
703 include/assert.inc [Thread should not own any GTID.]
704 include/assert.inc [No thread should own any GTID.]
705 include/assert.inc [No thread should hold anonymous ownership.]
706 ROLLBACK;
707 SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
708 SET GTID_NEXT = 'AUTOMATIC';
709 SET @@SESSION.innodb_lock_wait_timeout = 1;
710 ---- XID 32, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:32 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:32 ----
711 [connection master]
712 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:32';
713 SET @@SESSION.debug = "+d,simulate_xa_failure_prepare";
714 XA START '32';
715 INSERT INTO t1 VALUES(32);
716 Warnings:
717 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
718 XA END '32';
719 XA PREPARE '32';
720 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
721 [connection master]
722 SHOW WARNINGS;
723 Level Code Message
724 Error 1402 XA_RBROLLBACK: Transaction branch was rolled back
725 SET @@SESSION.debug = "-d,simulate_xa_failure_prepare";
726 include/assert.inc [Thread should not own any GTID.]
727 [connection master1]
728 include/assert.inc [No thread should own any GTID.]
729 include/assert.inc [No thread should hold anonymous ownership.]
730 [connection master]
731 error=
732 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:32';
733 XA ROLLBACK '32' ;
734 ERROR XAE04: XAER_NOTA: Unknown XID
735 include/assert.inc [Thread should not own any GTID.]
736 include/assert.inc [No thread should own any GTID.]
737 include/assert.inc [No thread should hold anonymous ownership.]
738 ROLLBACK;
739 SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
740 SET GTID_NEXT = 'AUTOMATIC';
741 SET @@SESSION.innodb_lock_wait_timeout = 1;
742 ---- XID 33, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:33 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:33 ----
743 [connection master]
744 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:33';
745 XA START '33';
746 INSERT INTO t1 VALUES(33);
747 Warnings:
748 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
749 XA END '33';
750 XA PREPARE '33';
751 include/assert.inc [Thread should not own any GTID.]
752 [connection master1]
753 include/assert.inc [No thread should own any GTID.]
754 include/assert.inc [No thread should hold anonymous ownership.]
755 [connection master]
756 error=
757 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:33';
758 SET @@SESSION.debug = "+d,simulate_xa_rm_error";
759 XA ROLLBACK '33' ;
760 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
761 SET @@SESSION.debug = "-d,simulate_xa_rm_error";
762 include/assert.inc [Thread should not own any GTID.]
763 include/assert.inc [No thread should own any GTID.]
764 include/assert.inc [No thread should hold anonymous ownership.]
765 ROLLBACK;
766 SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
767 SET GTID_NEXT = 'AUTOMATIC';
768 SET @@SESSION.innodb_lock_wait_timeout = 1;
769 ---- XID 34, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:34 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:34 ----
770 [connection master]
771 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:34';
772 XA START '34';
773 INSERT INTO t1 VALUES(34);
774 Warnings:
775 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
776 XA END '34';
777 XA PREPARE '34';
778 include/assert.inc [Thread should not own any GTID.]
779 [connection master1]
780 include/assert.inc [No thread should own any GTID.]
781 include/assert.inc [No thread should hold anonymous ownership.]
782 include/rpl_restart_server.inc [server_number=1]
783 include/rpl_set_gtid_mode.inc [ON_PERMISSIVE on servers 1]
784 [connection master]
785 SET @@SESSION.innodb_lock_wait_timeout = 1;
786 SELECT count(*) as one FROM mysql.gtid_executed WHERE source_uuid = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa' AND interval_end = 34;
787 one
788 1
789 SELECT sum(interval_end+1)-sum(interval_start) as "count" FROM mysql.gtid_executed FOR UPDATE;
790 count
791 40
792 Warnings:
793 Warning 3129 Please do not modify the gtid_executed table. This is a mysql internal system table to store GTIDs for committed transactions. Modifying it can lead to an inconsistent GTID state.
794 [connection master]
795 error=
796 SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:34';
797 SET @@SESSION.debug = "+d,simulate_xa_rm_error";
798 XA ROLLBACK '34' ;
799 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
800 SET @@SESSION.debug = "-d,simulate_xa_rm_error";
801 include/assert.inc [Thread should not own any GTID.]
802 include/assert.inc [No thread should own any GTID.]
803 include/assert.inc [No thread should hold anonymous ownership.]
804 ROLLBACK;
805 SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
806 SET GTID_NEXT = 'AUTOMATIC';
807 DROP TABLE t1;
808 include/rpl_set_gtid_mode.inc [OFF on servers 1]
809 include/rpl_end.inc
810 SET GLOBAL xa_detach_on_prepare = OLD_VALUE_xa_detach_on_prepare;