You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@oozie.apache.org by "jiraposter@reviews.apache.org (Commented) (JIRA)" <ji...@apache.org> on 2011/10/26 19:21:33 UTC

[jira] [Commented] (OOZIE-587) Out of memory issues due to current query design

    [ https://issues.apache.org/jira/browse/OOZIE-587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13136125#comment-13136125 ] 

jiraposter@reviews.apache.org commented on OOZIE-587:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/2573/
-----------------------------------------------------------

Review request for oozie, Mohammad Islam and Angelo K. Huang.


Summary
-------

Bug oozie-587
Summary: https://issues.apache.org/jira/browse/OOZIE-587


This addresses bug OOZIE-587.
    https://issues.apache.org/jira/browse/OOZIE-587


Diffs
-----

  trunk/core/src/main/java/org/apache/oozie/CoordinatorActionBean.java 1189035 
  trunk/core/src/main/java/org/apache/oozie/command/coord/CoordKillXCommand.java 1189035 
  trunk/core/src/main/java/org/apache/oozie/command/coord/CoordResumeXCommand.java 1189035 
  trunk/core/src/main/java/org/apache/oozie/command/coord/CoordSuspendXCommand.java 1189035 
  trunk/core/src/main/java/org/apache/oozie/executor/jpa/CoordActionGetJPAExecutor.java 1189035 
  trunk/core/src/main/java/org/apache/oozie/service/StatusTransitService.java 1189035 
  trunk/core/src/test/java/org/apache/oozie/executor/jpa/TestCoordActionUpdateStatusJPAExecutor.java PRE-CREATION 
  trunk/core/src/test/java/org/apache/oozie/executor/jpa/TestCoordJobGetActionsNotCompletedJPAExecutor.java PRE-CREATION 
  trunk/core/src/test/java/org/apache/oozie/executor/jpa/TestCoordJobGetActionsRunningJPAExecutor.java PRE-CREATION 
  trunk/core/src/test/java/org/apache/oozie/executor/jpa/TestCoordJobGetActionsStatusByPendingFalseJPAExecutor.java PRE-CREATION 
  trunk/core/src/test/java/org/apache/oozie/executor/jpa/TestCoordJobGetActionsSuspendedJPAExecutor.java PRE-CREATION 
  trunk/core/src/test/java/org/apache/oozie/executor/jpa/TestCoordJobGetPendingActionsCountJPAExecutor.java PRE-CREATION 

Diff: https://reviews.apache.org/r/2573/diff


Testing
-------

Added test cases for JPAExecutor. Tested against current test cases.


Thanks,

Virag


                
> Out of memory issues due to current query design
> ------------------------------------------------
>
>                 Key: OOZIE-587
>                 URL: https://issues.apache.org/jira/browse/OOZIE-587
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Virag Kothari
>
> There are services which run at regular intervals (StatusTransitService) and loads all the coordinator actions of a job in memory. Also Kill, Suspend and Resume commands bring all the coordinators actions of a job in memory. When the user had a couple of coordinator jobs each with around 10,000 actions, it caused an out of memory issue. 
> Solution: 
> Only required actions should be brought (through better use of sql seleciton and projection operators). "Select *" clause should be avoided unless necessary.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira