--disable_warnings create database if not exists test; drop table if exists t1; drop user if exists user1@localhost; drop user if exists user2@localhost; create user user1@localhost, user2@localhost; grant ALL on *.* to user1@localhost; grant ALL on *.* to user2@localhost; flush privileges; --enable_warnings create table t1 (a int) engine=innodb; connect (con1, localhost, user1, , ); connect (con2, localhost, user2, , ); --connection con1 xa start 'test1'; insert t1 values (10); --connection con2 set debug='+d,simulate_delay_after_xa_start_disconnect'; --send xa recover --connection con1 disconnect con1; --source include/wait_until_disconnected.inc --connection con2 --reap connection default;