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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2011/03/09 15:02:59 UTC
[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
[ 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