rpl.rpl_parallel_xa_same_xid failed in bb, sync_with_master failed:

rpl.rpl_parallel_xa_same_xid 'innodb,mix' w2 [ fail ]

        Test ended at 2021-03-08 19:25:00

CURRENT_TEST: rpl.rpl_parallel_xa_same_xid

analyze: sync_with_master

mysqltest: In included file "./include/sync_slave_sql_with_master.inc": 

included from /usr/share/mysql-test/suite/rpl/t/rpl_parallel_xa_same_xid.test at line 123:

At line 49: sync_with_master failed: 'select master_pos_wait('master-bin.000001', 600964, 300, '')' returned NULL indicating slave SQL thread failure

The result from queries just before the failure was:

include/master-slave.inc

[connection master]

connection slave;

call mtr.add_suppression("WSREP: handlerton rollback failed");

include/stop_slave.inc

ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;

SET @old_parallel_threads = @@GLOBAL.slave_parallel_threads;

SET @old_parallel_mode               = @@GLOBAL.slave_parallel_mode;

SET @@global.slave_parallel_mode     ='optimistic';

include/start_slave.inc

connection master;

CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB;

CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, b INT) ENGINE=InnoDB;

include/sync_slave_sql_with_master.inc

 == /dev/shm/var/2/tmp/analyze-sync_with_master-mysqld.1.err ==

############################## default ##############################

**** SHOW WARNINGS on default ****

SHOW WARNINGS;

Level	Code	Message

**** SELECT replication-related variables on default ****

SELECT NOW(), @@SERVER_ID;

NOW()	@@SERVER_ID

2021-03-08 19:24:59	1

**** SHOW SLAVE STATUS on default ****

SHOW SLAVE STATUS;

**** SHOW MASTER STATUS on default ****

SHOW MASTER STATUS;

File	master-bin.000001

Position	600964

Binlog_Do_DB	

Binlog_Ignore_DB	

**** SHOW SLAVE HOSTS on default ****

SHOW SLAVE HOSTS;

Server_id	2

Host	127.0.0.1

Port	16001

Master_id	1

**** SHOW PROCESSLIST on default ****

SHOW PROCESSLIST;

Id	User	Host	db	Command	Time	State	Info	Progress

11	root	localhost:47044	NULL	Binlog Dump	7	Master has sent all binlog to slave; waiting for more updates	NULL	0.000

12	root	localhost	NULL	Query	0	starting	SHOW PROCESSLIST	0.000

**** SHOW BINARY LOGS on default ****

SHOW BINARY LOGS;

Log_name	File_size

master-bin.000001	600964

**** SHOW BINLOG EVENTS on default ****

binlog_name = 'master-bin.000001'

SHOW BINLOG EVENTS IN 'master-bin.000001';

Log_name	Pos	Event_type	Server_id	End_log_pos	Info

master-bin.000001	4	Format_desc	1	256	Server ver: 10.6.0-MariaDB-debug-log, Binlog ver: 4

master-bin.000001	256	Gtid_list	1	285	[]

master-bin.000001	285	Binlog_checkpoint	1	329	master-bin.000001

master-bin.000001	329	Gtid	1	371	GTID 0-1-1

master-bin.000001	371	Query	1	482	use `test`; CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB

master-bin.000001	482	Gtid	1	524	BEGIN GTID 0-1-2

master-bin.000001	524	Query	1	620	use `test`; INSERT INTO t1 SET a=19, b=17

master-bin.000001	620	Xid	1	651	COMMIT /* xid=149 */

master-bin.000001	651	Gtid	1	699	XA START X'7869645f3139',X'',1 GTID 0-1-3

master-bin.000001	699	Query	1	795	use `test`; INSERT INTO t1 SET a=19, b=16

master-bin.000001	795	Query	1	890	XA END X'7869645f3139',X'',1

master-bin.000001	890	XA_prepare	1	932	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	932	Gtid	1	980	GTID 0-1-4

master-bin.000001	980	Query	1	1078	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	1078	Gtid	1	1126	XA START X'7869645f3139',X'',1 GTID 0-1-5

master-bin.000001	1126	Query	1	1222	use `test`; INSERT INTO t1 SET a=19, b=16

master-bin.000001	1222	Query	1	1317	XA END X'7869645f3139',X'',1

master-bin.000001	1317	XA_prepare	1	1359	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	1359	Gtid	1	1407	GTID 0-1-6

master-bin.000001	1407	Query	1	1507	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	1507	Gtid	1	1555	XA START X'7869645f3139',X'',1 GTID 0-1-7

master-bin.000001	1555	Query	1	1651	use `test`; INSERT INTO t1 SET a=19, b=15

master-bin.000001	1651	Query	1	1746	XA END X'7869645f3139',X'',1

