Yuriy Kashnikov created DERBY-6907:
--------------------------------------

             Summary: ERROR 40XL1: A lock could not be obtained within the time 
requested
                 Key: DERBY-6907
                 URL: https://issues.apache.org/jira/browse/DERBY-6907
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.11.1.1
            Reporter: Yuriy Kashnikov


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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to