Error
Error Code:
1713
MySQL Error 1713: Undo Log Record Too Large
Description
MySQL Error 1713 indicates that an undo log record generated by a transaction has exceeded the internal size limits of the InnoDB storage engine. This typically occurs during DML operations (UPDATE, DELETE) that modify a substantial number of rows or rows containing large data types within a single transaction, requiring an extensive amount of rollback information.
Error Message
Undo log record is too big.
Known Causes
3 known causesExtensive Row Modifications
A single SQL statement, such as an UPDATE or DELETE, attempts to modify an exceptionally large number of rows within one transaction.
Large Data Type Updates
Updating rows that contain very large BLOB or TEXT columns, where the original data (pre-image) needs to be stored in the undo log.
Complex Transactional Operations
A transaction involving multiple complex DML operations that collectively generate an unusually high volume of undo information for potential 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