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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 7 months ago | Harmeet Singh Taara
    java.lang.IllegalStateException: JobStore is shutdown - aborting retry

    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