Continuous Delivery Director scheduled phase are not executing

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

We scheduled phases with date-time in future point of time to execute. When time to execute this phase has come, nothing happens: nothing is executed The logs shows below error

 

 

2017-07-03 17:09:41.858 [phase-exec-scheduler_QuartzSchedulerThread] ERROR org.quartz.core.ErrorLogger - An error occurred while scanning for the next triggers to fire.

org.quartz.JobPersistenceException: Couldn't acquire next trigger: 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=1' at line 1

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2848)

                at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759)

                at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757)

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787)

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756)

                at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)

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=1' at line 1

 

 

Environment

Continuous Delivery Director (a.k.a Continuous Delivery Edition): 6.3, 6.4MySQL Version: 5.6.xMySQL Driver: 5.1.16,5.1.17

Cause

The cause of above error is the compatibility issue of driver with MySQL version 5.6.X which is resulting in above error.

Resolution

Please upgrade your driver to 5.1.31 or higher