mysql-xid-extract - Extract XID from XA TRANSACTIONS

Go to the mysql terminal and send this command to get the XA TRANSACTION stucked: XA RECOVER CONVERT XID;;

A result like this will be appear:

+----------+--------------+--------------+------------------------------------------------------------------------------------------+
| formatID | gtrid_length | bqual_length | data                                                                                     |
+----------+--------------+--------------+------------------------------------------------------------------------------------------+
|        1 |           40 |            3 | 0x65386234623938362D343062382D346335612D383437342D3730363163346264356563363A313236313237 |
+----------+--------------+--------------+------------------------------------------------------------------------------------------+
  

Fill the fields and VOILÀ!


Result:

gtrid:

bqual:

formatID:

Command:

XA COMMIT 0x,0x,