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
pgp0y3AEd51it.pgp
Description: PGP signature
