org.quartz.JobPersistenceException: Couldn't store trigger 'AutoReport.Long Run Job.long run job2' for 'AutoReport.Long Run Job' job:SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked


Solutions on the web39

Solution icon of terracotta
Couldn't store trigger 'AutoReport.Long Run Job.long run job2' for 'AutoReport.Long Run Job' job:SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked

Solution icon of web
Couldn't store trigger 'AVAIL_DURATION_DOWN-712781' for 'org.rhq.enterprise.server.scheduler.jobs.AlertAvailabilityDurationJob' job:Job class must implement the Job interface. [See nested exception: java.lang.IllegalArgumentException: Job class must implement the Job interface.]

Solution icon of googlegroups
Couldn't store trigger: com.dotmarketing.sitesearch.job.SiteSearchJobProxy [See nested exception: java.lang.ClassNotFoundException: com.dotmarketing.sitesearch.job.SiteSearchJobProxy]

Solution icon of bugzilla
via https://bugzilla.redhat.com/bugzilla/ by Joseph Marques, 1 year ago
Couldn't store trigger 'org.rhq.enterprise.server.scheduler.jobs.ClusterManagerJob' for 'org.rhq.enterprise.server.scheduler.jobs.ClusterManagerJob' job:No ClassLoaders found for: org.rhq.enterprise.server.scheduler.jobs.ClusterManagerJob [See

Solution icon of googlegroups
Couldn't store trigger: com.dotcms.publisher.business.PublisherQueueJob [See nested exception: java.lang.ClassNotFoundException: com.dotcms.publisher.business.PublisherQueueJob]

Solution icon of googlegroups
via Google Groups by Nathan Keiter, 3 months ago
Couldn't store trigger: com.dotcms.publisher.business.PublisherQueueJob [See nested exception: java.lang.ClassNotFoundException: com.dotcms.publisher.business.PublisherQueueJob]

Solution icon of googlegroups
via Google Groups by Unknown author, 3 months ago
Couldn't store trigger: com.dotcms.publisher.business.PublisherQueueJob [See nested exception: java.lang.ClassNotFoundException: com.dotcms.publisher.business.PublisherQueueJob]

Solution icon of github
via GitHub by wszyquan
, 1 year ago
Couldn't store trigger 'DEFAULT.timerTrigger' for 'DEFAULT.timerJobDetail' job:The job (DEFAULT.timerJobDetail) referenced by the trigger does not exist. [See nested exception: org.quartz.JobPersistenceException: The job (DEFAULT.timerJobDetail) referenced by the trigger does not exist.]

Solution icon of stackoverflow
Couldn't store trigger 'job1' for 'sampleJobRunner' job:The job (sampleGroup.sampleJobRunner) referenced by the trigger does not exist. [See nested exception: org.quartz.JobPersistenceException: The job (sampleGroup.sampleJobRunner) referenced by the trigger does not exist.]

Solution icon of terracotta
Couldn't store trigger: The job (DEFAULT.JobTrigger_2425) referenced by the trigger does not exist. [See nested exception: org.quartz.JobPersistenceException: The job (DEFAULT.JobTrigger_2425) referenced by the trigger does not exist.]

Stack trace

org.quartz.JobPersistenceException: Couldn't store trigger 'AutoReport.Long Run Job.long run job2' for 'AutoReport.Long Run Job' job:SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1223)[quartz-2.2.1.jar:na]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037)[quartz-2.2.1.jar:na]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986)[quartz-2.2.1.jar:na]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3187)[quartz-2.2.1.jar:na]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3935)[quartz-2.2.1.jar:na]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3956)[quartz-2.2.1.jar:na]
Caused by: java.sql.SQLException: SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked
	at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2526)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun  7 23:59:43 PDT 2012]
	at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2323)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun  7 23:59:43 PDT 2012]
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun  7 23:59:43 PDT 2012]
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:253)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun  7 23:59:43 PDT 2012]
	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2173)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun  7 23:59:43 PDT 2012]
	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2157)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun  7 23:59:43 PDT 2012]
	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:260)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun  7 23:59:43 PDT 2012]
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)[c3p0-0.9.1.1.jar:0.9.1.1]
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1222)[quartz-2.2.1.jar:na]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1218)[quartz-2.2.1.jar:na]
	... 5 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

Once, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago