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

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

추가 해주면 된다.