Error
Error Code:
1402
MariaDB Error 1402: XA Transaction Branch Rolled Back
Description
Error 1402, XA_RBROLLBACK, signifies that a specific branch of an XA (distributed) transaction has been rolled back by the resource manager. This typically occurs when an operation within that transaction branch fails due to an error, constraint violation, or another condition preventing its successful completion and commitment.
Error Message
XA_RBROLLBACK: Transaction branch was rolled back
Known Causes
4 known causesInvalid Data or Operation
The application attempted an operation within the XA transaction branch that violated database constraints or was logically incorrect, leading to an automatic rollback.
Resource Contention or Deadlock
The transaction branch encountered a deadlock with another transaction or experienced a lock timeout, forcing its rollback to resolve the contention.
Transaction Branch Timeout
The XA transaction branch exceeded its allowed execution time, causing the resource manager to roll it back automatically.
Internal Database Error
An unexpected internal error within the MariaDB server prevented the successful completion of the transaction branch, triggering a rollback.
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