Error
Error Code:
1224
MariaDB Error 1224: Transactional/Non-Transactional Mix
Description
This error indicates that an operation attempted to access both transactional (e.g., InnoDB) and non-transactional (e.g., MyISAM) tables within a context where such mixing is explicitly disallowed. This commonly occurs when a session or global server setting is configured to prevent potential data inconsistencies.
Error Message
Mixing of transactional and non-transactional tables is disabled
Known Causes
3 known causesSession-Level Restriction
The current database session has a configuration setting that prevents operations involving both transactional and non-transactional storage engines.
Global Server Policy
The MariaDB server's global configuration explicitly prohibits operations that combine tables from transactional and non-transactional storage engines.
Implicit Transaction Context
An operation or query implicitly initiated a transactional context while attempting to modify or access both types of tables, triggering the server's restriction.
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