Error "You have an error in your SQL syntax"

Talend Version          6.x

Summary

Database error recovering from misfires due to MySQLSyntaxErrorException with 'OPTION SQL_SELECT_LIMIT=DEFAULT'.
Additional Versions  
Product  
Component  
Problem Description

The following error is thrown from TAC when handling misfired Tasks:

 

ERROR JobStoreTX - MisfireHandler: Error handling misfires: Database error recovering from misfires.
org.quartz.JobPersistenceException: Database error recovering from misfires. [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1]
   at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3136)
   at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3887)
   at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3907)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
   at sun.reflect.GeneratedConstructorAccessor84.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
   at com.mysql.jdbc.Util.getInstance(Util.java:378)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3378)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3310)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1853)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1976)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)
   at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1463)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1872)
   at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.countMisfiredTriggersInStates(StdJDBCDelegate.java:340)
   at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3115)
Problem root cause TAC is using an old mysql-connector driver jar.
Solution or Workaround Use a newer version of mysql-connector driver jar, at least mysql-connector-java-5.1.22.
JIRA ticket number  
Version history
Revision #:
5 of 5
Last update:
‎08-23-2017 12:36 PM
Updated by: