[#MDEV-31921] Replication Breaks after Recovering a Prepared-but-not-binlogged XA ONE PHASE Transaction

If the server crashes when executing a ONE PHASE XA transaction after it is prepared in the storage engine, but before it is binlogged, upon recovery, the binlogged transaction is incomplete. That is, only the XA COMMIT part of the transaction is logged, and the body of the XA transaction is lost. Consider the following MTR test which shows that an incomplete binary logging of a one phase XA transaction (only XA COMMIT '1' exists in the binary log when executing SHOW BINARY LOGS), and that replication breaks due to an unknown XID on query.

--source include/master-slave.inc

--source include/have_innodb.inc

#--source include/have_log_bin.inc

--source include/have_binlog_format_statement.inc

--echo #

--echo # Initialize test data

--connection master

create table t1 (a int) engine=innodb;

--source include/save_master_gtid.inc

--connection slave

--source include/sync_with_master_gtid.inc

--connection master

XA START '1';

insert into t1 values (1);

XA END '1';

--enable_reconnect

set session debug_dbug="+d,crash_commit_after_prepare";

# Write file to make mysql-test-run.pl expect crash

--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect

--error 2006,2013

XA COMMIT '1' ONE PHASE;

# Poll the server waiting for it to be back online again.

--source include/wait_until_connected_again.inc

XA RECOVER;

XA COMMIT '1';

show binlog events in 'master-bin.000002';

--source include/save_master_gtid.inc

--connection slave

--let $slave_sql_errno= 1397

--source include/wait_for_slave_sql_error.inc

--query_vertical SHOW SLAVE STATUS

die Quit early for error

--echo #

--echo # Cleanup

--connection master

DROP TABLE t1;

--source include/save_master_gtid.inc

--connection slave

--source include/sync_with_master_gtid.inc

--source include/rpl_end.inc

--echo # End of test

[MDEV-31921] Replication Breaks after Recovering a Prepared-but-not-binlogged XA ONE PHASE Transaction Created: 2023-08-14 Updated: 2023-11-28
Status:	Open
Project:	MariaDB Server
Component/s:	Replication
Affects Version/s:	10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0, 11.1
Fix Version/s:	10.5, 10.6, 10.11

[MDEV-31921] Replication Breaks after Recovering a Prepared-but-not-binlogged XA ONE PHASE Transaction Created: 2023-08-14 Updated: 2023-11-28