Warning
Error Code:
1196
MariaDB Error 1196: Non-Transactional Rollback Failure
Description
Error 1196 indicates that MariaDB was unable to fully roll back changes made to one or more tables that do not support transactional operations. This warning typically occurs when a transaction involving mixed storage engines fails or is explicitly rolled back, but modifications to non-transactional tables persist.
Error Message
Some non-transactional changed tables couldn't be rolled back
Known Causes
3 known causesMixed Storage Engines
A transaction involves tables using both transactional (e.g., InnoDB) and non-transactional (e.g., MyISAM) storage engines.
Direct Non-Transactional Updates
Performing DML operations directly on tables that inherently do not support ACID properties, making changes permanent immediately.
Implicit Commit Statements
Executing DDL or other statements that automatically commit any pending transaction, preventing a full rollback of prior changes.
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