master-bin.000001	1746	XA_prepare	1	1788	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	1788	Gtid	1	1836	GTID 0-1-8

master-bin.000001	1836	Query	1	1934	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	1934	Gtid	1	1982	XA START X'7869645f3139',X'',1 GTID 0-1-9

master-bin.000001	1982	Query	1	2078	use `test`; INSERT INTO t1 SET a=19, b=15

master-bin.000001	2078	Query	1	2173	XA END X'7869645f3139',X'',1

master-bin.000001	2173	XA_prepare	1	2215	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	2215	Gtid	1	2263	GTID 0-1-10

master-bin.000001	2263	Query	1	2363	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	2363	Gtid	1	2411	XA START X'7869645f3139',X'',1 GTID 0-1-11

master-bin.000001	2411	Query	1	2507	use `test`; INSERT INTO t1 SET a=19, b=14

master-bin.000001	2507	Query	1	2602	XA END X'7869645f3139',X'',1

master-bin.000001	2602	XA_prepare	1	2644	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	2644	Gtid	1	2692	GTID 0-1-12

master-bin.000001	2692	Query	1	2790	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	2790	Gtid	1	2838	XA START X'7869645f3139',X'',1 GTID 0-1-13

master-bin.000001	2838	Query	1	2934	use `test`; INSERT INTO t1 SET a=19, b=14

master-bin.000001	2934	Query	1	3029	XA END X'7869645f3139',X'',1

master-bin.000001	3029	XA_prepare	1	3071	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	3071	Gtid	1	3119	GTID 0-1-14

master-bin.000001	3119	Query	1	3219	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	3219	Gtid	1	3267	XA START X'7869645f3139',X'',1 GTID 0-1-15

master-bin.000001	3267	Query	1	3363	use `test`; INSERT INTO t1 SET a=19, b=13

master-bin.000001	3363	Query	1	3458	XA END X'7869645f3139',X'',1

master-bin.000001	3458	XA_prepare	1	3500	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	3500	Gtid	1	3548	GTID 0-1-16

master-bin.000001	3548	Query	1	3646	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	3646	Gtid	1	3694	XA START X'7869645f3139',X'',1 GTID 0-1-17

master-bin.000001	3694	Query	1	3790	use `test`; INSERT INTO t1 SET a=19, b=13

master-bin.000001	3790	Query	1	3885	XA END X'7869645f3139',X'',1

master-bin.000001	3885	XA_prepare	1	3927	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	3927	Gtid	1	3975	GTID 0-1-18

master-bin.000001	3975	Query	1	4075	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	4075	Gtid	1	4123	XA START X'7869645f3139',X'',1 GTID 0-1-19

master-bin.000001	4123	Query	1	4219	use `test`; INSERT INTO t1 SET a=19, b=12

master-bin.000001	4219	Query	1	4314	XA END X'7869645f3139',X'',1

master-bin.000001	4314	XA_prepare	1	4356	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	4356	Gtid	1	4404	GTID 0-1-20

master-bin.000001	4404	Query	1	4502	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	4502	Gtid	1	4550	XA START X'7869645f3139',X'',1 GTID 0-1-21

master-bin.000001	4550	Query	1	4646	use `test`; INSERT INTO t1 SET a=19, b=12

master-bin.000001	4646	Query	1	4741	XA END X'7869645f3139',X'',1

master-bin.000001	4741	XA_prepare	1	4783	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	4783	Gtid	1	4831	GTID 0-1-22

master-bin.000001	4831	Query	1	4931	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	4931	Gtid	1	4979	XA START X'7869645f3139',X'',1 GTID 0-1-23

master-bin.000001	4979	Query	1	5075	use `test`; INSERT INTO t1 SET a=19, b=11

master-bin.000001	5075	Query	1	5170	XA END X'7869645f3139',X'',1

master-bin.000001	5170	XA_prepare	1	5212	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	5212	Gtid	1	5260	GTID 0-1-24

master-bin.000001	5260	Query	1	5358	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	5358	Gtid	1	5406	XA START X'7869645f3139',X'',1 GTID 0-1-25

master-bin.000001	5406	Query	1	5502	use `test`; INSERT INTO t1 SET a=19, b=11

master-bin.000001	5502	Query	1	5597	XA END X'7869645f3139',X'',1

master-bin.000001	5597	XA_prepare	1	5639	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	5639	Gtid	1	5687	GTID 0-1-26

master-bin.000001	5687	Query	1	5787	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	5787	Gtid	1	5835	XA START X'7869645f3139',X'',1 GTID 0-1-27

master-bin.000001	5835	Query	1	5931	use `test`; INSERT INTO t1 SET a=19, b=10

