Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25117

rpl.rpl_parallel_xa_same_xid failed in bb, sync_with_master failed:

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.6
    • Fix Version/s: 10.6
    • Component/s: Tests
    • Labels:
      None

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/5888/steps/mtr_centos_mix/logs/stdio

      10.6 37546842a954c2bd1

      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;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: