Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <649957532.1140512485926.JavaMail.jira@ajax.apache.org>
Date: Tue, 21 Feb 2006 10:01:25 +0100 (CET)
From: =?UTF-8?Q?=C3=98ystein_Gr=C3=B8vlen_=28JIRA=29?=
 <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-800)
 derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a
 lock timeout
In-Reply-To: <2111803641.1136595134833.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

    [ http://issues.apache.org/jira/browse/DERBY-800?page=3Dcomments#action=
_12367164 ]=20

=C3=98ystein Gr=C3=B8vlen 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: =C3=98ystein Gr=C3=B8vlen
>     Priority: Critical

>
> I have seen ConcurrentImplicitCreateSchema.java get a lock timeout  perio=
dically 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.di=
ff
> *** 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
> > =09at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.=
java:480)SQL Exception: A lock could not be obtained within the time reques=
ted
> > 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
> > =09at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.=
java:550)SQL Exception: A lock could not be obtained within the time reques=
ted
> > 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
> > =09at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lo=
ckScan(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
> > =09at org.apache.derby.iapi.error.StandardException.newException(Standa=
rdException.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
> > =09at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan=
.java:1696)SQL Exception: A lock could not be obtained within the time requ=
ested
> > 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
> > =09at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStar=
tForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtai=
ned within the time requested
> > ERROR 40XL1: A lock could not be obtained within the time requested
> > =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDes=
criptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not b=
e 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.

--=20
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