[MDEV-22733] XA PREPARE breaks MDL in pseudo_slave_mode=1 - Jira

XML

Word

Printable

USE test;

CREATE TABLE t(a INT);

XA START '0';

SET pseudo_slave_mode=1;

INSERT INTO t VALUES(7050+0.75);

XA PREPARE '0';

XA END '0';

XA PREPARE '0';

TRUNCATE TABLE t;

# Shutdown to observe hang (mysqladmin shutdown will hang)

Will cause 10.5.4 8569dac1ec9f6853a0b2f3ea9bcbda67644ead24 (dbg+opt) to hang. Earlier releases not affected.

Note the difference on the last command:

10.4.14 ea7830eef48333e28f98a9b91f05a95735b465a3
10.4.14>TRUNCATE TABLE t;
ERROR 1399 (XAE07): XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state

is blocked by

MDEV-21602 CREATE TABLE…PRIMARY KEY…SELECT workaround causes DROP TABLE to ignore locks

is caused by

MDEV-742 LP:803649 - Xa recovery failed on client disconnection

relates to

MDEV-13564 TRUNCATE TABLE and undo tablespace truncation are not compatible with Mariabackup

MDEV-22769 Long semaphore wait upon DROP DATABASE with XA holding locks