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
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_format property 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.
Expand to see related content
Related Content with Label 'conf35'
Showing first 10 of 35 results
Related Content with Label 'mysql'
Showing first 10 of 30 results