[
https://issues.apache.org/jira/browse/DERBY-5049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17141994#comment-17141994
]
Richard N. Hillegas commented on DERBY-5049:
--------------------------------------------
Thanks for the repro, Walter.
> Executing DROP TABLE for different tables in concurrently running threads
> causes timeout/deadlock
> -------------------------------------------------------------------------------------------------
>
> Key: DERBY-5049
> URL: https://issues.apache.org/jira/browse/DERBY-5049
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.7.1.1
> Environment: Windows 7 or Window XP
> Reporter: Rob Arciere
> Priority: Major
> Labels: derby_triage10_8
> Attachments: DropTableBugTest.java
>
>
> Executing DROP TABLE for different tables in concurrently running threads
> causes the following timeout/deadlock issue.
> ERROR 40XL1: A lock could not be obtained within the time requested
> The error causes all DROP table transactions to timeout, as well as any other
> SQL queries, updates, etc running at the same time. I have created a test
> case to reproduce this issue and the issue is present when running two or
> more threads at the same time using Derby's built in Connection Pooling and
> running as an embedded server. I really think the crux of the issue is with
> the DROP TABLE command, but I suspect you may see similar things with RENAME
> TABLE, however, CREATE TABLE seems to behave as expected and can handle being
> ran concurrently with other CREATE TABLE statements.
> Below is a sample stack trace along with the lock table output:
> java.sql.SQLException: A lock could not be obtained within the time
> requested. The lockTable dump is:
> Wed Feb 16 13:40:12 EST 2011
> XID |TYPE |MODE|LOCKCOUNT|LOCKNAME
> |STATE|TABLETYPE / LOCKOBJ
> |INDEXNAME / CONTAINER_ID / (MODE for LATCH only) |TABLENAME /
> CONGLOM_ID |
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> *** The following row is the victim ***
> 37051623 |TABLE |IX |0 |Tablelock
> |WAIT |S
> |NULL |SYSCONGLOMERATES
> |
> *** The above row is the victim ***
> 37051623 |ROW |S |2 |(2,14)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051622 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051623 |TABLE |IX |4 |Tablelock
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051622 |TABLE |IX |4 |Tablelock
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051623 |TABLE |IX |3 |Tablelock
> |GRANT|S
> |NULL |SYSDEPENDS
> |
> 37051622 |TABLE |IX |3 |Tablelock
> |GRANT|S
> |NULL |SYSDEPENDS
> |
> 37051623 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSDEPENDS
> |
> 37051622 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSDEPENDS
> |
> 37051623 |ROW |S |2 |(2,8)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,8)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051623 |TABLE |IX |6 |Tablelock
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |TABLE |IX |6 |Tablelock
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |ROW |S |2 |(3,20)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,20)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |IS |10 |Tablelock
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |TABLE |IS |10 |Tablelock
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |TABLE |IX |5 |Tablelock
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |IX |5 |Tablelock
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |IS |13 |Tablelock
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |IS |13 |Tablelock
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |TABLE |S |1 |Tablelock
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |S |1 |Tablelock
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(2,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(1,20)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |ROW |S |2 |(1,20)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(3,15)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,15)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |IS |10 |Tablelock
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |TABLE |IS |10 |Tablelock
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(63,170)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,170)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,35)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,35)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(63,172)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,172)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(33,6)
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051623 |ROW |X |6 |(33,6)
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |ROW |S |2 |(52,26)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(2,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(1,11)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |ROW |S |2 |(1,11)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |TABLE |X |1 |Tablelock
> |GRANT|T
> |SQL110216132424890 |TEST_TABLE0
> |
> 37051622 |ROW |S |4 |(52,27)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(1,40)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,40)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,14)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,14)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,17)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,17)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,41)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(100,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |X |5 |(100,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,42)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,9)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,9)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |X |4 |Tablelock
> |GRANT|T
> |NULL |TEST_TABLE0
> |
> 37051623 |ROW |S |2 |(23,6)
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051623 |ROW |X |4 |(23,6)
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051622 |TABLE |IX |3 |Tablelock
> |GRANT|S
> |NULL |SYSSTATISTICS
> |
> 37051623 |TABLE |IX |3 |Tablelock
> |GRANT|S
> |NULL |SYSSTATISTICS
> |
> 37051622 |ROW |S |2 |(4,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(4,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(8,109)
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051622 |ROW |X |4 |(8,109)
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051623 |ROW |S |2 |(2,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,18)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,18)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,12)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,12)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(63,167)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,167)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,27)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(63,166)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,166)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,39)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,39)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,21)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,21)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,12)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(3,16)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,16)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,13)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(1,21)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |ROW |S |2 |(2,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,22)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,28)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,13)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,13)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(63,171)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,171)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,13)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(3,23)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,37)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,37)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(4,8)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(4,8)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(3,8)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,8)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,38)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,38)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,12)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(1,12)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(503,265)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |ROW |S |2 |(2,11)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,11)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(3,26)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(4,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(4,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,42)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,42)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,33)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,33)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(523,6)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |TABLE |X |4 |Tablelock
> |GRANT|T
> |NULL |TEST_TABLE1
> |
> 37051622 |ROW |S |2 |(3,25)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,36)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,36)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,24)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,9)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,9)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSTRIGGERS
> |
> 37051622 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSTRIGGERS
> |
> 37051622 |ROW |S |2 |(63,168)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,168)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,10)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,10)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(1,34)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,34)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,19)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,19)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(17,42)
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |ROW |X |6 |(17,42)
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |ROW |S |2 |(63,169)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,169)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,11)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,11)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,19)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(3,19)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(81,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(100,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |X |5 |(100,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,29)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |X |1 |Tablelock
> |GRANT|T
> |SQL110216082534050 |TEST_TABLE1
> |
> 37051622 |ROW |S |2 |(3,10)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,10)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |4 |(81,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(1,32)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,32)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown
> Source)
> at
> com.ci.pl.service.database.test.DropTableBugTest.drop(DropTableBugTest.java:67)
> at
> com.ci.pl.service.database.test.DropTableBugTest.access$0(DropTableBugTest.java:51)
> at
> com.ci.pl.service.database.test.DropTableBugTest$DropTableRunnable.run(DropTableBugTest.java:172)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
> at java.util.concurrent.FutureTask.run(FutureTask.java:123)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: ERROR 40XL2: A lock could not be obtained within the time
> requested. The lockTable dump is:
> Wed Feb 16 13:40:12 EST 2011
> XID |TYPE |MODE|LOCKCOUNT|LOCKNAME
> |STATE|TABLETYPE / LOCKOBJ
> |INDEXNAME / CONTAINER_ID / (MODE for LATCH only) |TABLENAME /
> CONGLOM_ID |
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> *** The following row is the victim ***
> 37051623 |TABLE |IX |0 |Tablelock
> |WAIT |S
> |NULL |SYSCONGLOMERATES
> |
> *** The above row is the victim ***
> 37051623 |ROW |S |2 |(2,14)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051622 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051623 |TABLE |IX |4 |Tablelock
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051622 |TABLE |IX |4 |Tablelock
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051623 |TABLE |IX |3 |Tablelock
> |GRANT|S
> |NULL |SYSDEPENDS
> |
> 37051622 |TABLE |IX |3 |Tablelock
> |GRANT|S
> |NULL |SYSDEPENDS
> |
> 37051623 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSDEPENDS
> |
> 37051622 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSDEPENDS
> |
> 37051623 |ROW |S |2 |(2,8)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,8)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051623 |TABLE |IX |6 |Tablelock
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |TABLE |IX |6 |Tablelock
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |ROW |S |2 |(3,20)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,20)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |IS |10 |Tablelock
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |TABLE |IS |10 |Tablelock
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |TABLE |IX |5 |Tablelock
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |IX |5 |Tablelock
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |IS |13 |Tablelock
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |IS |13 |Tablelock
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |TABLE |S |1 |Tablelock
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |S |1 |Tablelock
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(2,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(1,20)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |ROW |S |2 |(1,20)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(3,15)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,15)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |IS |10 |Tablelock
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |TABLE |IS |10 |Tablelock
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(63,170)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,170)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,35)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,35)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(63,172)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,172)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(33,6)
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051623 |ROW |X |6 |(33,6)
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |ROW |S |2 |(52,26)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(2,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(1,11)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |ROW |S |2 |(1,11)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |TABLE |X |1 |Tablelock
> |GRANT|T
> |SQL110216132424890 |TEST_TABLE0
> |
> 37051622 |ROW |S |4 |(52,27)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(1,40)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,40)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,14)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,14)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,17)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,17)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,41)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(100,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |X |5 |(100,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,42)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,9)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,9)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |TABLE |X |4 |Tablelock
> |GRANT|T
> |NULL |TEST_TABLE0
> |
> 37051623 |ROW |S |2 |(23,6)
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051623 |ROW |X |4 |(23,6)
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051622 |TABLE |IX |3 |Tablelock
> |GRANT|S
> |NULL |SYSSTATISTICS
> |
> 37051623 |TABLE |IX |3 |Tablelock
> |GRANT|S
> |NULL |SYSSTATISTICS
> |
> 37051622 |ROW |S |2 |(4,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(4,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(8,109)
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051622 |ROW |X |4 |(8,109)
> |GRANT|S
> |NULL |SYSKEYS
> |
> 37051623 |ROW |S |2 |(2,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,18)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,18)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,12)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,12)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(63,167)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,167)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,27)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(63,166)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,166)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,39)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,39)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,21)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,21)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,12)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(3,16)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,16)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,13)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(1,21)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |ROW |S |2 |(2,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,22)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,28)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,13)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,13)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(63,171)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,171)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,13)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(3,23)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,37)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,37)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(4,8)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(4,8)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(3,8)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,8)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,38)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,38)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,12)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(1,12)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |ROW |S |2 |(503,265)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051623 |ROW |S |2 |(2,11)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,11)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(3,26)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(4,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(4,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,42)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,42)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,33)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,33)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,6)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(523,6)
> |GRANT|S
> |NULL |SYSTABLES
> |
> 37051622 |TABLE |X |4 |Tablelock
> |GRANT|T
> |NULL |TEST_TABLE1
> |
> 37051622 |ROW |S |2 |(3,25)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,36)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,36)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,24)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,9)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,9)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSTRIGGERS
> |
> 37051622 |TABLE |IS |2 |Tablelock
> |GRANT|S
> |NULL |SYSTRIGGERS
> |
> 37051622 |ROW |S |2 |(63,168)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,168)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(2,10)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(2,10)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(1,34)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(1,34)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,19)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,19)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(17,42)
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |ROW |X |6 |(17,42)
> |GRANT|S
> |NULL |SYSCONSTRAINTS
> |
> 37051622 |ROW |S |2 |(63,169)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |X |5 |(63,169)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,11)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,11)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,19)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(3,19)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(81,6)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051623 |ROW |S |2 |(100,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |X |5 |(100,7)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |ROW |S |2 |(3,29)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051622 |TABLE |X |1 |Tablelock
> |GRANT|T
> |SQL110216082534050 |TEST_TABLE1
> |
> 37051622 |ROW |S |2 |(3,10)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(3,10)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |4 |(81,7)
> |GRANT|S
> |NULL |SYSCONGLOMERATES
> |
> 37051622 |ROW |S |2 |(1,32)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> 37051623 |ROW |S |2 |(1,32)
> |GRANT|S
> |NULL |SYSCOLUMNS
> |
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at org.apache.derby.impl.services.locks.Timeout.createException(Unknown
> Source)
> at org.apache.derby.impl.services.locks.Timeout.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.RowLocking2.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.execute.RowChangerImpl.openForUpdate(Unknown Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.open(Unknown Source)
> at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRows(Unknown
> Source)
> at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRow(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropConglomerateDescriptor(Unknown
> Source)
> at
> org.apache.derby.iapi.sql.dictionary.ConglomerateDescriptor.drop(Unknown
> Source)
> at
> org.apache.derby.iapi.sql.dictionary.ConstraintDescriptor.drop(Unknown Source)
> at
> org.apache.derby.impl.sql.execute.DDLSingleTableConstantAction.dropConstraint(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.DDLSingleTableConstantAction.dropConstraint(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.DropTableConstantAction.dropAllConstraintDescriptors(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.DropTableConstantAction.executeConstantAction(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
> ... 12 more
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
