db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-5049) Executing DROP TABLE for different tables in concurrently running threads causes timeout/deadlock
Date Wed, 16 Feb 2011 18:56:24 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-5049:
---------------------------------

    Labels: derby_triage10_8  (was: )

> 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
>              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 is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message