Derby
  1. Derby
  2. DERBY-5630

intermittent test failure in store/lockTableVTI.sql

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Patch Available
    • Bug behavior facts:
      Regression Test Failure

      Description

      I've seen this test fail twice recently, once with ibm 1.6, once with 1.4.2, both times on the same machine (which is running 10.8 nightly testing):

      The diff is as follows:
      51a52,61
      > ij(C1)> commit;
      > ij(C1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.locks.waitTimeout', '180');
      > 0 rows inserted/updated/deleted
      > ij(C1)> commit;
      > ij(C1)> set connection c2 ;
      > ij(C2)> wait for C2S1;
      > 3 rows inserted/updated/deleted
      > ij(C2)> select state from syscs_diag.lock_table order by state;
      > STATE
      > -----
      53,63d62
      < WAIT
      < ij(C1)> commit;
      < ij(C1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.locks.waitTimeout', '180');
      < 0 rows inserted/updated/deleted
      < ij(C1)> commit;
      < ij(C1)> set connection c2 ;
      < ij(C2)> wait for C2S1;
      < 3 rows inserted/updated/deleted
      < ij(C2)> select state from syscs_diag.lock_table order by state;
      < STATE
      < -----
      67d65
      < GRANT

      1. DERBY-5630.diff_try1
        11 kB
        Myrna van Lunteren
      2. DERBY-5630.diff2
        18 kB
        Myrna van Lunteren

        Issue Links

          Activity

          Myrna van Lunteren created issue -
          Myrna van Lunteren made changes -
          Field Original Value New Value
          Labels derby_triage10_10
          Urgency Normal [ 10052 ]
          Kathey Marsden made changes -
          Affects Version/s 10.8.3.0 [ 12323456 ]
          Affects Version/s 10.8.2.3 [ 12318540 ]
          Gavin made changes -
          Workflow jira [ 12654747 ] Default workflow, editable Closed status [ 12801999 ]
          Myrna van Lunteren made changes -
          Affects Version/s 10.10.1.3 [ 12324247 ]
          Myrna van Lunteren made changes -
          Attachment DERBY-5630.diff_try1 [ 12626828 ]
          Myrna van Lunteren made changes -
          Issue & fix info Patch Available [ 10102 ]
          Myrna van Lunteren made changes -
          Attachment DERBY-5630.diff2 [ 12627052 ]
          Myrna van Lunteren made changes -
          Link This issue is related to DERBY-6275 [ DERBY-6275 ]
          Myrna van Lunteren made changes -
          Assignee Myrna van Lunteren [ myrna ]
          Myrna van Lunteren made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Fix Version/s 10.8.3.3 [ 12323475 ]
          Fix Version/s 10.9.2.2 [ 12323562 ]
          Fix Version/s 10.10.1.4 [ 12324247 ]
          Fix Version/s 11.0.0.0 [ 12312083 ]
          Resolution Fixed [ 1 ]
          Myrna van Lunteren made changes -
          Affects Version/s 10.10.2.0 [ 12326659 ]
          Affects Version/s 10.10.1.4 [ 12324247 ]
          Fix Version/s 10.10.2.0 [ 12326659 ]
          Fix Version/s 10.10.1.4 [ 12324247 ]

            People

            • Assignee:
              Myrna van Lunteren
              Reporter:
              Myrna van Lunteren
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development