Daniele Sciascia added a comment - 2021-02-25 10:43 I believe that trans_rollback_implicit() is missing the following check at the beginning: if (trans_check(thd)) DBUG_RETURN(TRUE);

Alice Sherepa added a comment - 2021-02-25 12:21 - edited MariaDB 10.0,10.1,10.4,10.5,10.6 behaves as in description. 10.2,10.3: 10.2 5ecaf52d42a1e464c MariaDB [test]> CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=Innodb; Query OK, 0 rows affected (0.05 sec)   MariaDB [test]> XA START 'a'; Query OK, 0 rows affected (0.00 sec)   MariaDB [test]> INSERT INTO t1 VALUES (1); Query OK, 1 row affected (0.00 sec)   MariaDB [test]> XA END 'a'; Query OK, 0 rows affected (0.00 sec)   MariaDB [test]> XA PREPARE 'a'; Query OK, 0 rows affected (0.01 sec)   MariaDB [test]> XA RECOVER; +----------+--------------+--------------+------+ | formatID | gtrid_length | bqual_length | data | +----------+--------------+--------------+------+ | 1 | 1 | 0 | a | +----------+--------------+--------------+------+ 1 row in set (0.00 sec)   MariaDB [test]> LOAD INDEX INTO cache t1 KEY(PRIMARY); +---------+--------------+----------+-----------------------------------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +---------+--------------+----------+-----------------------------------------------------------------------------------------------+ | test.t1 | preload_keys | Error | XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state | | test.t1 | preload_keys | error | Corrupt | +---------+--------------+----------+-----------------------------------------------------------------------------------------------+ 2 rows in set (0.01 sec)   MariaDB [test]> XA RECOVER; +----------+--------------+--------------+------+ | formatID | gtrid_length | bqual_length | data | +----------+--------------+--------------+------+ | -1 | 1 | 0 | a | +----------+--------------+--------------+------+ 1 row in set (0.00 sec)   MariaDB [test]> XA COMMIT 'a'; ERROR 1397 (XAE04): XAER_NOTA: Unknown XID MariaDB [test]> SELECT COUNT(*) FROM t1; ERROR 1399 (XAE07): XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state