java.lang.Exception: Deadlock

db-derby-dev | Karl Wright (JIRA) | 4 years ago
  1. 0

    Out of time exception when calling next on ResultSet in Java

    Stack Overflow | 4 years ago | Miloš Lukačka
    java.sql.SQLTransactionRollbackException: A lock could not be obtained within the time requested
  2. 0

    "A lock could not be obtained" when installing WL application

    Stack Overflow | 4 years ago | yossile
    org.apache.openjpa.persistence.OptimisticLockException: Unable to obtain an object lock on "A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, GADGET_APPLICATIONS, (2,7) Waiting XID : {429, S} , WORKLIGHT, SELECT t0.ID, t0.ENFORCE_AUTHENTICITY, t0.ENVIRONMENT_ID, t1.ID, t1.DISP_IN_GALLERY, t1.LAST_UPDATE_TIME, t1.NAME, t0.SERVER_VERSION, t0.VERSION, t0.VERSION_LOCKED FROM GADGET_APPLICATIONS t0 INNER JOIN GADGETS t1 ON t0.GADGET_ID = t1.ID Granted XID : {422, S} Lock : ROW, GADGET_APPLICATIONS, (2,6) Waiting XID : {422, X} , WORKLIGHT, DELETE FROM GADGET_APPLICATIONS WHERE ID = ? Granted XID : {422, S} , {429, S} . The selected victim is XID : 429. [java.lang.String]".
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Non transactional request tries to get a lock with Derby

    Stack Overflow | 2 years ago | user3274155
    java.sql.SQLTransactionRollbackException: A lock could not be obtained within the time requested

    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

      A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {723, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Granted XID : {717, X} Lock : ROW, JOBQUEUE, (1,29) Waiting XID : {717, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Granted XID : {718, X} Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {718, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {725, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE . The selected victim is XID : 723.

      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException()
    2. Derby
      EmbedResultSet.next
      1. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      2. org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      3. org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
      4. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      5. org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      6. org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      7. org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      8. org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      9. org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
      10. org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
      11. org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
      11 frames
    3. org.apache.manifoldcf
      Database$ExecuteQueryThread.run
      1. org.apache.manifoldcf.core.database.Database.getData(Database.java:948)
      2. org.apache.manifoldcf.core.database.Database.execute(Database.java:866)
      3. org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:677)
      3 frames