Confluence Documentation

Confluence Latest 
Confluence 5.3 Documentation 
Confluence 5.2 Documentation 
Confluence 5.1 Documentation 
More...
 

 

Search the Confluence Knowledge Base

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

Symptoms

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'

Diagnosis

The following appears in the atlassian-confluence.log:

or:

Cause

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.

Resolution

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:

    binlog_format=row
  4. Save your changes to this file.
  5. Restart Confluence and your MySQL database.

Related Content

 Expand to see related content
Help us improve!
Is this article helpful?
Is the content complete?
Is it well written?