Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

Unable to start Rollbase using MySQL Cluster 5.6.42

Information

 
Article Number000093837
EnvironmentProduct: Rollbase
Version: 5.3.1.0
Database: MySQL Cluster 5.6.42
Question/Problem Description
Error regarding BINLOG_FORMAT when starting Tomcat is preventing Rollbase from working.
Steps to Reproduce
Clarifying Information
Error MessageError executing row event: 'Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.'
Defect/Enhancement Number
Cause
Prior to MySQL 5.7.7, the default format was STATEMENT. In MySQL 5.7.7 and later the default is ROW.
Resolution
Upgrade MySQL to 5.x. See notes section for Rollbase supported platforms.
Workaround
Change binlog_format   system variable using the command:
SET SESSION binlog_format = 'ROW';

PS: Changing the global binlog_format value requires privileges sufficient to set global system variables.
 
Notes
Attachment 
Last Modified Date1/14/2019 8:58 PM