In this post, you’ll learn more about the MariaDB Error 1197 ER_TRANS_CACHE_FULL with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1197 – ER_TRANS_CACHE_FULL with the sqlState HY000
Error Description for the MariaDB Error ER_TRANS_CACHE_FULL
Multi-statement transaction required more than ‘max_binlog_cache_size’ bytes of storage; increase this mysqld variable and try again