[DERBY-1902] Intermittent failures in predicatePushdown.sql

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.3.1.4
• Component/s: SQL, Test
• Environment: Seen on both Solaris 10 and Linux on 2-CPU Opteron boxes, disk cache off
• Bug behavior facts: Regression Test Failure
• Assignee: Unassigned
• Reporter: Oystein Grovlen
• Created: 29/Sep/06 09:44
• Updated: 21/Jan/11 17:49
• Resolved: 08/Jul/09 14:18

Description

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.

Issue Links

• duplicates: DERBY-1720 predicatePushdown test gets queryplan diff, only on some platforms
• is related to: DERBY-1801 Reoccurrence of JIRA-937: Instability in wisconsin test
• relates to: DERBY-3479 Changed/unexpected query plan when running test 'lang/predicatePushdown.sql'