Creating Oozie database step failed during cluster setup

Prakash144 — Fri, 16 Sep 2022 09:22:58 GMT

Create Oozie database step failed when setting up cluster. I did clean up my previous install as that was failed during deploy client config step. I tried after cleaning up /var/lib/oozie/* but no luck. Please let me know some solution to come out of this. I tried to connect psql uitlity but not recognizing my psql command.

Error: DB schema exists

Stack trace for the error was (for debug purposes):
--------------------------------------
java.lang.Exception: DB schema exists
	at org.apache.oozie.tools.OozieDBCLI.validateDBSchema(OozieDBCLI.java:929)
	at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:184)
	at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:127)
	at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:78)
--------------------------------------

Re: Creating Oozie database step failed during cluster setup

Prakash144 — Mon, 02 Mar 2015 16:55:54 GMT

This is resolved after cleaning up oozie directory. In my case rm -rf /rms/var/lib/oozie/*

question Creating Oozie database step failed during cluster setup in Archives of Support Questions (Read Only)

Creating Oozie database step failed during cluster setup

Re: Creating Oozie database step failed during cluster setup