0
Answered

Error creating Task

Johan 7 years ago updated 7 years ago 5

Hi on linux when i try to create a task i have this error:


INFO o.s.j.s.SQLErrorCodesFactory:126 - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]

Will be answered

Could you send me the error log file to hainguyen@mycollab.com, the file locates at %MYCOLLAB_HOM%/logs? Thank you.

Answered

Th exception is "Caused by: 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 UNCOMMITTED."


To change to row based binary logging, set the following in /etc/my.cnf (or your my.cnf if it's elsewhere):


binlog_format=row


Then restart the MySQL server to make the changes effectively. You can see the full description at http://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html

Thanks a lot, is working now.