Replication fails when XA transactions are used where the slave has replicate_do_db set and the client has touched a different database when running DML such as inserts.

[mariadb]

log-bin

server_id=1

log-basename=master-mariadb

CREATE SCHEMA srcschema;

USE srcschema;

CREATE TABLE `srctable`

(

    `srcidentity` int(11) NOT NULL,

    `srcnumber`   int(11) NOT NULL,

    PRIMARY KEY (`srcidentity`)

) ENGINE = InnoDB

  DEFAULT CHARSET = utf8

  COLLATE = utf8_general_ci;

CREATE SCHEMA junkschema;

USE junkschema;

CREATE TABLE `junktable`

(

    `srcidentity` int(11) NOT NULL,

    `srcnumber`   int(11) NOT NULL,

    PRIMARY KEY (`srcidentity`)

) ENGINE = InnoDB

  DEFAULT CHARSET = utf8

  COLLATE = utf8_general_ci

[mariadb]

server_id=2

log-basename=slave-mariadb

replicate_do_db=srcschema

replicate_wild_do_table=srcschema.%

XA START 'testtx1';

USE junkschema;

INSERT INTO srcschema.srctable (srcidentity,srcnumber) VALUES (2,2);

XA END 'testtx1';

XA PREPARE 'testtx1';

XA COMMIT 'testtx1';

XA START 'testtx1';

INSERT INTO srcschema.srctable (srcidentity,srcnumber) VALUES (1,1);

XA END 'testtx1';

XA PREPARE 'testtx1';

XA COMMIT 'testtx1';

XA START 'testtx1';

USE junkschema;

INSERT INTO junkschema.junktable (srcidentity,srcnumber) VALUES (1,1);

XA END 'testtx1';

XA PREPARE 'testtx1';

XA COMMIT 'testtx1';

XA START 'testtx1';

USE srcschema;

INSERT INTO srcschema.srctable (srcidentity,srcnumber) VALUES (1,1);

XA END 'testtx1';

XA PREPARE 'testtx1';

XA COMMIT 'testtx1';

database_bugged_slave_setup-slave-1   | 2024-04-17  5:33:44 4 [Note] Slave I/O thread: connected to master 'slave_user@mariadb-master:3306',replication started in log 'FIRST' at position 4

database_bugged_slave_setup-master-1  | 2024-04-17  5:33:44 4 [Note] Start binlog_dump to slave_server(2), pos(, 4), using_gtid(0), gtid('')

database_bugged_slave_setup-slave-1   | 2024-04-17  5:33:46 5 [ERROR] Slave SQL: XAER_RMFAIL: The command cannot be executed when global transaction is in the  ACTIVE state, Gtid 0-1-7, Internal MariaDB error code: 1399

database_bugged_slave_setup-slave-1   | 2024-04-17  5:33:46 5 [Warning] Slave: XAER_RMFAIL: The command cannot be executed when global transaction is in the  ACTIVE state Error_code: 1399

database_bugged_slave_setup-slave-1   | 2024-04-17  5:33:46 5 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-mariadb-bin.000002' position 351

database_bugged_slave_setup-slave-1   | 2024-04-17  5:33:46 5 [Note] Slave SQL thread exiting, replication stopped in log 'master-mariadb-bin.000002' at position 351

database_bugged_slave_setup-slave-1   | 2024-04-17  5:33:46 5 [Note] master was mariadb-master:3306