org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Terracotta by sslavic, 1 year ago
Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.
via Stack Overflow by Ajinkya
, 6 months ago
Failure obtaining db row lock: ORA-00942: table or view does not exist [See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ]
via https://bugzilla.redhat.com/bugzilla/ by Radovan Synek, 1 year ago
Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]
via Stack Overflow by Eddard Stark
, 1 year ago
Failure obtaining db row lock: Table "QRTZ_LOCKS" not found; SQL statement: SELECT * FROM qrtz_LOCKS WHERE SCHED_NAME = 'QuartzJobCheAu' AND LOCK_NAME = ? FOR UPDATE [42102-191]
via Kuali JIRA by Claus Niesen, 1 year ago
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]
via Kuali JIRA by Claus Niesen, 1 year ago
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]
java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:85)
at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:117)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3174)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3783)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.initialize(JobStoreSupport.java:3770)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:653)
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:507)
at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.startScheduler(SchedulerFactoryBean.java:651)
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:166)
at org.springframework.context.support.DefaultLifecycleProcessor.access$1(DefaultLifecycleProcessor.java:154)
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:335)
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:143)
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:108)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:913)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:294)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:215)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4681)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5184)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

Users with the same issue

72 times, 7 months ago
3 times, 8 months ago
Once, 1 year ago
2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 8 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.