--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,);

--echo [connect conn1]
connection conn1;
select * from performance_schema.replication_group_members;
SELECT @@super_read_only;
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT);
INSERT INTO t1 VALUES (1,1);

connect (conn1_1,127.0.0.1,root,,test,$SERVER_MYPORT_1,);
--echo [connect conn1_1]
connection conn1_1;
XA START '1';
INSERT INTO t1 VALUES (2,2);
XA END '1';
XA PREPARE '1';
disconnect conn1_1;

connect (conn1_2,127.0.0.1,root,,test,$SERVER_MYPORT_1,);
--echo [connect conn1_2]
connection conn1_2;
STOP GROUP_REPLICATION;
SELECT @@super_read_only;
--error 1290
INSERT INTO t1 VALUES (3,3);
XA COMMIT '1';
SELECT * FROM t1;
disconnect conn1;
disconnect conn1_2;

#--source include/group_replication_end.inc