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

Replication stops while using XA with Myisam table

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
    • 10.5, 10.6
    • Replication
    • None

    Description

      --source include/master-slave.inc
       
      --connection master
      create table t1 (c1 int,c2 int)engine=myisam;
      insert into t1 values(1,1),(2,2);
       
      xa start 'xa';
      update t1 set c1=3 where c2=2;
      xa end 'xa';
      xa prepare 'xa';
      xa commit 'xa';
       
      sync_slave_with_master;
      

      Last_Error	Error 'XAER_NOTA: Unknown XID' on query. Default database: 'test'. Query: 'XA COMMIT X'7861',X'',1'
      

      **** 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.5.6-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 (c1 int,c2 int)engine=myisam
      master-bin.000001	482	Gtid	1	524	BEGIN GTID 0-1-2
      master-bin.000001	524	Query	1	623	use `test`; insert into t1 values(1,1),(2,2)
      master-bin.000001	623	Query	1	696	COMMIT
      master-bin.000001	696	Gtid	1	738	BEGIN GTID 0-1-3
      master-bin.000001	738	Query	1	834	use `test`; update t1 set c1=3 where c2=2
      master-bin.000001	834	Query	1	907	COMMIT
      master-bin.000001	907	Gtid	1	951	GTID 0-1-4
      master-bin.000001	951	Query	1	1041	XA COMMIT X'7861',X'',1
      
      

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              alice Alice Sherepa
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.