master-bin.000001	5931	Query	1	6026	XA END X'7869645f3139',X'',1

master-bin.000001	6026	XA_prepare	1	6068	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	6068	Gtid	1	6116	GTID 0-1-28

master-bin.000001	6116	Query	1	6214	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	6214	Gtid	1	6262	XA START X'7869645f3139',X'',1 GTID 0-1-29

master-bin.000001	6262	Query	1	6358	use `test`; INSERT INTO t1 SET a=19, b=10

master-bin.000001	6358	Query	1	6453	XA END X'7869645f3139',X'',1

master-bin.000001	6453	XA_prepare	1	6495	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	6495	Gtid	1	6543	GTID 0-1-30

master-bin.000001	6543	Query	1	6643	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	6643	Gtid	1	6685	BEGIN GTID 0-1-31

master-bin.000001	6685	Query	1	6780	use `test`; INSERT INTO t1 SET a=19, b=9

master-bin.000001	6780	Xid	1	6811	COMMIT /* xid=231 */

master-bin.000001	6811	Gtid	1	6859	XA START X'7869645f3139',X'',1 GTID 0-1-32

master-bin.000001	6859	Query	1	6954	use `test`; INSERT INTO t1 SET a=19, b=8

master-bin.000001	6954	Query	1	7049	XA END X'7869645f3139',X'',1

master-bin.000001	7049	XA_prepare	1	7091	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	7091	Gtid	1	7139	GTID 0-1-33

master-bin.000001	7139	Query	1	7237	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	7237	Gtid	1	7285	XA START X'7869645f3139',X'',1 GTID 0-1-34

master-bin.000001	7285	Query	1	7380	use `test`; INSERT INTO t1 SET a=19, b=8

master-bin.000001	7380	Query	1	7475	XA END X'7869645f3139',X'',1

master-bin.000001	7475	XA_prepare	1	7517	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	7517	Gtid	1	7565	GTID 0-1-35

master-bin.000001	7565	Query	1	7665	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	7665	Gtid	1	7707	BEGIN GTID 0-1-36

master-bin.000001	7707	Query	1	7802	use `test`; INSERT INTO t1 SET a=19, b=7

master-bin.000001	7802	Xid	1	7833	COMMIT /* xid=247 */

master-bin.000001	7833	Gtid	1	7875	BEGIN GTID 0-1-37

master-bin.000001	7875	Query	1	7970	use `test`; INSERT INTO t1 SET a=19, b=6

master-bin.000001	7970	Xid	1	8001	COMMIT /* xid=252 */

master-bin.000001	8001	Gtid	1	8049	XA START X'7869645f3139',X'',1 GTID 0-1-38

master-bin.000001	8049	Query	1	8144	use `test`; INSERT INTO t1 SET a=19, b=5

master-bin.000001	8144	Query	1	8239	XA END X'7869645f3139',X'',1

master-bin.000001	8239	XA_prepare	1	8281	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	8281	Gtid	1	8329	GTID 0-1-39

master-bin.000001	8329	Query	1	8427	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	8427	Gtid	1	8475	XA START X'7869645f3139',X'',1 GTID 0-1-40

master-bin.000001	8475	Query	1	8570	use `test`; INSERT INTO t1 SET a=19, b=5

master-bin.000001	8570	Query	1	8665	XA END X'7869645f3139',X'',1

master-bin.000001	8665	XA_prepare	1	8707	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	8707	Gtid	1	8755	GTID 0-1-41

master-bin.000001	8755	Query	1	8855	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	8855	Gtid	1	8903	XA START X'7869645f3139',X'',1 GTID 0-1-42

master-bin.000001	8903	Query	1	8998	use `test`; INSERT INTO t1 SET a=19, b=4

master-bin.000001	8998	Query	1	9093	XA END X'7869645f3139',X'',1

master-bin.000001	9093	XA_prepare	1	9135	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	9135	Gtid	1	9183	GTID 0-1-43

master-bin.000001	9183	Query	1	9281	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	9281	Gtid	1	9329	XA START X'7869645f3139',X'',1 GTID 0-1-44

master-bin.000001	9329	Query	1	9424	use `test`; INSERT INTO t1 SET a=19, b=4

master-bin.000001	9424	Query	1	9519	XA END X'7869645f3139',X'',1

master-bin.000001	9519	XA_prepare	1	9561	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	9561	Gtid	1	9609	GTID 0-1-45

master-bin.000001	9609	Query	1	9709	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	9709	Gtid	1	9757	XA START X'7869645f3139',X'',1 GTID 0-1-46

master-bin.000001	9757	Query	1	9852	use `test`; INSERT INTO t1 SET a=19, b=3

master-bin.000001	9852	Query	1	9947	XA END X'7869645f3139',X'',1

