[
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)
