You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Attila Sasvari (JIRA)" <ji...@apache.org> on 2018/02/08 16:37:00 UTC
[jira] [Commented] (OOZIE-3175) PurgeService should detect and
delete orphaned jobs/actions
[ https://issues.apache.org/jira/browse/OOZIE-3175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16357179#comment-16357179 ]
Attila Sasvari commented on OOZIE-3175:
---------------------------------------
An example SQL query to detect orphan workflow actions:
{{SELECT a.id, a.wf_id FROM WF_ACTIONS a WHERE NOT EXISTS (SELECT 1 FROM WF_JOBS j WHERE j.id=a.wf_id);}}
> PurgeService should detect and delete orphaned jobs/actions
> ------------------------------------------------------------
>
> Key: OOZIE-3175
> URL: https://issues.apache.org/jira/browse/OOZIE-3175
> Project: Oozie
> Issue Type: Improvement
> Components: core
> Affects Versions: trunk
> Reporter: Attila Sasvari
> Priority: Major
>
> Improvement idea: the purge service could look for orphaned jobs/actions and delete those. It would help the cases where the user went in and only partially removed things.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)