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

Terracotta | xywnet | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

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

    Activemq jdbc sybase - unixforum.org

    unixforum.org | 2 years ago
    java.sql.SQLException: Invalid column name 'PRIORITY'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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.

    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)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun 7 23:59:43 PDT 2012]
      2. com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2323)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun 7 23:59:43 PDT 2012]
      3. com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun 7 23:59:43 PDT 2012]
      4. com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:253)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun 7 23:59:43 PDT 2012]
      5. com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2173)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun 7 23:59:43 PDT 2012]
      6. com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2157)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun 7 23:59:43 PDT 2012]
      7. com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:260)[jconn4.jar:JDK 1.6/jdbcmain/Thu Jun 7 23:59:43 PDT 2012]
      7 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeUpdate
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)[c3p0-0.9.1.1.jar:0.9.1.1]
      1 frame
    4. quartz
      JobStoreSupport$MisfireHandler.run
      1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1222)[quartz-2.2.1.jar:na]
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1218)[quartz-2.2.1.jar:na]
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037)[quartz-2.2.1.jar:na]
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986)[quartz-2.2.1.jar:na]
      5. org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3187)[quartz-2.2.1.jar:na]
      6. org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3935)[quartz-2.2.1.jar:na]
      7. org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3956)[quartz-2.2.1.jar:na]
      7 frames