[MySQL Case] ERROR 1665 (HY000)

1.1.1. ERROR 1665 (HY000)

[Environment description]

Msyql5.6.14

[Error message]

An error is reported when an SQL statement is executed:

ERROR 1665 (HY000): Cannot executestatement: impossible to write to binary log since BINLOG_FORMAT = STATEMENTand at least one table uses a storage engine limited to row-based logging. innoDB is limited to row-logging when transaction isolation level is READCOMMITTED or read uncommitted.

[Error cause]

When the transaction isolation level of innodb is read commited or read uncommited, the statement mode cannot be used for binlog.

 

[Solution]

Solution to not restarting the mysql instance:

Set global binlog_format = mixed

The binlog format in the re-established session will change to the mixed mode.