You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Michael Dick (JIRA)" <ji...@apache.org> on 2009/07/30 16:09:14 UTC

[jira] Created: (OPENJPA-1210) Specify derby timeouts via properties.

Specify derby timeouts via properties.
--------------------------------------

                 Key: OPENJPA-1210
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1210
             Project: OpenJPA
          Issue Type: Sub-task
            Reporter: Michael Dick
            Assignee: Michael Dick




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


[jira] Closed: (OPENJPA-1210) Specify derby timeouts via properties.

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick closed OPENJPA-1210.
---------------------------------

    Resolution: Fixed

> Specify derby timeouts via properties.
> --------------------------------------
>
>                 Key: OPENJPA-1210
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1210
>             Project: OpenJPA
>          Issue Type: Sub-task
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>   Original Estimate: 0h
>  Remaining Estimate: 0h
>


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


Re: [jira] Updated: (OPENJPA-1210) Specify derby timeouts via properties.

Posted by Michael Dick <mi...@gmail.com>.
Hi Donald,

I didn't run trunk with those examples, I tried 5 and 10 though and it
worked.

When I added those comments I was thinking of the service releases which
don't have the lock manager tests (those values have worked for me in the
past). I'll add remarks to the JIRA to indicate that these are not safe
values for trunk at this moment.

Good catch though - I should have thought about trunk when I posted.

-mike

On Thu, Jul 30, 2009 at 1:16 PM, Donald Woods <dw...@apache.org> wrote:

