org.quartz.JobPersistenceException: Couldn't remove trigger: SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked [See nested exception: java.sql.SQLException: SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked]

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 xywnet, 1 year ago
Couldn't remove trigger: SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked [See nested exception: java.sql.SQLException: SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked]
org.quartz.JobPersistenceException: Couldn't remove trigger: SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked [See nested exception: 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)
at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2323)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:253)
at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2173)
at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2157)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:260)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTrigger(StdJDBCDelegate.java:1568)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.deleteTriggerAndChildren(JobStoreSupport.java:1362)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1495)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$11.execute(JobStoreSupport.java:1473)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1469)
at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1146)
at vmaxquartz.VmaxScheduler$.scheduleTrigger(VmaxScheduler.scala:142)
at vmaxquartz.VmaxScheduler$.schedule(VmaxScheduler.scala:119)
at vmaxquartz.demo.FirstApp$delayedInit$body.apply(FirstApp.scala:15)
at scala.Function0$class.apply$mcV$sp(Function0.scala:40)
at scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:12)
at scala.App$$anonfun$main$1.apply(App.scala:71)
at scala.App$$anonfun$main$1.apply(App.scala:71)
at scala.collection.immutable.List.foreach(List.scala:318)
at scala.collection.generic.TraversableForwarder$class.foreach(TraversableForwarder.scala:32)
at scala.App$class.main(App.scala:71)
at vmaxquartz.demo.FirstApp$.main(FirstApp.scala:7)
at vmaxquartz.demo.FirstApp.main(FirstApp.scala)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)

Users with the same issue

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

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