| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connection master; |
| 4 |
create table t1 (a int primary key, b int) engine=innodb; |
| 5 |
insert t1 values (1,1),(3,3),(5,5),(7,7); |
| 6 |
create table t2 (m int) engine=aria; |
| 7 |
# Create multi-engine, two-phase XA transaction (T1) |
| 8 |
xa start '1'; |
| 9 |
insert t2 values (1); |
| 10 |
update t1 set b=50 where b=5; |
| 11 |
xa end '1'; |
| 12 |
xa prepare '1'; |
| 13 |
# Create T2 |
| 14 |
connection server_1; |
| 15 |
update t1 set b=10 where a=5; |
| 16 |
connection master; |
| 17 |
xa commit '1'; |
| 18 |
connection server_1; |
| 19 |
include/save_master_gtid.inc |
| 20 |
# This would hang prior to MDEV-21117 |
| 21 |
connection slave; |
| 22 |
include/sync_with_master_gtid.inc |
| 23 |
connection master; |
| 24 |
drop table t1, t2; |
| 25 |
include/rpl_end.inc |
| 26 |
# End of rpl_xa_2pc_multi_engine.test |