
Binary logging not possible
When upsizing to Microsoft SQL server you may encounter the following error message with some configurations.
SQL state [HY000]; error code [1598]; Binary logging not possible. Message:
Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode
'STATEMENT'; nested exception is java.sql.BatchUpdateException: Binary logging
not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not
safe for binlog mode 'STATEMENT
Customers who encounter the above error when using Microsft SQL server may need to run the following SQL command:
SET GLOBAL binlog_format = 'ROW'
Please confirm with your database administrator before making this change.
Categories: Troubleshooting Articles, Databases
Keywords:
Comments