master-bin.000001	9947	XA_prepare	1	9989	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	9989	Gtid	1	10037	GTID 0-1-47

master-bin.000001	10037	Query	1	10135	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	10135	Gtid	1	10183	XA START X'7869645f3139',X'',1 GTID 0-1-48

master-bin.000001	10183	Query	1	10278	use `test`; INSERT INTO t1 SET a=19, b=3

master-bin.000001	10278	Query	1	10373	XA END X'7869645f3139',X'',1

master-bin.000001	10373	XA_prepare	1	10415	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	10415	Gtid	1	10463	GTID 0-1-49

master-bin.000001	10463	Query	1	10563	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	10563	Gtid	1	10605	BEGIN GTID 0-1-50

master-bin.000001	10605	Query	1	10700	use `test`; INSERT INTO t1 SET a=19, b=2

master-bin.000001	10700	Xid	1	10731	COMMIT /* xid=290 */

master-bin.000001	10731	Gtid	1	10779	XA START X'7869645f3139',X'',1 GTID 0-1-51

master-bin.000001	10779	Query	1	10874	use `test`; INSERT INTO t1 SET a=19, b=1

master-bin.000001	10874	Query	1	10969	XA END X'7869645f3139',X'',1

master-bin.000001	10969	XA_prepare	1	11011	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	11011	Gtid	1	11059	GTID 0-1-52

master-bin.000001	11059	Query	1	11157	XA COMMIT X'7869645f3139',X'',1

master-bin.000001	11157	Gtid	1	11205	XA START X'7869645f3139',X'',1 GTID 0-1-53

master-bin.000001	11205	Query	1	11300	use `test`; INSERT INTO t1 SET a=19, b=1

master-bin.000001	11300	Query	1	11395	XA END X'7869645f3139',X'',1

master-bin.000001	11395	XA_prepare	1	11437	XA PREPARE X'7869645f3139',X'',1

master-bin.000001	11437	Gtid	1	11485	GTID 0-1-54

master-bin.000001	11485	Query	1	11585	XA ROLLBACK X'7869645f3139',X'',1

master-bin.000001	11585	Gtid	1	11627	BEGIN GTID 0-1-55

master-bin.000001	11627	Query	1	11723	use `test`; INSERT INTO t1 SET a=18, b=17

master-bin.000001	11723	Xid	1	11754	COMMIT /* xid=306 */

master-bin.000001	11754	Gtid	1	11802	XA START X'7869645f3138',X'',1 GTID 0-1-56

master-bin.000001	11802	Query	1	11898	use `test`; INSERT INTO t1 SET a=18, b=16

master-bin.000001	11898	Query	1	11993	XA END X'7869645f3138',X'',1

master-bin.000001	11993	XA_prepare	1	12035	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	12035	Gtid	1	12083	GTID 0-1-57

master-bin.000001	12083	Query	1	12181	XA COMMIT X'7869645f3138',X'',1

master-bin.000001	12181	Gtid	1	12229	XA START X'7869645f3138',X'',1 GTID 0-1-58

master-bin.000001	12229	Query	1	12325	use `test`; INSERT INTO t1 SET a=18, b=16

master-bin.000001	12325	Query	1	12420	XA END X'7869645f3138',X'',1

master-bin.000001	12420	XA_prepare	1	12462	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	12462	Gtid	1	12510	GTID 0-1-59

master-bin.000001	12510	Query	1	12610	XA ROLLBACK X'7869645f3138',X'',1

master-bin.000001	12610	Gtid	1	12652	BEGIN GTID 0-1-60

master-bin.000001	12652	Query	1	12748	use `test`; INSERT INTO t1 SET a=18, b=15

master-bin.000001	12748	Xid	1	12779	COMMIT /* xid=322 */

master-bin.000001	12779	Gtid	1	12821	BEGIN GTID 0-1-61

master-bin.000001	12821	Query	1	12917	use `test`; INSERT INTO t1 SET a=18, b=14

master-bin.000001	12917	Xid	1	12948	COMMIT /* xid=327 */

master-bin.000001	12948	Gtid	1	12996	XA START X'7869645f3138',X'',1 GTID 0-1-62

master-bin.000001	12996	Query	1	13092	use `test`; INSERT INTO t1 SET a=18, b=13

master-bin.000001	13092	Query	1	13187	XA END X'7869645f3138',X'',1

master-bin.000001	13187	XA_prepare	1	13229	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	13229	Gtid	1	13277	GTID 0-1-63

master-bin.000001	13277	Query	1	13375	XA COMMIT X'7869645f3138',X'',1

master-bin.000001	13375	Gtid	1	13423	XA START X'7869645f3138',X'',1 GTID 0-1-64

