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