Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6907

ERROR 40XL1: A lock could not be obtained within the time requested

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.11.1.1
    • None
    • None
    • None

    Description

      We encountered the following error while meeting Compression with Insert (see below). Load might be relatively small, so I am not sure why does it coes the trouble. Please let me know if you need more information. I will try to providing a minimal reproducible case but this extremely hard given sizes of our app and its integration with Derby.

      Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
      Lock : TABLE, EXECUTIONISSUE, Tablelock
      Waiting XID :

      {220825613, IX}

      , APP, INSERT INTO executionissue (reportId, stepId, details, path, orderIndex, severity) VALUES (?, ?, ?, ?, ?, ?)
      Granted XID :

      {220825551, X}
      Lock : ROW, SYSCONGLOMERATES, (8,11)
      Waiting XID : {220825551, X}

      , APP, alter table "APP"."EXECUTIONISSUE" compress
      Granted XID :

      {220825551, S}

      ,

      {220825613, S}

      . The selected victim is XID : 220825613.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source)
      at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
      at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source)
      at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source)
      at org.apache.derby.impl.store.raw.xact.RowLocking3.lockContainer(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BaseContainerHandle.useContainer(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)
      at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)
      at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(Unknown Source)
      at org.apache.derby.impl.store.access.heap.Heap.open(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
      at org.apache.derby.impl.sql.compile.StatementNode.lockTableForCompilation(Unknown Source)
      at org.apache.derby.impl.sql.compile.DMLModStatementNode.verifyTargetTable(Unknown Source)
      at org.apache.derby.impl.sql.compile.InsertNode.bindStatement(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
      ... 30 more

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ykashnikov Yuriy Kashnikov
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: