Derby
  1. Derby
  2. DERBY-5038

updatelocks test failing in tinderbox when background update statistics are enabled.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.1.2
    • Fix Version/s: 10.8.1.2
    • Component/s: Test
    • Labels:
      None

      Description

      updatelocks is failing consistently in tinderbox since checkin 1069598 for DERBY-4939: Enable istat daemon and tests

      http://dbtg.foundry.sun.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/1070190-derbyall_diff.txt

                      • Diff file derbyall/encryptionAll/storemats/storemats/updatelocks.diff
          • Start: updatelocks jdk1.6.0_18 storemats:storemats 2011-02-13 09:28:29 ***
            2847,2856d2846
            < APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
            < ij> next scan_cursor;
            < A |B |C
            < --------------------------------------------------------------------------------------------------------------------------------------------------------
            < 3 |-30 |-three
            < ij> update a set b=30,c='three' where current of scan_cursor;
            < 1 row inserted/updated/deleted
            < ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
            < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
            < ---------------------------------------------------------------------------
            2857a2848,2857
            > ij> next scan_cursor;
            > A |B |C
            > --------------------------------------------------------------------------------------------------------------------------------------------------------
            > 3 |-30 |-three
            > ij> update a set b=30,c='three' where current of scan_cursor;
            > 1 row inserted/updated/deleted
            > ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
            > USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
            > ---------------------------------------------------------------------------
            > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
            2867 del
            < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
            2867a2867
            > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
            2874 del
            < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
            2874a2874
            > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
            14688,14697d14687
            < APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
            < ij> next scan_cursor;
            < A |B |C
            < --------------------------------------------------------------------------------------------------------------------------------------------------------
            < 3 |-30 |-three
            < ij> update a set b=30,c='three' where current of scan_cursor;
            < 1 row inserted/updated/deleted
            < ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
            < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
            < ---------------------------------------------------------------------------
            14698a14689,14698
            > ij> next scan_cursor;
            > A |B |C
            > --------------------------------------------------------------------------------------------------------------------------------------------------------
            > 3 |-30 |-three
            > ij> update a set b=30,c='three' where current of scan_cursor;
            > 1 row inserted/updated/deleted
            > ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
            > USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
            > ---------------------------------------------------------------------------
            > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
            14708 del
            < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
            14708a14708
            > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
            14716 del
            < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
            14716a14716
            > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
            Test Failed.
          • End: updatelocks jdk1.6.0_18 storemats:storemats 2011-02-13 09:28:40 ***
      1. derby.log
        113 kB
        Mike Matrigali

        Issue Links

          Activity

          Mike Matrigali created issue -
          Mike Matrigali made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-4833 [ DERBY-4833 ]
          Mike Matrigali made changes -
          Link This issue is broken by DERBY-4939 [ DERBY-4939 ]
          Mike Matrigali made changes -
          Attachment derby.log [ 12471006 ]
          Mike Matrigali made changes -
          Link This issue relates to DERBY-5039 [ DERBY-5039 ]
          Mike Matrigali made changes -
          Link This issue requires DERBY-4090 [ DERBY-4090 ]
          Mike Matrigali made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Assignee Mike Matrigali [ mikem ]
          Fix Version/s 10.8.0.0 [ 12315561 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Affects Version/s 10.8.1.1 [ 12316356 ]
          Affects Version/s 10.8.1.0 [ 12315561 ]
          Fix Version/s 10.8.1.1 [ 12316356 ]
          Fix Version/s 10.8.1.0 [ 12315561 ]
          Rick Hillegas made changes -
          Affects Version/s 10.8.1.2 [ 12316362 ]
          Affects Version/s 10.8.1.1 [ 12316356 ]
          Fix Version/s 10.8.1.2 [ 12316362 ]
          Fix Version/s 10.8.1.1 [ 12316356 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12552914 ] Default workflow, editable Closed status [ 12802787 ]

            People

            • Assignee:
              Mike Matrigali
              Reporter:
              Mike Matrigali
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development