Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 40097 invoked from network); 16 Feb 2011 18:48:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 16 Feb 2011 18:48:55 -0000 Received: (qmail 76182 invoked by uid 500); 16 Feb 2011 18:48:55 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 75988 invoked by uid 500); 16 Feb 2011 18:48:54 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 75589 invoked by uid 99); 16 Feb 2011 18:48:53 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Feb 2011 18:48:53 +0000 X-ASF-Spam-Status: No, hits=-1999.2 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD,UPPERCASE_50_75 X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Feb 2011 18:48:47 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 5B0D31960A3 for ; Wed, 16 Feb 2011 18:48:25 +0000 (UTC) Date: Wed, 16 Feb 2011 18:48:25 +0000 (UTC) From: "Rob Arciere (JIRA)" To: derby-dev@db.apache.org Message-ID: <1108253493.692.1297882105369.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] Created: (DERBY-5049) Executing DROP TABLE for different tables in concurrently running threads causes timeout/deadlock MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org 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 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 is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira