KB Articles

 

KB Article # 16989

Topic/Category: Database, MariaDB, Mysql

Issue: Workflow can not proceed: BINLOG_FORMAT Error in Logs

2017-05-16 19:48:14,718 [ERROR] [pool-1-thread-4] [com.ephesoft.dcma.imp.service.ImportServiceImpl] – Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [/* update com.ephesoft.dcma.da.domain.ServerLicenseDetails */ update ephesoft_meta_data set last_modified=?, meta_data_6=?, meta_data_1=?, meta_data_4=?, meta_data_3=?, meta_data_7=?, meta_data_2=?, meta_data_5=? where id=?]; SQL state [HY000]; error code [0]; Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.; nested exception is java.sql.BatchUpdateException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

 

Solution:

Configure DB engine for mixed mode.

Modify the my.cnf file in /etc/mysql directory, Restart the DB and Ephesoft service.

Old config – #binlog_format=row
New config – binlog_format=MIXED

< Back|KB Main Page | Next KB Article >

Was this article helpful to you?

Walter Lee