db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-5097) testMTSelect(org.apache.derbyTesting.functionTests.tests.store.AutomaticIndex StatisticsMultiTest)junit.framework.AssertionFailedError: failed to get statisti cs for table MTSEL (#expected=2, timeout=0) on AIX IBM JDK 1.5
Date Wed, 09 Mar 2011 14:02:59 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5097?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13004547#comment-13004547
] 

Rick Hillegas commented on DERBY-5097:
--------------------------------------

Hi Kathey, does this test fail reliably on AIX? The test may be vulnerable to timing problems--it
is suspicious that the test cranks up 5 threads.

This error may flag a bug in the automatic collection of statistics, however. The test fails
because it is expects that statistics were collected automatically and in this case they weren't.

It seems to me that this bug is not a regression: the failure to collect statistics will not
cause wrong results and it will not even cause a query to run worse than it did in 10.7. This
may just be evidence that in some situations istat is not delivering its promised benefits
in the expected timeframe.

>  testMTSelect(org.apache.derbyTesting.functionTests.tests.store.AutomaticIndex StatisticsMultiTest)junit.framework.AssertionFailedError:
failed to get statisti cs for table MTSEL (#expected=2, timeout=0) on AIX IBM JDK 1.5
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5097
>                 URL: https://issues.apache.org/jira/browse/DERBY-5097
>             Project: Derby
>          Issue Type: Bug
>          Components: Services
>         Environment: $ java -version
> java version "1.5.0"
> Java(TM) 2 Runtime Environment, Standard Edition (build pap32dev-20100813 (SR12
> FP1 ))
> IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 AIX ppc-32 j9vmap3223-20100808 (JIT
> enabled)
> J9VM - 20100629_60535_bHdSMr
> JIT  - 20100623_16197_r8
> GC   - 20100211_AA)
> JCL  - 20100813
>            Reporter: Kathey Marsden
>
> I need to check if this is intermittent, but noticed the following failure running suites.All
on AIX with IBM 1.5.
> 1) testMTSelect(org.apache.derbyTesting.functionTests.tests.store.AutomaticIndex
> StatisticsMultiTest)junit.framework.AssertionFailedError: failed to get statisti
> cs for table MTSEL (#expected=2, timeout=0)
> Index statistics for MTSEL
>  : <no stats>
>  expected:<2> but was:<0>
>         at org.apache.derbyTesting.junit.IndexStatsUtil.getStatsTable(IndexStats
> Util.java:236)
>         at org.apache.derbyTesting.functionTests.tests.store.AutomaticIndexStati
> sticsMultiTest.verifyStatistics(AutomaticIndexStatisticsMultiTest.java:143)
>         at org.apache.derbyTesting.functionTests.tests.store.AutomaticIndexStati
> sticsMultiTest.testMTSelect(AutomaticIndexStatisticsMultiTest.java:87)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:79)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
>         at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:
> 112)
> FAILURES!!!
> Tests run: 11518,  Failures: 1,  Errors: 0

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message