CREATE TABLE `ti` (
|
`a` int(11) DEFAULT NULL
|
) ENGINE=InnoDB;
|
xa start '1','2',4611686018427387905;
|
insert into ti set a=1;
|
xa end '1','2',4611686018427387905;
|
xa prepare '1','2',4611686018427387905;
|
xa recover;
|
+---------------------+--------------+--------------+------+
|
| formatID | gtrid_length | bqual_length | data |
|
+---------------------+--------------+--------------+------+
|
| 4611686018427387905 | 1 | 1 | 12 |
|
+---------------------+--------------+--------------+------+
|
--error crash
|
xa commit '1','2',4611686018427387905;
|
|
# restart mysqld
|
xa recover;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 4
|
Current database: test
|
|
+----------+--------------+--------------+------+
|
| formatID | gtrid_length | bqual_length | data |
|
+----------+--------------+--------------+------+
|
| 1 | 1 | 1 | 12 |
|
+----------+--------------+--------------+------+
|
|