Derby
  1. Derby
  2. DERBY-1902

Intermittent failures in predicatePushdown.sql

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: None
    • Component/s: SQL, Test
    • Labels:
      None
    • Environment:
      Seen on both Solaris 10 and Linux on 2-CPU Opteron boxes, disk cache off
    • Bug behavior facts:
      Regression Test Failure

      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.

      1. derbylang.zip
        441 kB
        Øystein Grøvlen

        Issue Links

          Activity

          Øystein Grøvlen created issue -
          Øystein Grøvlen made changes -
          Field Original Value New Value
          Attachment derbylang.zip [ 12342093 ]
          Andrew McIntyre made changes -
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Knut Anders Hatlen made changes -
          Link This issue duplicates DERBY-1720 [ DERBY-1720 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-1801 [ DERBY-1801 ]
          Mike Matrigali made changes -
          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.
          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.
          Kathey Marsden made changes -
          Derby Info [Regression]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-3479 [ DERBY-3479 ]
          Dag H. Wanvik made changes -
          Derby Categories [Regression Test Failure]
          Dag H. Wanvik made changes -
          Component/s Regression Test Failure [ 12310664 ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Duplicate [ 3 ]
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12385823 ] Default workflow, editable Closed status [ 12801462 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Øystein Grøvlen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development