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
- 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.
- 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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.