> You ran the lockmgr and query.timeout tests under openjpa-persistence-jdbc
> with the derby-locking profile below?  Most of the lockmgr and query timeout
> tests failed when I tried using waitTimeout=6 while working on
> OPENJPA-1071....
>
>
> -Donald
>
>
>
> Michael Dick (JIRA) wrote:
>
>>     [
>> https://issues.apache.org/jira/browse/OPENJPA-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel]
>>
>> Michael Dick updated OPENJPA-1210:
>> ----------------------------------
>>
>>    Remaining Estimate: 0h
>>     Original Estimate: 0h
>>
>> Currently trunk uses the default derby.locks.waitTimeout (60) and a
>> derby.locks.deadlockTimeout of 5. I suspect that these can be tuned for the
>> developer's hardware and provide quicker test execution.
>> <anecdotal evidence>
>> setting waitTimeout = 10 saved me 5 - 10 minutes on a build last night.
>> </anecdotal evidence>
>>
>> The properties can be specified on the command line : $ mvn
>> -Dderby.locks.deadlockTimeout=10 -Dderby.locks.waitTimeout=15 clean test
>>  or in settings.xml :       <profile>
>>            <id>derby-locking</id>
>>            <properties>
>>
>>  <derby.locks.deadlockTimeout>3</derby.locks.deadlockTimeout>
>>                <derby.locks.waitTimeout>5</derby.locks.waitTimeout>
>>            </properties>
>>        </profile>
>>
>>  The profile (as shown) needs to be activated on the command line  :  $
>> mvn -Pderby-locking clean test
>>
>>  Specify derby timeouts via properties.
>>> --------------------------------------
>>>
>>>                Key: OPENJPA-1210
>>>                URL: https://issues.apache.org/jira/browse/OPENJPA-1210
>>>            Project: OpenJPA
>>>         Issue Type: Sub-task
>>>           Reporter: Michael Dick
>>>           Assignee: Michael Dick
>>>  Original Estimate: 0h
>>>  Remaining Estimate: 0h
>>>
>>>
>>
>>

Re: [jira] Updated: (OPENJPA-1210) Specify derby timeouts via properties.

Posted by Donald Woods <dw...@apache.org>.
You ran the lockmgr and query.timeout tests under 
openjpa-persistence-jdbc with the derby-locking profile below?  Most of 
the lockmgr and query timeout tests failed when I tried using 
waitTimeout=6 while working on OPENJPA-1071....


-Donald


Michael Dick (JIRA) wrote:
>      [ https://issues.apache.org/jira/browse/OPENJPA-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
> 
> Michael Dick updated OPENJPA-1210:
> ----------------------------------
> 
>     Remaining Estimate: 0h
>      Original Estimate: 0h
> 
> Currently trunk uses the default derby.locks.waitTimeout (60) and a derby.locks.deadlockTimeout of 5. I suspect that these can be tuned for the developer's hardware and provide quicker test execution. 
> 
> <anecdotal evidence>
> setting waitTimeout = 10 saved me 5 - 10 minutes on a build last night. 
> </anecdotal evidence>
> 
> The properties can be specified on the command line : 
> $ mvn -Dderby.locks.deadlockTimeout=10 -Dderby.locks.waitTimeout=15 clean test
>  
> or in settings.xml : 
>        <profile>
>             <id>derby-locking</id>
>             <properties>
>                 <derby.locks.deadlockTimeout>3</derby.locks.deadlockTimeout>
>                 <derby.locks.waitTimeout>5</derby.locks.waitTimeout>
>             </properties>
>         </profile>
> 
>  The profile (as shown) needs to be activated on the command line  : 
>  $ mvn -Pderby-locking clean test
> 
>> Specify derby timeouts via properties.
>> --------------------------------------
>>
>>                 Key: OPENJPA-1210
>>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1210
>>             Project: OpenJPA
>>          Issue Type: Sub-task
>>            Reporter: Michael Dick
>>            Assignee: Michael Dick
>>   Original Estimate: 0h
>>  Remaining Estimate: 0h
>>
> 
> 

[jira] Updated: (OPENJPA-1210) Specify derby timeouts via properties.

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick updated OPENJPA-1210:
----------------------------------

    Remaining Estimate: 0h
     Original Estimate: 0h

Currently trunk uses the default derby.locks.waitTimeout (60) and a derby.locks.deadlockTimeout of 5. I suspect that these can be tuned for the developer's hardware and provide quicker test execution. 

<anecdotal evidence>
setting waitTimeout = 10 saved me 5 - 10 minutes on a build last night. 
</anecdotal evidence>

The properties can be specified on the command line : 
$ mvn -Dderby.locks.deadlockTimeout=10 -Dderby.locks.waitTimeout=15 clean test
 
or in settings.xml : 
       <profile>
            <id>derby-locking</id>
            <properties>
                <derby.locks.deadlockTimeout>3</derby.locks.deadlockTimeout>
                <derby.locks.waitTimeout>5</derby.locks.waitTimeout>
            </properties>
        </profile>

 The profile (as shown) needs to be activated on the command line  : 
 $ mvn -Pderby-locking clean test

> Specify derby timeouts via properties.
> --------------------------------------
>
>                 Key: OPENJPA-1210
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1210
>             Project: OpenJPA
>          Issue Type: Sub-task
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>   Original Estimate: 0h
>  Remaining Estimate: 0h
>


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


[jira] Updated: (OPENJPA-1210) Specify derby timeouts via properties.

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick updated OPENJPA-1210:
----------------------------------

    Affects Version/s: 2.0.0
                       1.3.0
                       1.0.3
                       1.2.1
        Fix Version/s: 2.0.0
                       1.3.0
                       1.2.2
                       1.0.4

> Specify derby timeouts via properties.
> --------------------------------------
>
>                 Key: OPENJPA-1210
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1210
>             Project: OpenJPA
>          Issue Type: Sub-task
>    Affects Versions: 1.0.3, 1.2.1, 1.3.0, 2.0.0
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>             Fix For: 1.0.4, 1.2.2, 1.3.0, 2.0.0
>
>   Original Estimate: 0h
>  Remaining Estimate: 0h
>


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


[jira] Commented: (OPENJPA-1210) Specify derby timeouts via properties.

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OPENJPA-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12737232#action_12737232 ] 

Michael Dick commented on OPENJPA-1210:
---------------------------------------

The values in the profile might not work well on trunk (I haven't tried) - they should be good for earlier releases (1.0.x).

The earlier releases do not include an extensive lock manager test suite. The lock manager test suite is sensitive to these settings and has been known to cause problems with deadlockTimeout=5, waitTimeout=6. 

Some experimentation (without local changes) is advised before changing them in your environment (YMMV). 

> Specify derby timeouts via properties.
> --------------------------------------
>
>                 Key: OPENJPA-1210
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1210
>             Project: OpenJPA
>          Issue Type: Sub-task
>    Affects Versions: 1.0.3, 1.2.1, 1.3.0, 2.0.0
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>             Fix For: 1.0.4, 1.2.2, 1.3.0, 2.0.0
>
>   Original Estimate: 0h
>  Remaining Estimate: 0h
>


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


[jira] Updated: (OPENJPA-1210) Specify derby timeouts via properties.

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick updated OPENJPA-1210:
----------------------------------

         Priority: Minor  (was: Major)
    Fix Version/s: 1.3.0
                   1.2.2
                   1.0.4

> Specify derby timeouts via properties.
> --------------------------------------
>
>                 Key: OPENJPA-1210
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1210
>             Project: OpenJPA
>          Issue Type: Sub-task
>    Affects Versions: 1.0.3, 1.2.1, 1.3.0, 2.0.0
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>            Priority: Minor
>             Fix For: 1.0.4, 1.2.2, 1.3.0, 2.0.0-M3
>
>   Original Estimate: 0h
>  Remaining Estimate: 0h
>


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