-
Type:
Bug
-
Status: Stalled (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.5.4
-
Fix Version/s: N/A
-
Component/s: XA
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.5.4 8569dac1ec9f6853a0b2f3ea9bcbda67644ead24 |
10.5.4>TRUNCATE TABLE t;
|
Query OK, 0 rows affected (0.013 sec)
|
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
-
- Confirmed
-
- is caused by
-
MDEV-742 LP:803649 - Xa recovery failed on client disconnection
-
- Closed
-
- relates to
-
MDEV-13564 TRUNCATE TABLE and undo tablespace truncation are not compatible with Mariabackup
-
- Closed
-
-
MDEV-22769 Long semaphore wait upon DROP DATABASE with XA holding locks
-
- Closed
-