master-bin.000001	13423	Query	1	13519	use `test`; INSERT INTO t1 SET a=18, b=13

master-bin.000001	13519	Query	1	13614	XA END X'7869645f3138',X'',1

master-bin.000001	13614	XA_prepare	1	13656	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	13656	Gtid	1	13704	GTID 0-1-65

master-bin.000001	13704	Query	1	13804	XA ROLLBACK X'7869645f3138',X'',1

master-bin.000001	13804	Gtid	1	13852	XA START X'7869645f3138',X'',1 GTID 0-1-66

master-bin.000001	13852	Query	1	13948	use `test`; INSERT INTO t1 SET a=18, b=12

master-bin.000001	13948	Query	1	14043	XA END X'7869645f3138',X'',1

master-bin.000001	14043	XA_prepare	1	14085	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	14085	Gtid	1	14133	GTID 0-1-67

master-bin.000001	14133	Query	1	14231	XA COMMIT X'7869645f3138',X'',1

master-bin.000001	14231	Gtid	1	14279	XA START X'7869645f3138',X'',1 GTID 0-1-68

master-bin.000001	14279	Query	1	14375	use `test`; INSERT INTO t1 SET a=18, b=12

master-bin.000001	14375	Query	1	14470	XA END X'7869645f3138',X'',1

master-bin.000001	14470	XA_prepare	1	14512	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	14512	Gtid	1	14560	GTID 0-1-69

master-bin.000001	14560	Query	1	14660	XA ROLLBACK X'7869645f3138',X'',1

master-bin.000001	14660	Gtid	1	14702	BEGIN GTID 0-1-70

master-bin.000001	14702	Query	1	14798	use `test`; INSERT INTO t1 SET a=18, b=11

master-bin.000001	14798	Xid	1	14829	COMMIT /* xid=354 */

master-bin.000001	14829	Gtid	1	14877	XA START X'7869645f3138',X'',1 GTID 0-1-71

master-bin.000001	14877	Query	1	14973	use `test`; INSERT INTO t1 SET a=18, b=10

master-bin.000001	14973	Query	1	15068	XA END X'7869645f3138',X'',1

master-bin.000001	15068	XA_prepare	1	15110	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	15110	Gtid	1	15158	GTID 0-1-72

master-bin.000001	15158	Query	1	15256	XA COMMIT X'7869645f3138',X'',1

master-bin.000001	15256	Gtid	1	15304	XA START X'7869645f3138',X'',1 GTID 0-1-73

master-bin.000001	15304	Query	1	15400	use `test`; INSERT INTO t1 SET a=18, b=10

master-bin.000001	15400	Query	1	15495	XA END X'7869645f3138',X'',1

master-bin.000001	15495	XA_prepare	1	15537	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	15537	Gtid	1	15585	GTID 0-1-74

master-bin.000001	15585	Query	1	15685	XA ROLLBACK X'7869645f3138',X'',1

master-bin.000001	15685	Gtid	1	15727	BEGIN GTID 0-1-75

master-bin.000001	15727	Query	1	15822	use `test`; INSERT INTO t1 SET a=18, b=9

master-bin.000001	15822	Xid	1	15853	COMMIT /* xid=370 */

master-bin.000001	15853	Gtid	1	15901	XA START X'7869645f3138',X'',1 GTID 0-1-76

master-bin.000001	15901	Query	1	15996	use `test`; INSERT INTO t1 SET a=18, b=8

master-bin.000001	15996	Query	1	16091	XA END X'7869645f3138',X'',1

master-bin.000001	16091	XA_prepare	1	16133	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	16133	Gtid	1	16181	GTID 0-1-77

master-bin.000001	16181	Query	1	16279	XA COMMIT X'7869645f3138',X'',1

master-bin.000001	16279	Gtid	1	16327	XA START X'7869645f3138',X'',1 GTID 0-1-78

master-bin.000001	16327	Query	1	16422	use `test`; INSERT INTO t1 SET a=18, b=8

master-bin.000001	16422	Query	1	16517	XA END X'7869645f3138',X'',1

master-bin.000001	16517	XA_prepare	1	16559	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	16559	Gtid	1	16607	GTID 0-1-79

master-bin.000001	16607	Query	1	16707	XA ROLLBACK X'7869645f3138',X'',1

master-bin.000001	16707	Gtid	1	16749	BEGIN GTID 0-1-80

master-bin.000001	16749	Query	1	16844	use `test`; INSERT INTO t1 SET a=18, b=7

master-bin.000001	16844	Xid	1	16875	COMMIT /* xid=386 */

master-bin.000001	16875	Gtid	1	16917	BEGIN GTID 0-1-81

master-bin.000001	16917	Query	1	17012	use `test`; INSERT INTO t1 SET a=18, b=6

