[Solved] Cause: java.sql.SQLException: Multi-statement transaction required more than ‘max_binlog_cache_size’ bytes of storage;

中文 EN

Zuli's Error Fix
My development note

2023/05/17 19:47

Cause: java.sql.SQLException: Multi-statement transaction required more than ‘max_binlog_cache_size’ bytes of storage;

increase this mysqld variable and try again;

uncategorized SQLException; SQL state [HY000]; error code [1197];

Multi-statement transaction required more than ‘max_binlog_cache_size’ bytes of storage; increase this mysqld variable and try again;

nested exception is java.sql.SQLException: Multi-statement transaction required more than ‘max_binlog_cache_size’ bytes of storage;

increase this mysqld variable and try again

SET GLOBAL max_binlog_cache_size = 4294967296;