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