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

          Henri van de Scheur created issue -
          John H. Embretsen made changes -
          Field Original Value New Value
          Link This issue is a clone of DERBY-937 [ DERBY-937 ]
          Mike Matrigali made changes -
          Fix Version/s 10.2.1.0 [ 11187 ]
          Rick Hillegas made changes -
          Fix Version/s 10.2.1.0 [ 11187 ]
          Fix Version/s 10.2.2.0 [ 12312027 ]
          Rick Hillegas made changes -
          Fix Version/s 10.2.3.0 [ 12312215 ]
          Fix Version/s 10.2.2.0 [ 12312027 ]
          Andrew McIntyre made changes -
          Fix Version/s 10.2.3.0 [ 12312215 ]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-937 [ DERBY-937 ]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-1902 [ DERBY-1902 ]
          Dag H. Wanvik made changes -
          Derby Categories [Regression Test Failure]
          Dag H. Wanvik made changes -
          Component/s Regression Test Failure [ 12310664 ]
          Dag H. Wanvik made changes -
          Component/s Test [ 11413 ]
          Myrna van Lunteren made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Resolution Cannot Reproduce [ 5 ]
          Myrna van Lunteren made changes -
          Resolution Cannot Reproduce [ 5 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Myrna van Lunteren made changes -
          Labels derby_triage10_8
          Urgency Normal
          Gavin made changes -
          Workflow jira [ 12382849 ] Default workflow, editable Closed status [ 12797380 ]

            People

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

              Dates

              • Created:
                Updated:

                Development