카테고리 없음

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'
등을 뱉으면

  1. Shutdown JIRA or Confluence and your MySQL service if necessary.
  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
    (info) This is only needed (and valid) for MySQL versions 5.1.5 and later.
  4. Save your changes to this file and restart your MySQL service and JIRA.