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