Confluence will not start using MySQL 5.1.5+ with STATEMENT binary logging
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
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:
- Shutdown Confluence and your MySQL database
- Open the MySQL configuration file (
my.cnf) in a text editor
On UNIX-based systems, this file may be located in the
binlog_formatproperty in this file in the
[mysqld]section and ensure that its value is
row, such that you end up with:
- Save your changes to this file
- Restart Confluence and your MySQL database
Was this helpful?
Thanks for your feedback!