[MDEV-39302] main.xa wrong errno ER_XAER_NOTA instead of ER_XA_RBROLLBACK - Jira

XML

Word

Printable

https://buildbot.mariadb.org/#/builders/534/builds/31294 5ab153c2c
main.xa w11 [ fail ]
Test ended at 2025-10-17 15:53:20

CURRENT_TEST: main.xa
mysqltest: At line 721: query 'xa commit '3'' failed with wrong errno ER_XAER_NOTA (1397): 'XAER_NOTA: Unknown XID', instead of ER_XA_RBROLLBACK (1402)...

The result from queries just before the failure was:
< snip >
select 0;
0
0
xa end '2';
xa prepare '2';
xa rollback '2';
# Read-only disconnect case
connect con1_ro,localhost,root,,;
xa start '3';
select 0;
0
0
xa end '3';
xa prepare '3';
disconnect con1_ro;
connection default;
xa recover;
formatID gtrid_length bqual_length data
1 1 0 3
xa commit '3';

More results from queries before failure can be found in /home/buildbot/amd64-ubuntu-2204-debug-ps/build/mysql-test/var/11/log/xa.log

Also occurs where xa rollback '4' or 3.

Not a huge number a huge number of failures or deterministic.

relates to

MDEV-30978 On slave XA COMMIT/XA ROLLBACK fail to return an error in read-only mode

MDEV-36425 Extend read_only to also block share locks and super users

MDEV-36647 No red leaves in the forest

MDEV-39280 Fix unstable tests in BuildBot (GitHub PR testing)

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