mysql error handling for ERROR 1665 of HY000

ERROR 1665 (HY000)

[Environmental Description]

msyql5.6.14

[Error message]

Error while executing SQL statement:

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.

[Reason for error]

binlog cannot use statement mode when the transaction isolation level of innodb is read commited or read uncommited mode.

【 Solution 】

The solution to not restarting the mysql instance:

set global binlog_format=mixed

binlog format changes to mixed mode in the rebuilt session session.