master-bin.000001	17012	Xid	1	17043	COMMIT /* xid=391 */

master-bin.000001	17043	Gtid	1	17091	XA START X'7869645f3138',X'',1 GTID 0-1-82

master-bin.000001	17091	Query	1	17186	use `test`; INSERT INTO t1 SET a=18, b=5

master-bin.000001	17186	Query	1	17281	XA END X'7869645f3138',X'',1

master-bin.000001	17281	XA_prepare	1	17323	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	17323	Gtid	1	17371	GTID 0-1-83

master-bin.000001	17371	Query	1	17469	XA COMMIT X'7869645f3138',X'',1

master-bin.000001	17469	Gtid	1	17517	XA START X'7869645f3138',X'',1 GTID 0-1-84

master-bin.000001	17517	Query	1	17612	use `test`; INSERT INTO t1 SET a=18, b=5

master-bin.000001	17612	Query	1	17707	XA END X'7869645f3138',X'',1

master-bin.000001	17707	XA_prepare	1	17749	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	17749	Gtid	1	17797	GTID 0-1-85

master-bin.000001	17797	Query	1	17897	XA ROLLBACK X'7869645f3138',X'',1

master-bin.000001	17897	Gtid	1	17939	BEGIN GTID 0-1-86

master-bin.000001	17939	Query	1	18034	use `test`; INSERT INTO t1 SET a=18, b=4

master-bin.000001	18034	Xid	1	18065	COMMIT /* xid=407 */

master-bin.000001	18065	Gtid	1	18113	XA START X'7869645f3138',X'',1 GTID 0-1-87

master-bin.000001	18113	Query	1	18208	use `test`; INSERT INTO t1 SET a=18, b=3

master-bin.000001	18208	Query	1	18303	XA END X'7869645f3138',X'',1

master-bin.000001	18303	XA_prepare	1	18345	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	18345	Gtid	1	18393	GTID 0-1-88

master-bin.000001	18393	Query	1	18491	XA COMMIT X'7869645f3138',X'',1

master-bin.000001	18491	Gtid	1	18539	XA START X'7869645f3138',X'',1 GTID 0-1-89

master-bin.000001	18539	Query	1	18634	use `test`; INSERT INTO t1 SET a=18, b=3

master-bin.000001	18634	Query	1	18729	XA END X'7869645f3138',X'',1

master-bin.000001	18729	XA_prepare	1	18771	XA PREPARE X'7869645f3138',X'',1

master-bin.000001	18771	Gtid	1	18819	GTID 0-1-90

master-bin.000001	18819	Query	1	18919	XA ROLLBACK X'7869645f3138',X'',1

master-bin.000001	18919	Gtid	1	18961	BEGIN GTID 0-1-91

master-bin.000001	18961	Query	1	19056	use `test`; INSERT INTO t1 SET a=18, b=2

master-bin.000001	19056	Xid	1	19087	COMMIT /* xid=423 */

master-bin.000001	19087	Gtid	1	19129	BEGIN GTID 0-1-92

master-bin.000001	19129	Query	1	19224	use `test`; INSERT INTO t1 SET a=18, b=1

master-bin.000001	19224	Xid	1	19255	COMMIT /* xid=428 */

master-bin.000001	19255	Gtid	1	19297	BEGIN GTID 0-1-93

master-bin.000001	19297	Query	1	19393	use `test`; INSERT INTO t1 SET a=17, b=17

master-bin.000001	19393	Xid	1	19424	COMMIT /* xid=433 */

master-bin.000001	19424	Gtid	1	19472	XA START X'7869645f3137',X'',1 GTID 0-1-94

master-bin.000001	19472	Query	1	19568	use `test`; INSERT INTO t1 SET a=17, b=16

master-bin.000001	19568	Query	1	19663	XA END X'7869645f3137',X'',1

master-bin.000001	19663	XA_prepare	1	19705	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	19705	Gtid	1	19753	GTID 0-1-95

master-bin.000001	19753	Query	1	19851	XA COMMIT X'7869645f3137',X'',1

master-bin.000001	19851	Gtid	1	19899	XA START X'7869645f3137',X'',1 GTID 0-1-96

master-bin.000001	19899	Query	1	19995	use `test`; INSERT INTO t1 SET a=17, b=16

master-bin.000001	19995	Query	1	20090	XA END X'7869645f3137',X'',1

master-bin.000001	20090	XA_prepare	1	20132	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	20132	Gtid	1	20180	GTID 0-1-97

master-bin.000001	20180	Query	1	20280	XA ROLLBACK X'7869645f3137',X'',1

master-bin.000001	20280	Gtid	1	20322	BEGIN GTID 0-1-98

