Continuous Delivery Director scheduled phase are not executing

Document ID:  TEC1765066
Last Modified Date:  07/07/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Release Automation Continuous Delivery Edition

Releases

  • CA Release Automation Continuous Delivery Edition:Release:6.3
  • CA Release Automation Continuous Delivery Edition:Release:6.4

Components

  • RA CONTINUOUS DELIVERY EDITION:RACDDE
Problem:

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.4 MySQL Version: 5.6.x MySQL 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

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >