Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.5.4
Description
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
|
Attachments
Issue Links
- is blocked by
-
MDEV-21602 CREATE TABLE…PRIMARY KEY…SELECT workaround causes DROP TABLE to ignore locks
- Closed
- 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
-
MDEV-30941 ASAN: heap-use-after-free in std::__atomic_base from trx_t::commit_tables on XA COMMIT with pseudo_slave_mode enabled
- Confirmed