Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1801

Reoccurrence of JIRA-937: Instability in wisconsin test

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Reopened
    • Minor
    • Resolution: Unresolved
    • 10.2.1.6
    • None
    • Test
    • Normal
    • 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 ***

      Attachments

        Issue Links

          is a clone of

          Bug - A problem which impairs or prevents the functions of the product. DERBY-937 Instability in wisconsin test

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-937 Instability in wisconsin test

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-1902 Intermittent failures in predicatePushdown.sql

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated: