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.
... View more
