org.quartz.JobPersistenceException: A lock could not be obtained within the time requested [See nested exception: java.sql.SQ LException: A lock could not be obtained within the time requested] at org.apache.ode.bpel.scheduler.quartz.JobStoreJTA.doRecoverMisfires( JobStoreJTA.java:1212) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage( JobStoreSupport.java:2409) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run( JobStoreSupport.java:2428) * Nested Exception (Underlying Cause) --------------- ERROR 40XL1: A lock could not be obtained within the time requested at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.locks.LockSet.lockObject(Unknown Source) at org.apache.derby.impl.services.locks.SinglePool.zeroDurationlockObject (Unknown Source) at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead (Unknown Source) at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lockPositionForRead (Unknown Source) at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows (Unknown Source) at org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown Source) at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray (Unknown Source) at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore (Unknown Source) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore (Unknown Source) at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow (Unknown Source)

ode-user | Alex Boisvert | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Re: How to improve performance

    ode-user | 1 decade ago | Alex Boisvert
    org.quartz.JobPersistenceException: A lock could not be obtained within the time requested [See nested exception: java.sql.SQ LException: A lock could not be obtained within the time requested] at org.apache.ode.bpel.scheduler.quartz.JobStoreJTA.doRecoverMisfires( JobStoreJTA.java:1212) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage( JobStoreSupport.java:2409) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run( JobStoreSupport.java:2428) * Nested Exception (Underlying Cause) --------------- ERROR 40XL1: A lock could not be obtained within the time requested at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.locks.LockSet.lockObject(Unknown Source) at org.apache.derby.impl.services.locks.SinglePool.zeroDurationlockObject (Unknown Source) at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead (Unknown Source) at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lockPositionForRead (Unknown Source) at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows (Unknown Source) at org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown Source) at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray (Unknown Source) at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore (Unknown Source) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore (Unknown Source) at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow (Unknown Source)

    Root Cause Analysis

    1. org.quartz.JobPersistenceException

      A lock could not be obtained within the time requested [See nested exception: java.sql.SQ LException: A lock could not be obtained within the time requested] at org.apache.ode.bpel.scheduler.quartz.JobStoreJTA.doRecoverMisfires( JobStoreJTA.java:1212) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage( JobStoreSupport.java:2409) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run( JobStoreSupport.java:2428) * Nested Exception (Underlying Cause) --------------- ERROR 40XL1: A lock could not be obtained within the time requested at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.locks.LockSet.lockObject(Unknown Source) at org.apache.derby.impl.services.locks.SinglePool.zeroDurationlockObject (Unknown Source) at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead (Unknown Source) at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lockPositionForRead (Unknown Source) at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows (Unknown Source) at org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown Source) at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray (Unknown Source) at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore (Unknown Source) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore (Unknown Source) at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow (Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition()
    2. Derby
      EmbedResultSet.next
      1. org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
      2. org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
      2 frames