--let $rpl_server_count= 2 --source include/have_group_replication_plugin.inc --source include/group_replication.inc connect (conn1,127.0.0.1,root,,test,$SERVER_MYPORT_1,); connect (conn2,127.0.0.1,root,,test,$SERVER_MYPORT_2,); --echo [connect conn1] connection conn1; SELECT * from performance_schema.replication_group_members; CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT); INSERT INTO t1 VALUES (1,1); --source include/rpl_sync.inc connect (conn1_1,127.0.0.1,root,,test,$SERVER_MYPORT_1,); connect (conn1_2,127.0.0.1,root,,test,$SERVER_MYPORT_1,); --echo [connect conn1_1] connection conn1_1; FLUSH LOGS; XA START '1'; INSERT INTO t1 VALUES (2,2); XA END '1'; XA PREPARE '1'; SET SESSION DEBUG='+d,xa_commit_sleep'; send XA COMMIT '1'; --echo [connect conn1_2] connection conn1_2; STOP GROUP_REPLICATION; --echo [connect conn1_1] connection conn1_1; --error ER_RUN_HOOK_ERROR reap; SET SESSION DEBUG='-d,xa_commit_failed'; XA RECOVER; SELECT * FROM t1; SHOW BINLOG EVENTS IN 'server-binary-log.000002'; --echo [connect conn1] connection conn1; START GROUP_REPLICATION; --echo [connect conn2] connection conn2; XA RECOVER; SELECT * FROM t1; XA COMMIT '1'; XA RECOVER; SELECT * FROM t1; sleep 5; SELECT * from performance_schema.replication_group_members; --echo [connect conn1] connection conn1; SELECT * from performance_schema.replication_group_members; disconnect conn1; disconnect conn1_1; disconnect conn1_2; disconnect conn2;