Pages

Friday, March 11, 2016

Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT=STATEMENT

MySQL server produce following error while insert or update record to a table.

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.

Solution :

Change MySQL Server variable binlog_format value into mixed in global.

SET GLOBAL binlog_format = 'MIXED';

No comments:

Post a Comment