java.lang.IllegalStateException: No record found for selection of Trigger with key: 'DEFAULT.kissaTrigger' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]

Terracotta | simperih | 3 years ago
  1. 0

    Internal problem with accuiring acquire next trigger (v2.2.1), relates to QTZ-386

    Terracotta | 3 years ago | simperih
    java.lang.IllegalStateException: No record found for selection of Trigger with key: 'DEFAULT.kissaTrigger' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]
  2. 0

    Internal problem with accuiring acquire next trigger (v2.2.1), relates to QTZ-386

    Terracotta | 3 years ago | simperih
    java.lang.IllegalStateException: No record found for selection of Trigger with key: 'DEFAULT.kissaTrigger' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]]
  3. 0

    Quartz 2.2.2 + Spring 3.1.1 - JobPersistenceException - Couldn't acquire next trigger

    Stack Overflow | 8 months ago | user1020455
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'TRIGGER-GROUP-CT.CAPTURE-TRIGGER-4752649' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'T3JobScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'TRIGGER-GROUP-CT.CAPTURE-TRIGGER-4752649' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'T3JobScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'TRIGGER-GROUP-CT.CAPTURE-TRIGGER-4752649' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'T3JobScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid misfired trigger breaks misfired trigger process

    GitHub | 4 months ago | brianlenz
    org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'RECOVERING_JOBS.recover_X.X.X.X1415014951113_1415015028210' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'ClusterScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?
  6. 0

    org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]] 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: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?] at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1533) at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2808) ... 5 more Caused by: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.loadExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:95) at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1819) at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1531) ... 6 more

    Terracotta Project Issue Tracker | 1 year ago | seetha Lakshmi
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.IllegalStateException

      No record found for selection of Trigger with key: 'DEFAULT.kissaTrigger' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?

      at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.loadExtendedTriggerProperties()
    2. quartz
      JobStoreSupport.acquireNextTrigger
      1. org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.loadExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:95)
      2. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1819)
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1531)
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1533)
      5. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2808)
      5 frames