카테고리 없음
confluence나 jira에서 READ-COMMITTED' transaction isolation level 에러
npre
2012. 6. 18. 11:30
반응형
Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
등을 뱉으면
- Shutdown JIRA or Confluence and your MySQL service if necessary.
- Open the MySQL configuration file (
my.cnf
) in a text editor.On UNIX-based systems, this file may be located in the
/etc
directory.- Locate the
binlog_format
property in this file in the[mysqld]
section and ensure that its value isrow
, such that you end up with:binlog_format=rowThis is only needed (and valid) for MySQL versions 5.1.5 and later.
- Save your changes to this file and restart your MySQL service and JIRA.