Confluence will not start due to incorrect log format
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
Confluence will not start and the following appears in the atlassian-confluence.log:
1
caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not save object; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1665]; 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.; nested exception is java.sql.SQLException: 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.Cause
If you are using InnoDB tables and the transaction isolation level is READ COMMITTED or READ UNCOMMITTED, only row-based logging can be used. The error is caused by the binlog_format setting in my.cnf being set to "statement" . For more information see https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html.
Resolution
Change the binlog_format setting in my.cnf (mysqld) to
binlog_format=row
The my.cnf file is typically in /etc/my.cnf.
Was this helpful?