master-bin.000001	20322	Query	1	20418	use `test`; INSERT INTO t1 SET a=17, b=15

master-bin.000001	20418	Xid	1	20449	COMMIT /* xid=449 */

master-bin.000001	20449	Gtid	1	20491	BEGIN GTID 0-1-99

master-bin.000001	20491	Query	1	20587	use `test`; INSERT INTO t1 SET a=17, b=14

master-bin.000001	20587	Xid	1	20618	COMMIT /* xid=454 */

master-bin.000001	20618	Gtid	1	20666	XA START X'7869645f3137',X'',1 GTID 0-1-100

master-bin.000001	20666	Query	1	20762	use `test`; INSERT INTO t1 SET a=17, b=13

master-bin.000001	20762	Query	1	20857	XA END X'7869645f3137',X'',1

master-bin.000001	20857	XA_prepare	1	20899	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	20899	Gtid	1	20947	GTID 0-1-101

master-bin.000001	20947	Query	1	21045	XA COMMIT X'7869645f3137',X'',1

master-bin.000001	21045	Gtid	1	21093	XA START X'7869645f3137',X'',1 GTID 0-1-102

master-bin.000001	21093	Query	1	21189	use `test`; INSERT INTO t1 SET a=17, b=13

master-bin.000001	21189	Query	1	21284	XA END X'7869645f3137',X'',1

master-bin.000001	21284	XA_prepare	1	21326	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	21326	Gtid	1	21374	GTID 0-1-103

master-bin.000001	21374	Query	1	21474	XA ROLLBACK X'7869645f3137',X'',1

master-bin.000001	21474	Gtid	1	21522	XA START X'7869645f3137',X'',1 GTID 0-1-104

master-bin.000001	21522	Query	1	21618	use `test`; INSERT INTO t1 SET a=17, b=12

master-bin.000001	21618	Query	1	21713	XA END X'7869645f3137',X'',1

master-bin.000001	21713	XA_prepare	1	21755	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	21755	Gtid	1	21803	GTID 0-1-105

master-bin.000001	21803	Query	1	21901	XA COMMIT X'7869645f3137',X'',1

master-bin.000001	21901	Gtid	1	21949	XA START X'7869645f3137',X'',1 GTID 0-1-106

master-bin.000001	21949	Query	1	22045	use `test`; INSERT INTO t1 SET a=17, b=12

master-bin.000001	22045	Query	1	22140	XA END X'7869645f3137',X'',1

master-bin.000001	22140	XA_prepare	1	22182	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	22182	Gtid	1	22230	GTID 0-1-107

master-bin.000001	22230	Query	1	22330	XA ROLLBACK X'7869645f3137',X'',1

master-bin.000001	22330	Gtid	1	22372	BEGIN GTID 0-1-108

master-bin.000001	22372	Query	1	22468	use `test`; INSERT INTO t1 SET a=17, b=11

master-bin.000001	22468	Xid	1	22499	COMMIT /* xid=481 */

master-bin.000001	22499	Gtid	1	22547	XA START X'7869645f3137',X'',1 GTID 0-1-109

master-bin.000001	22547	Query	1	22643	use `test`; INSERT INTO t1 SET a=17, b=10

master-bin.000001	22643	Query	1	22738	XA END X'7869645f3137',X'',1

master-bin.000001	22738	XA_prepare	1	22780	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	22780	Gtid	1	22828	GTID 0-1-110

master-bin.000001	22828	Query	1	22926	XA COMMIT X'7869645f3137',X'',1

master-bin.000001	22926	Gtid	1	22974	XA START X'7869645f3137',X'',1 GTID 0-1-111

master-bin.000001	22974	Query	1	23070	use `test`; INSERT INTO t1 SET a=17, b=10

master-bin.000001	23070	Query	1	23165	XA END X'7869645f3137',X'',1

master-bin.000001	23165	XA_prepare	1	23207	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	23207	Gtid	1	23255	GTID 0-1-112

master-bin.000001	23255	Query	1	23355	XA ROLLBACK X'7869645f3137',X'',1

master-bin.000001	23355	Gtid	1	23403	XA START X'7869645f3137',X'',1 GTID 0-1-113

master-bin.000001	23403	Query	1	23498	use `test`; INSERT INTO t1 SET a=17, b=9

master-bin.000001	23498	Query	1	23593	XA END X'7869645f3137',X'',1

master-bin.000001	23593	XA_prepare	1	23635	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	23635	Gtid	1	23683	GTID 0-1-114

master-bin.000001	23683	Query	1	23781	XA COMMIT X'7869645f3137',X'',1

master-bin.000001	23781	Gtid	1	23829	XA START X'7869645f3137',X'',1 GTID 0-1-115

master-bin.000001	23829	Query	1	23924	use `test`; INSERT INTO t1 SET a=17, b=9

