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
|