Jump to content

ERROR: 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...


manu

Recommended Posts

If you ever face the following error:

---------------------------
Error
---------------------------
There has been an unexpected error "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.". For more information check the server log.
---------------------------
OK   
---------------------------

is because MySQL is not liking the default Plastic isolation level. You can change it by adding the following entry in your "db.conf" server config file:

<IsolationLevel>RepeatableRead</IsolationLevel>

"RepeteableRead" is OK, no issues are reported so far using it, this is the first one you will want to try if you face the error described above. If it doesn't work... contact us!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...