You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bryan Pendleton (JIRA)" <ji...@apache.org> on 2016/08/18 13:36:21 UTC

[jira] [Commented] (DERBY-6907) ERROR 40XL1: A lock could not be obtained within the time requested

    [ https://issues.apache.org/jira/browse/DERBY-6907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15426471#comment-15426471 ] 

Bryan Pendleton commented on DERBY-6907:
----------------------------------------

From the information provided, this does not seem like a bug in Derby. 

Have you read this page:

    http://wiki.apache.org/db-derby/LockDebugging

and studied this part of the manual:

    https://db.apache.org/derby/docs/10.12/devguide/cdevconcepts28436.html

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