question Re: Oozie Stuck in PREP - HDP 2.5.3 in Archives of Support Questions (Read Only)

Oozie Stuck in PREP - HDP 2.5.3

jpasswaters — Mon, 19 Aug 2019 08:43:43 GMT

When running any jobs, that were previously working, the job goes to PREP state (after the Start). Jobs were previously working with no issue.

When running an Oozie Service check, the following is received.

We recently upgraded from 2.3.0 to 2.5.3 and the jobs ran for a couple of days with no issue then in the middle of the day the jobs started acting like this.

When on the phone with Hortonworks Tech Support, we did set oozie.service.AuthorizationService.security.enabled to false and it temporarily started working and then quit again.

We do have HA enabled, but any of the posts that I have found didn't fix the issue.

Re: Oozie Stuck in PREP - HDP 2.5.3

aervits — Sat, 04 Mar 2017 13:17:11 GMT

@Jesse Passwaters please share job.properties and workflow.xml files

Re: Oozie Stuck in PREP - HDP 2.5.3

jpasswaters — Sat, 04 Mar 2017 13:27:32 GMT

Here are the 2 files. This is what is used when I run the service check which fails.

workflow.xml

jobproperties.txt

Re: Oozie Stuck in PREP - HDP 2.5.3

jpasswaters — Sat, 04 Mar 2017 23:47:05 GMT

After further troubleshooting and the changing of properties (with no success), I took the last resort of deleting the Oozie service and setting up on a new DB.

For now everything is back to normal. Root cause I suspect is db corruption.

This StackOverflow post kind of led me to do the inevitable.