You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2006/01/07 01:52:14 UTC
[jira] Created: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
--------------------------------------------------------------------------------------
Key: DERBY-800
URL: http://issues.apache.org/jira/browse/DERBY-800
Project: Derby
Type: Bug
Components: Test
Versions: 10.2.0.0
Reporter: Kathey Marsden
Priority: Minor
I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
(I don't know how long this link will last. Below is the diff)
********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
*** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
2 del
< Closed connection
3 del
< Test ConcurrentImplicitCreateSchema PASSED
3 add
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> SQL Exception: A lock could not be obtained within the time requested
> ERROR 40XL1: A lock could not be obtained within the time requested
> Closed connection
> Test ConcurrentImplicitCreateSchema FAILED
Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Re: [jira] Created: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock
timeout
Posted by Øystein Grøvlen <Oy...@Sun.COM>.
>>>>> "KM(" == Kathey Marsden (JIRA) <de...@db.apache.org> writes:
KM(> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
I have assigned myself to this since I created this test. From
previous experience, increasing the number of parallell threads in the
test, increases the probability of this occuring.
--
Øystein
Re: [jira] Updated: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock
timeout
Posted by "Bernt M. Johnsen" <Be...@Sun.COM>.
I'll review, testa nd commit this one.
>>>>>>>>>>>> Øystein Grøvlen (JIRA) wrote (2006-02-21 10:09:25):
> [ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
>
> Øystein Grøvlen updated DERBY-800:
> ----------------------------------
>
> Other Info: [Patch available]
>
> > derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> > --------------------------------------------------------------------------------------
> >
> > Key: DERBY-800
> > URL: http://issues.apache.org/jira/browse/DERBY-800
> > Project: Derby
> > Type: Bug
> > Components: Test, Regression Test Failure
> > Versions: 10.2.0.0
> > Reporter: Kathey Marsden
> > Assignee: Øystein Grøvlen
> > Priority: Critical
> > Attachments: derby-800.diff
> >
> > I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> > http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> > (I don't know how long this link will last. Below is the diff)
> > ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> > *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> > 2 del
> > < Closed connection
> > 3 del
> > < Test ConcurrentImplicitCreateSchema PASSED
> > 3 add
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > SQL Exception: A lock could not be obtained within the time requested
> > > ERROR 40XL1: A lock could not be obtained within the time requested
> > > Closed connection
> > > Test ConcurrentImplicitCreateSchema FAILED
> > Test Failed.
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
> http://issues.apache.org/jira/secure/Administrators.jspa
> -
> For more information on JIRA, see:
> http://www.atlassian.com/software/jira
>
--
Bernt Marius Johnsen, Database Technology Group,
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway
[jira] Resolved: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Bernt M. Johnsen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
Bernt M. Johnsen resolved DERBY-800:
------------------------------------
Resolution: Fixed
Committed revision 379733.
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
> Attachments: derby-800.diff
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Øystein Grøvlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=comments#action_12367164 ]
Øystein Grøvlen commented on DERBY-800:
---------------------------------------
What I have done with this issue is that I have run the test with some
tracing to see what caused the lock timeouts. I have not quite got to
the bottom of it, but so far it seems to me that it is not a deadlock
scenario, but just timeouts due to long queues on the dictionary lock.
(See below for more info).
Since creating 100 tables in parallel is not a common scenario, I am
not sure whether it is worth the effort to attempt fix this so the
test runs cleanly. ( The test was made to test a fix (Derby-230) that
I do not think is very likely to reoccur.) I have suggested on
derby-dev take we should just remove the test from derbyall. No one
has protested so I will create a patch to do that.
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Øystein Grøvlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
Øystein Grøvlen reassigned DERBY-800:
-------------------------------------
Assign To: Øystein Grøvlen
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Minor
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Manjula Kutty (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=comments#action_12378091 ]
Manjula Kutty commented on DERBY-800:
-------------------------------------
The same test fails with 10.1 with the same diff. Can you please remove it from 10.1 also?
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
> Attachments: derby-800.diff
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Øystein Grøvlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
Øystein Grøvlen updated DERBY-800:
----------------------------------
Other Info: [Patch available]
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
> Attachments: derby-800.diff
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
Mike Matrigali updated DERBY-800:
---------------------------------
Component: Regression Test Failure
Priority: Critical (was: Minor)
adding to regression suite and raising priority as discussed for regression suite bugs.
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Øystein Grøvlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
Øystein Grøvlen closed DERBY-800:
---------------------------------
Verified that test has been removed from derbyall.
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
> Attachments: derby-800.diff
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Bernt M. Johnsen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
Bernt M. Johnsen closed DERBY-800:
----------------------------------
Fix Version: 10.2.0.0
10.1.3.0
Resolution: Fixed
Committed revision 406881 on 10.1 branch
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
> Fix For: 10.2.0.0, 10.1.3.0
> Attachments: derby-800.diff
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Øystein Grøvlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
Øystein Grøvlen updated DERBY-800:
----------------------------------
Attachment: derby-800.diff
Attached derby-800.diff which removes lang/ConcurrentImplicitCreateSchema.java from derbyall.
Files that are changed:
M java/testing/org/apache/derbyTesting/functionTests/suites/derbylang.runall
M java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
> Attachments: derby-800.diff
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Reopened: (DERBY-800)
derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
lock timeout
Posted by "Bernt M. Johnsen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ]
Bernt M. Johnsen reopened DERBY-800:
------------------------------------
Merging to 10.1-branch
> derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout
> --------------------------------------------------------------------------------------
>
> Key: DERBY-800
> URL: http://issues.apache.org/jira/browse/DERBY-800
> Project: Derby
> Type: Bug
> Components: Test, Regression Test Failure
> Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Priority: Critical
> Attachments: derby-800.diff
>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
> (I don't know how long this link will last. Below is the diff)
> ********* Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
> *** Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
> 2 del
> < Closed connection
> 3 del
> < Test ConcurrentImplicitCreateSchema PASSED
> 3 add
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > SQL Exception: A lock could not be obtained within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > Closed connection
> > Test ConcurrentImplicitCreateSchema FAILED
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira