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
