Derby
  1. Derby
  2. DERBY-3624

testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.1.3, 10.8.3.3, 10.11.0.0, 10.10.2.0
    • Fix Version/s: 10.8.3.3, 10.9.2.2, 10.11.0.0, 10.10.2.0
    • Component/s: Test
    • Environment:
      iseries, ibm 1.5.:
      java version "1.5.0"
      Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_13-b05)
      Classic VM (build 1.5, build JDK-1.5, native threads, jitc_de)
    • Urgency:
      Normal
    • Bug behavior facts:
      Regression Test Failure

      Description

      I saw this fail once; a couple of reruns didn't duplicate the problem.

      The only difference appears to be that one of the deadlock messages is missing from the output.

      4 del
      < Got a Deadlock.

      1. derby-3624_diff.txt
        2 kB
        Kathey Marsden
      2. st_derby715.tmp
        0.1 kB
        Myrna van Lunteren
      3. derby.log
        26 kB
        Myrna van Lunteren

        Issue Links

          Activity

          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 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.8.3.3 [ 12323475 ]
          Fix Version/s 10.9.2.2 [ 12323562 ]
          Hide
          ASF subversion and git services added a comment -

          Commit 1562544 from Myrna van Lunteren in branch 'code/branches/10.8'
          [ https://svn.apache.org/r1562544 ]

          DERBY-3624; testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing
          DERBY-5692; intermittent test failure in storetests/st_derby715.java
          merge of revision 1530796 from 10.10 branch

          Show
          ASF subversion and git services added a comment - Commit 1562544 from Myrna van Lunteren in branch 'code/branches/10.8' [ https://svn.apache.org/r1562544 ] DERBY-3624 ; testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing DERBY-5692 ; intermittent test failure in storetests/st_derby715.java merge of revision 1530796 from 10.10 branch
          Hide
          ASF subversion and git services added a comment -

          Commit 1562542 from Myrna van Lunteren in branch 'code/branches/10.9'
          [ https://svn.apache.org/r1562542 ]

          DERBY-3624; testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing
          DERBY-5692; intermittent test failure in storetests/st_derby715.java
          merge of revision 1530796 from 10.10 branch

          Show
          ASF subversion and git services added a comment - Commit 1562542 from Myrna van Lunteren in branch 'code/branches/10.9' [ https://svn.apache.org/r1562542 ] DERBY-3624 ; testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing DERBY-5692 ; intermittent test failure in storetests/st_derby715.java merge of revision 1530796 from 10.10 branch
          Kathey Marsden made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info Patch Available [ 10102 ]
          Fix Version/s 10.10.1.3 [ 12324247 ]
          Fix Version/s 10.11.0.0 [ 12324243 ]
          Resolution Fixed [ 1 ]
          Hide
          ASF subversion and git services added a comment -

          Commit 1530796 from Kathey Marsden in branch 'code/branches/10.10'
          [ https://svn.apache.org/r1530796 ]

          DERBY-3624 testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing
          merge revision 1530696 from trunk

          Show
          ASF subversion and git services added a comment - Commit 1530796 from Kathey Marsden in branch 'code/branches/10.10' [ https://svn.apache.org/r1530796 ] DERBY-3624 testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing merge revision 1530696 from trunk
          Hide
          ASF subversion and git services added a comment -

          Commit 1530696 from Kathey Marsden in branch 'code/trunk'
          [ https://svn.apache.org/r1530696 ]

          DERBY-3624 testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing

          Change test to check locks rather than sleep for synchronization.

          Show
          ASF subversion and git services added a comment - Commit 1530696 from Kathey Marsden in branch 'code/trunk' [ https://svn.apache.org/r1530696 ] DERBY-3624 testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing Change test to check locks rather than sleep for synchronization.
          Kathey Marsden made changes -
          Issue & fix info Patch Available [ 10102 ]
          Kathey Marsden made changes -
          Assignee Kathey Marsden [ kmarsden ]
          Kathey Marsden made changes -
          Attachment derby-3624_diff.txt [ 12606908 ]
          Hide
          Kathey Marsden added a comment -

          This looks like a timing issue with the test which relies on sleeps to synchronize the two threads. I can reliably lose deadlocks if I put a sleep at the beginning of t2.run().

          Attaching a patch which waits for locks to be taken rather than using the sleep to synchronize. Even if I put a sleep in at the beginning of t2.run() the test passes with this patch.

          Show
          Kathey Marsden added a comment - This looks like a timing issue with the test which relies on sleeps to synchronize the two threads. I can reliably lose deadlocks if I put a sleep at the beginning of t2.run(). Attaching a patch which waits for locks to be taken rather than using the sleep to synchronize. Even if I put a sleep in at the beginning of t2.run() the test passes with this patch.
          Show
          Mamta A. Satoor added a comment - Failed on 10.10.1.3 http://cloudsoft.svl.ibm.com/intranet/nightlies/sdsvm904017/JarResults.2013-09-06/ibm17_derbyall/derbyall_report.txt
          Show
          Myrna van Lunteren added a comment - And again: http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm17/1518442-derbyall_diff.txt
          Show
          Myrna van Lunteren added a comment - Also failed: http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/weme6.2/1518050-derbyall_diff.txt
          Show
          Myrna van Lunteren added a comment - Failed again: http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm15/1517407-derbyall_diff.txt
          Gavin made changes -
          Workflow jira [ 12429078 ] Default workflow, editable Closed status [ 12796831 ]
          Hide
          Myrna van Lunteren added a comment -

          Linking to DERBY-5692, which was fixed, but appears to be similar.

          Show
          Myrna van Lunteren added a comment - Linking to DERBY-5692 , which was fixed, but appears to be similar.
          Myrna van Lunteren made changes -
          Link This issue relates to DERBY-5692 [ DERBY-5692 ]
          Show
          Myrna van Lunteren added a comment - Failed once more:10.9, windows, ibm 1.6: http://people.apache.org/~myrnavl/derby_test_results/v10_9/windows/testlog/ibm16/1495659-derbyall_diff.txt
          Myrna van Lunteren made changes -
          Link This issue is related to DERBY-6275 [ DERBY-6275 ]
          Show
          Myrna van Lunteren added a comment - failed a few more times in June, once on the 10.8 machine, once on 10.9, three times on the 10.10 windows machine, different jvms. http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm16/1492928-derbyall_diff.txt http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm17/1493983-derbyall_diff.txt http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm16/1494414-derbyall_diff.txt http://people.apache.org/~myrnavl/derby_test_results/v10_9/windows/testlog/ibm16/1490496-derbyall_diff.txt http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm142/1491673-derbyall_diff.txt
          Show
          Mike Matrigali added a comment - failed 3 times in may on 10.10, windows. twice on ibm16 and once on ibm17 http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm16/1487215-derbyall_diff.txt http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm16/1486497-derbyall_diff.txt http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm17/1484643-derbyall_diff.txt
          Mike Matrigali made changes -
          Affects Version/s 10.10.1.2 [ 12324247 ]
          Hide
          Mike Matrigali added a comment -

          test failed in nightly tests against trunk, ibm16, windows:
          http://people.apache.org/~myrnavl/derby_test_results/main/windows/testlog/ibm16/1485917-derbyall_diff.txt

                          • Diff file derbyall/storeall/storetests/st_derby715.diff
              • Start: st_derby715 jdk1.6.0 storeall:storetests 2013-05-23 19:03:56 ***
                4 del
                < Got a Deadlock.
                Test Failed.
              • End: st_derby715 jdk1.6.0 storeall:storetests 2013-05-23 19:04:09 ***
          Show
          Mike Matrigali added a comment - test failed in nightly tests against trunk, ibm16, windows: http://people.apache.org/~myrnavl/derby_test_results/main/windows/testlog/ibm16/1485917-derbyall_diff.txt Diff file derbyall/storeall/storetests/st_derby715.diff Start: st_derby715 jdk1.6.0 storeall:storetests 2013-05-23 19:03:56 *** 4 del < Got a Deadlock. Test Failed. End: st_derby715 jdk1.6.0 storeall:storetests 2013-05-23 19:04:09 ***
          Mike Matrigali made changes -
          Affects Version/s 10.8.3.1 [ 12323475 ]
          Mike Matrigali made changes -
          Affects Version/s 10.11.0.0 [ 12324243 ]
          Hide
          Mike Matrigali added a comment -

          failed slightly differently again against 10.8 branch, windows, ibm142, build 1302046:
          http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm142/1302046-derbyall_diff.txt

                          • Diff file derbyall/storeall/storetests/st_derby715.diff
              • Start: st_derby715 jdk1.4.2 storeall:storetests 2012-03-17 20:09:34 ***
                5 del
                < Got a Deadlock.
                5 add
                > ERROR 40XL1: A lock could not be obtained within the time requested
                > java.sql.SQLException: A lock could not be obtained within the time requested
                > Caused by: ERROR 40XL1: A lock could not be obtained within the time requested
                > ... 5 more
                Test Failed.
              • End: st_derby715 jdk1.4.2 storeall:storetests 2012-03-17 20:09:53 ***
          Show
          Mike Matrigali added a comment - failed slightly differently again against 10.8 branch, windows, ibm142, build 1302046: http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm142/1302046-derbyall_diff.txt Diff file derbyall/storeall/storetests/st_derby715.diff Start: st_derby715 jdk1.4.2 storeall:storetests 2012-03-17 20:09:34 *** 5 del < Got a Deadlock. 5 add > ERROR 40XL1: A lock could not be obtained within the time requested > java.sql.SQLException: A lock could not be obtained within the time requested > Caused by: ERROR 40XL1: A lock could not be obtained within the time requested > ... 5 more Test Failed. End: st_derby715 jdk1.4.2 storeall:storetests 2012-03-17 20:09:53 ***
          Hide
          Mike Matrigali added a comment -

          failed also against 10.8 branch, windows, ibm142, build 1302750
          http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm142/1302750-derbyall_diff.txt
          Failure Details:

                          • Diff file derbyall/encryptionAll/encryptionBlowfish/T_CipherBlowfish.diff
              • Start: T_CipherBlowfish jdk1.4.2 encryptionAll:encryptionBlowfish 2012-03-19 20:29:58 ***
                Test skipped: test cannot run with jvm: ibm14. T_CipherBlowfish.unit
              • End: T_CipherBlowfish jdk1.4.2 encryptionAll:encryptionBlowfish 2012-03-19 20:29:58 ***
                          • Diff file derbyall/storeall/storetests/st_derby715.diff
              • Start: st_derby715 jdk1.4.2 storeall:storetests 2012-03-19 20:04:53 ***
                4 del
                < Got a Deadlock.
                Test Failed.
              • End: st_derby715 jdk1.4.2 storeall:storetests 2012-03-19 20:05:10 ***
          Show
          Mike Matrigali added a comment - failed also against 10.8 branch, windows, ibm142, build 1302750 http://people.apache.org/~myrnavl/derby_test_results/v10_8/windows/testlog/ibm142/1302750-derbyall_diff.txt Failure Details: Diff file derbyall/encryptionAll/encryptionBlowfish/T_CipherBlowfish.diff Start: T_CipherBlowfish jdk1.4.2 encryptionAll:encryptionBlowfish 2012-03-19 20:29:58 *** Test skipped: test cannot run with jvm: ibm14. T_CipherBlowfish.unit End: T_CipherBlowfish jdk1.4.2 encryptionAll:encryptionBlowfish 2012-03-19 20:29:58 *** Diff file derbyall/storeall/storetests/st_derby715.diff Start: st_derby715 jdk1.4.2 storeall:storetests 2012-03-19 20:04:53 *** 4 del < Got a Deadlock. Test Failed. End: st_derby715 jdk1.4.2 storeall:storetests 2012-03-19 20:05:10 ***
          Hide
          Myrna van Lunteren added a comment -

          Saw this with 10.8.2.2 (RC3) with ibm 1.5, on AIX 6.1

          Show
          Myrna van Lunteren added a comment - Saw this with 10.8.2.2 (RC3) with ibm 1.5, on AIX 6.1
          Myrna van Lunteren made changes -
          Labels derby_triage10_8
          Urgency Normal
          Dag H. Wanvik made changes -
          Component/s Test [ 11413 ]
          Dag H. Wanvik made changes -
          Component/s Regression Test Failure [ 12310664 ]
          Dag H. Wanvik made changes -
          Derby Categories [Regression Test Failure]
          Hide
          Myrna van Lunteren added a comment -

          saw this with 10.5.1.0 with ibm 1.6.

          Show
          Myrna van Lunteren added a comment - saw this with 10.5.1.0 with ibm 1.6.
          Myrna van Lunteren made changes -
          Field Original Value New Value
          Attachment derby.log [ 12380221 ]
          Attachment st_derby715.tmp [ 12380222 ]
          Hide
          Myrna van Lunteren added a comment -

          attaching derby.log found after failure, and .tmp file (which was same as .out).

          Show
          Myrna van Lunteren added a comment - attaching derby.log found after failure, and .tmp file (which was same as .out).
          Myrna van Lunteren created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development