JDBCResourceDAO未能使用id - WSO2 API管理器删除资源。

Question

我将WSO2 API管理器1.8与MySQL结合使用。我无缘无故地在错误之下。

ERROR - JDBCResourceDAO Failed to delete the resource with id 758. 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.

java.sql.SQLException: 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 UN
COMMITTED.

我怎么才能解决这个问题？

Answer 1

以上错误是由于Mysql与WSO2产品的复制造成的。

根据错误1598 (HY000)：不可能进行二进制日志记录。消息:在InnoDB中读取提交的事务级别对Binlog语句是不安全的

这个问题有几个解决办法：

• 需要将binlog模式更改为行或混合，以便将数据加载到数据库中。 mysql>设置全局binlog_format = 'ROW'；
• 如果不打算将MySQL服务器用于复制，请考虑通过从启动MySQL服务器的mysqld实用程序的命令选项中删除选项--log-bin来关闭二进制日志记录。