Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <13650547.64211291280712863.JavaMail.jira@thor>
Date: Thu, 2 Dec 2010 04:05:12 -0500 (EST)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2949) AssertionFailedError in
 testStalePlansOnLargeTable
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/DERBY-2949?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1296=
6027#action_12966027 ]=20

Knut Anders Hatlen commented on DERBY-2949:
-------------------------------------------

Thanks Lily, that's a very useful observation! The query has been executed =
12 times at the point of the failing assert. So it seems like in the good c=
ase the query is recompiled after the tenth execution (the test runs with d=
erby.language.stalePlanCheckInterval=3D10, so that sounds reasonable). In t=
he failing case, however, no recompilation has happened, and all 12 executi=
ons have used the same plan.

> AssertionFailedError in testStalePlansOnLargeTable
> --------------------------------------------------
>
>                 Key: DERBY-2949
>                 URL: https://issues.apache.org/jira/browse/DERBY-2949
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.3.1.4
>         Environment: Microsoft=C2=A9 Windows VistaT Ultimate - 6.0.6000 N=
/A Build 6000
> WindowsNT 0 6
> 2 X [Sun Fire X4100 Server x64 Family 15 Model 37 Stepping 1 AuthenticAMD=
]: ~2592 MHz,  cache. 3=C3=BF967 Total Memory.
> JVM: Sun Microsystems Inc. 1.5.0_07-b03=20
>            Reporter: Henri van de Scheur
>            Priority: Minor
>         Attachments: expected-plan.txt, plan.txt
>
>
> testStalePlansOnLargeTable(org.apache.derbyTesting.functionTests.tests.la=
ng.StalePlansTest)junit.framework.AssertionFailedError
> =09at org.apache.derbyTesting.functionTests.tests.lang.StalePlansTest.tes=
tStalePlansOnLargeTable(StalePlansTest.java:264)
> =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp=
l.java:39)
> =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc=
essorImpl.java:25)
> =09at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.jav=
a:88)
> =09at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> =09at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> =09at junit.extensions.TestSetup.run(TestSetup.java:25)
> =09at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:=
57)
> =09at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> =09at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> =09at junit.extensions.TestSetup.run(TestSetup.java:25)
> =09at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:=
57)

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.