[
https://issues.apache.org/jira/browse/DERBY-4540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13189418#comment-13189418
]
Mike Matrigali commented on DERBY-4540:
---------------------------------------
failed in nightly's, 10.8 branch, windows, ibm142
>From new diagnostics, the test is expecting 1 page visited but query visited 2
>pages. Maybe this is some kind of background task
cleanup issue where there are still some deleted rows in the btree. query plan
looks like it is using index correctly.
http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm142/1233151-suites.All_diff.txt
There was 1 failure:
1)
testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError:
RuntimeStatisticsParser.findstring(Number of pages visited= 1) returned
falsefull runtime statistics = Statement Name:
null
Statement Text:
select * from foo where a = 2
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for FOO:
Number of opens = 1
Rows seen = 0
Columns accessed from heap = {1}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
optimizer estimated row count: 1.00
optimizer estimated cost: 20.96
Index Scan ResultSet for FOO using index FOOX at serializable isolation
level using share row locking chosen by the optimizer
Number of opens = 1
Rows seen = 0
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
Number of pages visited=2
Number of rows qualified=0
Number of rows visited=0
Scan type=btree
Tree height=-1
start position:
>= on first 1 column(s).
Ordered null semantics on the following columns:
stop position:
> on first 1 column(s).
Ordered null semantics on the following columns:
qualifiers:
None
optimizer estimated row count: 1.00
optimizer estimated cost: 20.96
at
org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:404)
at
org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1715)
at
org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1775)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled
Code))
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled
Code))
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java(Compiled
Code))
at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined
Compiled Code))
at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled
Code))
at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code))
at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined
Compiled Code))
at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled
Code))
at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code))
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java(Inlined
Compiled Code))
at junit.extensions.TestSetup$1.protect(TestSetup.java(Inlined Compiled
Code))
at junit.extensions.TestSetup.run(TestSetup.java(Compiled Code))
FAILURES!!!
Tests run: 11966, Failures: 1, Errors: 0
> 'AssertionFailedError' in
> 'store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1729)' on SUSE
> Linux / IBM JIT - r9
> ------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4540
> URL: https://issues.apache.org/jira/browse/DERBY-4540
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.6.1.0, 10.8.2.3
> Environment: OS:
> SUSE Linux Enterprise Server 10 (i586) [Version 10 / Patchlevel 2] 32bits
> Linux 2.6.16.60-0.21-bigsmp #1 SMP Tue May 6 12:41:02 UTC 2008 GNU/Linux
> JVM:
> IBM Corporation
> JIT - r9_20090518_2017
> GC - 20090417_AA)
> JCL - 20090529_01
> Reporter: Ole Solberg
> Labels: derby_triage10_8
>
> See
> http://dbtg.foundry.sun.com/derby/test/trunk16/jvmAll/testing/testlog/JDK16_IBM60Linux-2.6.16.60-0.21-bigsmp_i686-i686/907276-org.apache.derbyTesting.functionTests.suites.All_diff.txt
> :
> There was 1 failure:
> 1)
> testCS4595B_UniqueIndex(org.apache.derbyTesting.functionTests.tests.store.AccessTest)junit.framework.AssertionFailedError
> at
> org.apache.derbyTesting.functionTests.tests.store.AccessTest.assertStatsOK(AccessTest.java:363)
> at
> org.apache.derbyTesting.functionTests.tests.store.AccessTest.doTestCaseCS4595B(AccessTest.java:1669)
> at
> org.apache.derbyTesting.functionTests.tests.store.AccessTest.testCS4595B_UniqueIndex(AccessTest.java:1729)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
