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]

Terracotta | xywnet | 2 years ago
  1. 0

    Save job information into DB, start schedule again, throw exceptions

    Terracotta | 2 years ago | xywnet
    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]
  2. 0

    "java.sql.SQLException The column .. in table .. does not allow null values" although column value is not null

    Stack Overflow | 5 years ago | lamostreta
    org.hibernate.exception.ConstraintViolationException: could not insert: [com.turktrust.iab.ebs.pojos.MetalHareketIptal]
  3. 0

    hibernate - Unsupported SQL type 2005 on many-to-one constraint

    Stack Overflow | 5 years ago | Aykut
    java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2005.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Activemq jdbc sybase - unixforum.org

    unixforum.org | 1 year ago
    java.sql.SQLException: Invalid column name 'PRIORITY'.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      SQL Anywhere Error -210: User 'another user' has the row in 'QRTZ_TRIGGERS' locked

      at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions()
    2. com.sybase.jdbc4
      SybPreparedStatement.executeUpdate
      1. com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2526)
      2. com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2323)
      3. com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
      4. com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:253)
      5. com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2173)
      6. com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2157)
      7. com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:260)
      7 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeUpdate
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      1 frame
    4. quartz
      StdScheduler.rescheduleJob
      1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTrigger(StdJDBCDelegate.java:1568)
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport.deleteTriggerAndChildren(JobStoreSupport.java:1362)
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1495)
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport$11.execute(JobStoreSupport.java:1473)
      5. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787)
      6. org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
      7. org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1469)
      8. org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1146)
      9. org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:321)
      9 frames
    5. vmaxquartz
      VmaxScheduler$.schedule
      1. vmaxquartz.VmaxScheduler$.scheduleTrigger(VmaxScheduler.scala:142)
      2. vmaxquartz.VmaxScheduler$.schedule(VmaxScheduler.scala:119)
      2 frames
    6. vmaxquartz.demo
      FirstApp$delayedInit$body.apply
      1. vmaxquartz.demo.FirstApp$delayedInit$body.apply(FirstApp.scala:15)
      1 frame
    7. Scala
      App$class.main
      1. scala.Function0$class.apply$mcV$sp(Function0.scala:40)
      2. scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:12)
      3. scala.App$$anonfun$main$1.apply(App.scala:71)
      4. scala.App$$anonfun$main$1.apply(App.scala:71)
      5. scala.collection.immutable.List.foreach(List.scala:318)
      6. scala.collection.generic.TraversableForwarder$class.foreach(TraversableForwarder.scala:32)
      7. scala.App$class.main(App.scala:71)
      7 frames
    8. vmaxquartz.demo
      FirstApp.main
      1. vmaxquartz.demo.FirstApp$.main(FirstApp.scala:7)
      2. vmaxquartz.demo.FirstApp.main(FirstApp.scala)
      2 frames
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    10. IDEA
      AppMain.main
      1. com.intellij.rt.execution.application.AppMain.main(AppMain.java:120)
      1 frame