atlassian_confluence_jira

java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

Naan 2014. 2. 26. 21:58
320x100




Hibernate operation: could not update: [com.atlassian.crowd.model.user.InternalUserAttribute#10321938]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1598]; Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'; nested exception is java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)

caused by: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'


위와 같이 에러가 뜬다면


my.conf 수정해주면 된다.


# vi /etc/my.conf 

binlog_format=row

innodb_locks_unsafe_for_binlog=1


추가 해주면 된다.


320x100
저작자표시

'atlassian_confluence_jira' 카테고리의 다른 글

crucible upgrade 방법  (0) 2014.03.06
Failed to start repository data: Problem loading repository 'data' - Current repository index for "data" is not compatible with your license, please re-index.  (0) 2014.03.05
You cannot access JIRA at present. Look at the table below to identify the reasons  (0) 2014.02.14
crucible java error 관련  (0) 2014.02.05
jira,confluence catalina.out 로그 용량줄이기  (0) 2014.02.04

'atlassian_confluence_jira'의 다른글

  • 현재글java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

관련글

티스토리툴바