Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5049

Executing DROP TABLE for different tables in concurrently running threads causes timeout/deadlock

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.7.1.1
    • Fix Version/s: None
    • Component/s: SQL
    • Environment:
      Windows 7 or Window XP
    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Seen in production

      Description

      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

        Attachments

        1. DropTableBugTest.java
          6 kB
          Rob Arciere

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rarciere Rob Arciere
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: