[
https://issues.apache.org/jira/browse/DERBY-1902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12461927
]
Knut Anders Hatlen commented on DERBY-1902:
-------------------------------------------
I tried to hard code refSize=8 (I assume this is the expected value for 64 bit
machines?) and then predicatePushdown failed consistently on both 32 and 64 bit
machines.
> Intermittent failures in predicatePushdown.sql
> ----------------------------------------------
>
> Key: DERBY-1902
> URL: https://issues.apache.org/jira/browse/DERBY-1902
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure, SQL, Test
> Affects Versions: 10.3.0.0
> Environment: Seen on both Solaris 10 and Linux on 2-CPU Opteron
> boxes, disk cache off
> Reporter: Øystein Grøvlen
> Fix For: 10.3.0.0
>
> Attachments: derbylang.zip
>
>
> For the last week, there have been intermittent failures in the night test in
> lang/predicatePushdown.sql. There is a plan diff which starts as follows:
> ********* Diff file derbyall/derbylang/predicatePushdown.diff
> *** Start: predicatePushdown jdk1.5.0_07 derbyall:derbylang 2006-09-29
> 00:39:36 ***
> 4593 del
> < Hash Join ResultSet:
> 4593a4593
> > Nested Loop Join ResultSet:
> I did not find any changes that seem relevant before the first failing night
> test.
> This test has not failed in the tinderbox test which runs on a computer with
> the disk cache on. For both computers where the failure is seen, the disk
> cache has been turned off. Hence, it may be that another plan is picked
> because of slower I/O.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
