You're visiting the Confluence Knowledge Base. Visit the Confluence Knowledge Base Home for an overview.

Skip to end of metadata
Go to start of metadata


Confluence installation will not start properly when it's using MySQL 5.1.5+ with InnoDB and the default binary logging format - i.e. 'STATEMENT'


The following appears in the atlassian-confluence.log:



Confluence uses the 'READ-COMMITTED' transaction isolation level with MySQL, which currently only supports row-based binary logging. For more information about this, please refer to MySQL Bug #40360.


To fix this problem, you must configure MySQL's binary logging format to use 'row-based' binary logging:

  1. Shutdown Confluence and your MySQL database
  2. Open the MySQL configuration file (my.cnf) in a text editor
    (info) On UNIX-based systems, this file may be located in the /etc directory
  3. Locate the binlog_format property in this file in the [mysqld] section and ensure that its value is row, such that you end up with:

  4. Save your changes to this file
  5. Restart Confluence and your MySQL database
Help us improve!

Is this article helpful?
Is it well written?
Is the content complete?