Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Full Phase Error: exist some xa transactions for long times, may lack some data for this Job!.
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Full Phase Error: exist some xa transactions for long times, may lack some data for this Job!.

Scenarios

During a full migration or synchronization, an error is reported, and the log information is as follows: exist some xa transactions for long times, may lack some data for this Job!

Possible Causes

There are XA transactions in the source database that have been there for a long time without being submitted, the transaction data may be lost, causing data inconsistency.

Solution

  1. Run the XA RECOVER statement in the source database to find the XA transaction that has not been submitted. Then, run the xa commit '{xid}' command, set xid to the data value returned by xa recover, and submit the XA transaction.
  2. If the preceding operations cannot be performed on the source database and the uncommitted XA transaction does not affect service data, contact DRS O&M personnel.