Search the Community
Showing results for tags 'db'.
Found 1 result
-
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!
