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 "Walter Weinmann (Jira)" <ji...@apache.org> on 2020/06/23 00:06:00 UTC
[jira] [Comment Edited] (DERBY-5049) Executing DROP TABLE for
different tables in concurrently running threads causes timeout/deadlock
[ https://issues.apache.org/jira/browse/DERBY-5049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17142006#comment-17142006 ]
Walter Weinmann edited comment on DERBY-5049 at 6/23/20, 12:05 AM:
-------------------------------------------------------------------
Hi Richard - if you need any help with it - any timeĀ :D
was (Author: wwe):
HinRichard - if you need any help with it - any timeĀ :D
> 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)