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

    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)[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