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

Presence of Spider on a replica breaks XA replication

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
      --source include/master-slave.inc
       
      --connection slave
      INSTALL SONAME 'ha_spider';
       
      --connection master
      CREATE TABLE t (a INT) ENGINE=InnoDB;
      XA START 'x';
      INSERT INTO t VALUES (1),(2);
      XA END 'x';
      XA PREPARE 'x';
      XA COMMIT 'x';
       
      --sync_slave_with_master
       
      --connection master
      DROP TABLE t;
      --source include/rpl_end.inc
      

      10.6 e5994025bec0d34ddef25df2e252b8f1d2e34e51

      2025-10-27 19:37:50 7 [ERROR] Slave SQL: Error 'This xid does not exist' on query. Default database: 'test'. Query: 'XA COMMIT X'78',X'',1', Gtid 0-1-3, Internal MariaDB error code: 12607
      

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: