org.quartz.impl.jdbcjobstore.LockException

Failure obtaining db row lock: No row exists in table KRSB_QRTZ_LOCKS for lock named: STATE_ACCESS [See nested exception: java.sql.SQLException: No row exists in table KRSB_QRTZ_LOCKS for lock named: STATE_ACCESS]

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web4

  • via Unknown by Claus Niesen,
  • via Unknown by Claus Niesen,
  • via Unknown by Unknown author,
  • Stack trace

    • org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: No row exists in table KRSB_QRTZ_LOCKS for lock named: STATE_ACCESS [See nested exception: java.sql.SQLException: No row exists in table KRSB_QRTZ_LOCKS for lock named: STATE_ACCESS] at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:109) at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:112) at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3196) at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3820) at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.initialize(JobStoreSupport.java:3807) at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:622) at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:494) at org.quartz.impl.StdScheduler.start(StdScheduler.java:143) at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:669) Caused by: java.sql.SQLException: No row exists in table KRSB_QRTZ_LOCKS for lock named: STATE_ACCESS at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:91) ... 8 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    We couldn't find other users who have seen this exception.