master-bin.000001	23924	Query	1	24019	XA END X'7869645f3137',X'',1

master-bin.000001	24019	XA_prepare	1	24061	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	24061	Gtid	1	24109	GTID 0-1-116

master-bin.000001	24109	Query	1	24209	XA ROLLBACK X'7869645f3137',X'',1

master-bin.000001	24209	Gtid	1	24251	BEGIN GTID 0-1-117

master-bin.000001	24251	Query	1	24346	use `test`; INSERT INTO t1 SET a=17, b=8

master-bin.000001	24346	Xid	1	24377	COMMIT /* xid=508 */

master-bin.000001	24377	Gtid	1	24419	BEGIN GTID 0-1-118

master-bin.000001	24419	Query	1	24514	use `test`; INSERT INTO t1 SET a=17, b=7

master-bin.000001	24514	Xid	1	24545	COMMIT /* xid=513 */

master-bin.000001	24545	Gtid	1	24593	XA START X'7869645f3137',X'',1 GTID 0-1-119

master-bin.000001	24593	Query	1	24688	use `test`; INSERT INTO t1 SET a=17, b=6

master-bin.000001	24688	Query	1	24783	XA END X'7869645f3137',X'',1

master-bin.000001	24783	XA_prepare	1	24825	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	24825	Gtid	1	24873	GTID 0-1-120

master-bin.000001	24873	Query	1	24971	XA COMMIT X'7869645f3137',X'',1

master-bin.000001	24971	Gtid	1	25019	XA START X'7869645f3137',X'',1 GTID 0-1-121

master-bin.000001	25019	Query	1	25114	use `test`; INSERT INTO t1 SET a=17, b=6

master-bin.000001	25114	Query	1	25209	XA END X'7869645f3137',X'',1

master-bin.000001	25209	XA_prepare	1	25251	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	25251	Gtid	1	25299	GTID 0-1-122

master-bin.000001	25299	Query	1	25399	XA ROLLBACK X'7869645f3137',X'',1

master-bin.000001	25399	Gtid	1	25447	XA START X'7869645f3137',X'',1 GTID 0-1-123

master-bin.000001	25447	Query	1	25542	use `test`; INSERT INTO t1 SET a=17, b=5

master-bin.000001	25542	Query	1	25637	XA END X'7869645f3137',X'',1

master-bin.000001	25637	XA_prepare	1	25679	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	25679	Gtid	1	25727	GTID 0-1-124

master-bin.000001	25727	Query	1	25825	XA COMMIT X'7869645f3137',X'',1

master-bin.000001	25825	Gtid	1	25873	XA START X'7869645f3137',X'',1 GTID 0-1-125

master-bin.000001	25873	Query	1	25968	use `test`; INSERT INTO t1 SET a=17, b=5

master-bin.000001	25968	Query	1	26063	XA END X'7869645f3137',X'',1

master-bin.000001	26063	XA_prepare	1	26105	XA PREPARE X'7869645f3137',X'',1

master-bin.000001	26105	Gtid	1	26153	GTID 0-1-126

master-bin.000001	26153	Query	1	26253	XA ROLLBACK X'7869645f3137',X'',1

master-bin.000001	26253	Gtid	1	26295	BEGIN GTID 0-1-127

master-bin.000001	26295	Query	1	26390	use `test`; INSERT INTO t1 SET a=17, b=4

master-bin.000001	26390	Xid	1	26421	COMMIT /* xid=540 */

master-bin.000001	26421	Gtid	1	26463	BEGIN GTID 0-1-128

master-bin.000001	26463	Query	1	26558	use `test`; INSERT INTO t1 SET a=17, b=3

master-bin.000001	26558	Xid	1	26589	COMMIT /* xid=545 */

master-bin.000001	26589	Gtid	1	26637	XA START X'7869645f3137',X'',1 GTID 0-1-129

master-bin.000001	26637	Query	1	26732	use `test`; INSERT INTO t1 SET a=17, b=2

master-bin.000001	26732	Query	1	26827	XA END X'7869645f3137',X'',1

master-bin.000001	26827	XA_prepare	1	26869	XA PREPARE X'7869645f3137',X'',1

# I addedd the full output as an attachment, it is too big for jira description

0	Query	1	600661	XA ROLLBACK X'7869645f31',X'',1

slave-relay-bin.000003	600888	Gtid	1	600703	GTID 0-1-2498

slave-relay-bin.000003	600930	Query	1	600811	use `test`; DROP TABLE `t1` /* generated by server */

slave-relay-bin.000003	601038	Gtid	1	600853	GTID 0-1-2499

slave-relay-bin.000003	601080	Query	1	600964	use `test`; CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB

connection default;