Derby
  1. Derby
  2. DERBY-1801

Reoccurrence of JIRA-937: Instability in wisconsin test

    Details

    • Type: Bug Bug
    • Status: Reopened
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: None
    • Component/s: Test
    • Environment:
    • Urgency:
      Normal
    • Bug behavior facts:
      Regression Test Failure

      Description

                      • Diff file derbyall/derbylang/wisconsin.diff
          • Start: wisconsin jdk1.5.0_04 derbyall:derbylang 2006-08-29 12:35:37 ***
            4774 del
            < Hash Exists Join ResultSet:
            4774a4774
            > Nested Loop Exists Join ResultSet:
            4823 del
            < Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
            4823a4823
            > Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
            4828 del
            < Hash Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking:
            4828a4828
            > Index Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
            4830,4831d4829
            < Hash table size = 2500
            < Hash key is column number 0
            4833a4832
            > Fetch Size = 1
            4848,4849d4846
            < None
            < stop position:
            4853 del
            < scan qualifiers:
            4854 del
            < None
            4855 del
            < next qualifiers:
            4855a4850,4854
            > stop position:
            > > on first 1 column(s).
            > Ordered null semantics on the following columns:
            > 0
            > qualifiers:
            4857 del
            < Operator: =
            4857a4856
            > Operator: <
            12026 del
            < Index Row to Base Row ResultSet for TENKTUP1:
            12026a12025
            > Index Row to Base Row ResultSet for TENKTUP2:
            12029 del
            < Columns accessed from heap = {0, 1}
            12029a12028
            > Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}

            12034 del
            < Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
            12034a12033
            > Index Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
            12061 del
            < Index Row to Base Row ResultSet for TENKTUP2:
            12061a12060
            > Index Row to Base Row ResultSet for TENKTUP1:
            12064 del
            < Columns accessed from heap =

            {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
            12064a12063
            > Columns accessed from heap = {0, 1}
            12069 del
            < Hash Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking:
            12069a12068
            > Hash Scan ResultSet for TENKTUP1 using index TK1UNIQUE1 at serializable isolation level using share row locking:
            21815 del
            < Hash Exists Join ResultSet:
            21815a21814
            > Nested Loop Exists Join ResultSet:
            21864 del
            < Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}

            21864a21863
            > Columns accessed from heap =

            {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
            21869 del
            < Hash Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking:
            21869a21868
            > Index Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
            21871,21872d21869
            < Hash table size = 2500
            < Hash key is column number 0
            21874a21872
            > Fetch Size = 1
            21889,21890d21886
            < None
            < stop position:
            21894 del
            < scan qualifiers:
            21895 del
            < None
            21896 del
            < next qualifiers:
            21896a21890,21894
            > stop position:
            > > on first 1 column(s).
            > Ordered null semantics on the following columns:
            > 0
            > qualifiers:
            21898 del
            < Operator: =
            21898a21896
            > Operator: <
            21931 del
            < Hash Exists Join ResultSet:
            21931a21929
            > Nested Loop Exists Join ResultSet:
            21980 del
            < Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
            21980a21978
            > Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}

            21985 del
            < Hash Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking:
            21985a21983
            > Index Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
            21987,21988d21984
            < Hash table size = 2500
            < Hash key is column number 0
            21990a21987
            > Fetch Size = 1
            22005,22006d22001
            < None
            < stop position:
            22010 del
            < scan qualifiers:
            22011 del
            < None
            22012 del
            < next qualifiers:
            22012a22005,22009
            > stop position:
            > > on first 1 column(s).
            > Ordered null semantics on the following columns:
            > 0
            > qualifiers:
            22014 del
            < Operator: =
            22014a22011
            > Operator: <
            Test Failed.

          • End: wisconsin jdk1.5.0_04 derbyall:derbylang 2006-08-29 12:37:21 ***

        Issue Links

          Activity

          Hide
          Myrna van Lunteren added a comment -
          Show
          Myrna van Lunteren added a comment - reopening as I was wrong - it was seen on this day: http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.6/testing/testlog/sparc/1045233-derbyall_diff.txt
          Hide
          Myrna van Lunteren added a comment -

          I'm closing this as Cannot reproduce because we've not seen this in tinderbox or platformtesting for a long time.
          Note that it's still possible that it exists on zseries (IBM z/OS) because of DERBY-1914, but we cannot tell until that's fixed.

          Show
          Myrna van Lunteren added a comment - I'm closing this as Cannot reproduce because we've not seen this in tinderbox or platformtesting for a long time. Note that it's still possible that it exists on zseries (IBM z/OS) because of DERBY-1914 , but we cannot tell until that's fixed.
          Hide
          Andrew McIntyre added a comment -

          Unsetting Fix Version for unassigned issues.

          Show
          Andrew McIntyre added a comment - Unsetting Fix Version for unassigned issues.
          Hide
          Rick Hillegas added a comment -

          Move to 10.2.3.0.

          Show
          Rick Hillegas added a comment - Move to 10.2.3.0.
          Hide
          Rick Hillegas added a comment -

          Moving to 10.2.2.0.

          Show
          Rick Hillegas added a comment - Moving to 10.2.2.0.

            People

            • Assignee:
              Unassigned
              Reporter:
              Henri van de Scheur
            • Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development