Cause: java.sql.SQLException: Cannot execute statement: impossible to write to binary log

最新推荐文章于 2024-03-09 08:00:00 发布

原创最新推荐文章于 2024-03-09 08:00:00 发布 · 3.4k 阅读

1 ·

CC 4.0 BY-SA版权

本文介绍了一种常见的MySQL错误，即由于BINLOG_FORMAT设置不当导致无法写入二进制日志的问题，并提供了相应的解决方案。通过调整BINLOG_FORMAT为MIXED，可以解决InnoDB表在特定事务隔离级别下遇到的限制。

额外遇到的问题
Cause: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the ITEM.updateByInventory-InlineParameterMap.
--- Check the statement (update failed).

--- Cause: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

解决办法是：将BINLOG_FORMAT设置成MIXED即可，SET GLOBAL BINLOG_FORMAT = MIXED;