[jira] Created: (DERBY-4037) On Z/OS storetests/st_reclaim_longcol.java fails with a large number of pages

On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
------------------------------------------------------------------------------

                 Key: DERBY-4037
                 URL: https://issues.apache.org/jira/browse/DERBY-4037
             Project: Derby
          Issue Type: Bug
          Components: Store
    Affects Versions: 10.3.3.0
         Environment: java version "1.6.0"
Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
J9VM - 20081105_025433_BHdSMr
JIT  - r9_20081031_1330
GC   - 20081027_AB)
JCL  - 20081106_01
            Reporter: Kathey Marsden


On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
*** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
3a4,6
> Test failed, expected less than 150 pages - count is:
> free pages     : 258
> allocated pages: 2047
Test Failed.
*** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***



--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/DERBY-4037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-4037:
---------------------------------

    Component/s: Test

> On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4037
>                 URL: https://issues.apache.org/jira/browse/DERBY-4037
>             Project: Derby
>          Issue Type: Bug
>          Components: Store, Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
>            Reporter: Kathey Marsden
>
> On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
> ********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
> *** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
> 3a4,6
> > Test failed, expected less than 150 pages - count is:
> > free pages     : 258
> > allocated pages: 2047
> Test Failed.
> *** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/DERBY-4037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen resolved DERBY-4037.
---------------------------------------

    Resolution: Duplicate

Triaged for 10.5.2. Duplicate of DERBY-1913.

> On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4037
>                 URL: https://issues.apache.org/jira/browse/DERBY-4037
>             Project: Derby
>          Issue Type: Bug
>          Components: Store, Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
>            Reporter: Kathey Marsden
>
> On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
> ********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
> *** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
> 3a4,6
> > Test failed, expected less than 150 pages - count is:
> > free pages     : 258
> > allocated pages: 2047
> Test Failed.
> *** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/DERBY-4037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12727023#action_12727023 ]

Kathey Marsden commented on DERBY-4037:
---------------------------------------

I would like to reopen this issue because it fails consistently with an over 2000 page difference vs the small number of pages and an intermittent nature  associated with DERBY-1913.   I think maybe it is a different issue.

> On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4037
>                 URL: https://issues.apache.org/jira/browse/DERBY-4037
>             Project: Derby
>          Issue Type: Bug
>          Components: Store, Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
>            Reporter: Kathey Marsden
>
> On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
> ********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
> *** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
> 3a4,6
> > Test failed, expected less than 150 pages - count is:
> > free pages     : 258
> > allocated pages: 2047
> Test Failed.
> *** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/DERBY-4037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12727083#action_12727083 ]

Knut Anders Hatlen commented on DERBY-4037:
-------------------------------------------

Feel free to reopen if you don't think they are duplicates.

> On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4037
>                 URL: https://issues.apache.org/jira/browse/DERBY-4037
>             Project: Derby
>          Issue Type: Bug
>          Components: Store, Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
>            Reporter: Kathey Marsden
>
> On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
> ********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
> *** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
> 3a4,6
> > Test failed, expected less than 150 pages - count is:
> > free pages     : 258
> > allocated pages: 2047
> Test Failed.
> *** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/DERBY-4037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden reopened DERBY-4037:
-----------------------------------


reopening the issue as I think it may not be a duplicate.

> On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4037
>                 URL: https://issues.apache.org/jira/browse/DERBY-4037
>             Project: Derby
>          Issue Type: Bug
>          Components: Store, Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
>            Reporter: Kathey Marsden
>
> On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
> ********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
> *** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
> 3a4,6
> > Test failed, expected less than 150 pages - count is:
> > free pages     : 258
> > allocated pages: 2047
> Test Failed.
> *** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/DERBY-4037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali reassigned DERBY-4037:
-------------------------------------

    Assignee: Mike Matrigali

> On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4037
>                 URL: https://issues.apache.org/jira/browse/DERBY-4037
>             Project: Derby
>          Issue Type: Bug
>          Components: Store, Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
>            Reporter: Kathey Marsden
>            Assignee: Mike Matrigali
>
> On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
> ********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
> *** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
> 3a4,6
> > Test failed, expected less than 150 pages - count is:
> > free pages     : 258
> > allocated pages: 2047
> Test Failed.
> *** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/DERBY-4037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12742879#action_12742879 ]

Kathey Marsden commented on DERBY-4037:
---------------------------------------

Thanks Mike for the improved test.  I tried it on z/os and still see this failure:
********* Diff file storetests/storetests/st_reclaim_longcol.diff
*** Start: st_reclaim_longcol jdk1.6.0 storetests:storetests 2009-08-13 11:52:09 ***

  3a4,7
  > Test 2 failed, expected less than 150 pages - count is:
  > free pages     : 2646
  > allocated pages: 55
  > Waited 100020ms. for background work.
  Test Failed.
  *** End:   st_reclaim_longcol jdk1.6.0 storetests:storetests 2009-08-13 11:55:50 ***

This is with:
java version "1.6.0"
Java(TM) SE Runtime Environment (build pmz3160sr5-20090517_02(SR5))
IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390-31 jvmmz3160sr5-20090516_35588 (JIT enabled, AOT enabled)
J9VM - 20090516_035588_bHdSMr
JIT  - r9_20090515_1756
GC   - 20090417_AA)
JCL  - 20090516_01

> On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4037
>                 URL: https://issues.apache.org/jira/browse/DERBY-4037
>             Project: Derby
>          Issue Type: Bug
>          Components: Store, Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
>            Reporter: Kathey Marsden
>            Assignee: Mike Matrigali
>
> On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
> ********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
> *** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
> 3a4,6
> > Test failed, expected less than 150 pages - count is:
> > free pages     : 258
> > allocated pages: 2047
> Test Failed.
> *** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/DERBY-4037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali updated DERBY-4037:
----------------------------------


thanks for the new report.  It looks like the test needs some more tweaking.  The new output shows that the wait at end did allow for the system to free up a bunch of pages, vs. the previous
report so I don't think there is a real problem here.  But the test really wants the free'ing to come
in the loop so that the subsequent insert can use the free'd pages of the previously committed
deleted.  For some reason this machine must not allow as concurrent background thread work
as other platforms.  I'll think about how best to change the test.

> On Z/OS storetests/st_reclaim_longcol.java  fails with a large number of pages
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4037
>                 URL: https://issues.apache.org/jira/browse/DERBY-4037
>             Project: Derby
>          Issue Type: Bug
>          Components: Store, Test
>    Affects Versions: 10.3.3.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pmz6460sr3-20081108_01(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390x-64 jvmmz6460-20081107_254
> J9VM - 20081105_025433_BHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> JCL  - 20081106_01
>            Reporter: Kathey Marsden
>            Assignee: Mike Matrigali
>
> On Z/OS 64 bit (haven't checked 32bit) st_reclaim_loncol fails with a large number of pages.
> ********* Diff file derbyall/storeall/storetests/st_reclaim_longcol.diff
> *** Start: st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:20:49 ***
> 3a4,6
> > Test failed, expected less than 150 pages - count is:
> > free pages     : 258
> > allocated pages: 2047
> Test Failed.
> *** End:   st_reclaim_longcol jdk1.6.0 storeall:storetests 2009-01-23 14:25:07 ***

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.