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';
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