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

    Quartz Scheduler: java.lang.IllegalStateException: JobStore is shutdown - aborting retry

    Stack Overflow | 3 months ago | Harmeet Singh Taara
    java.lang.IllegalStateException: JobStore is shutdown - aborting retry
  3. 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 = ?]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

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

    Stack Overflow | 7 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 = ?]]
  6. 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 = ?

    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.JobStoreSupport.acquireNextTrigger()
    2. quartz
      QuartzSchedulerThread.run
      1. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2848)
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759)
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757)
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787)
      5. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756)
      6. org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)
      6 frames