[OOZIE-1559] Fix missing fields from new SELECT queries and Recovery Service picking up killed control nodes

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: trunk
• Fix Version/s: 4.1.0
• Assignee: Ryota Egashira
• Reporter: Ryota Egashira
• Created: 27/Sep/13 23:40
• Updated: 09/Dec/14 00:45
• Resolved: 17/Oct/13 18:23

Description

this jira to fix few issues with new SELECT queries.
one issue - workflow actions get stuck because recovery service does not pick up the pending actions. reason is that pendingAge in WF_ACTIONS table not updated property

the other issue - Recovery service does not pick up pending actions, and keeps picking up killed control nodes
when workflow is killed (KillXCommand) while control nodes(start/decision..etc) are being executed, KillXCommand set pending flag of the control node true, but subsequent ActionKillXCommand failed due to unsupported operation, fails to reset pending, so pending flag left to true. Thus, recovery service keep picking this up and start SignalXCommand, but it doesn't go through verifyPreCondition since workflow job status killed. the
same thing is repeated forever

Issue Links

• is broken by: OOZIE-1524 Change Workflow SELECT query to fetch only necessary columns and consolidate JPA Executors
• links to: Review Board

Sub-Tasks

• Correct some used and unused Workflow Action SELECT queries: Closed