Binary logging not possible

KB Home   |   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: Category.Databases+,


Keywords:

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on October 31, 2014, at 05:57 AM
Printable View   |   Article History   |   Edit Article