Error
Error Code:
1402
MySQL Error 1402: XA Transaction Branch Rolled Back
Description
Error 1402, XA_RBROLLBACK, indicates that a specific branch of a distributed (XA) transaction has been explicitly rolled back by the MySQL server. This typically occurs when an issue prevents the successful completion of a part of a global transaction, leading to its automatic or forced reversal by the resource manager.
Error Message
XA_RBROLLBACK: Transaction branch was rolled back
Known Causes
3 known causesResource Manager Internal Error
The MySQL server encountered an internal issue, such as a deadlock, constraint violation, or other operational problem, leading to the rollback of the transaction branch.
External System Timeout or Failure
A timeout or failure in communication with the transaction coordinator or another participant in the distributed transaction caused MySQL to roll back its local branch.
Application-Level Rollback
The client application or transaction coordinator explicitly issued a command to roll back the specific transaction branch, often as part of error recovery or business rule enforcement.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service