Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error CDH5 oozie

Error CDH5 oozie

Explorer

Hi.


I'm installing CDH5 express from cloudera manager and in the cluster setup I've got this message "Creating oozie database":

 

Failed to create Oozie database.

Program:oozie/oozie.sh ["db-command","create"]

 

Stderr:

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:877)
	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)
--------------------------------------

 

Stdout:

Fri Apr 11 08:29:49 CEST 2014
JAVA_HOME=/usr/java/jdk1.7.0_45-cloudera
using 5 as CDH_VERSION
using /var/lib/oozie/tomcat-deployment as CATALINA_BASE

Validate DB Connection
DONE
Check DB schema does not exist

 

Thanks!!!

 

Miguel Angel.

 

10 REPLIES 10
Highlighted

Re: Error CDH5 oozie

New Contributor

Hi Miguel,

 

I hit the same problem just now, while upgrading from 4.6 to 5.0.  I got around this by deleting the contents of /var/lib/oozie/:

 

rm -rf /var/lib/oozie/*

 

Obviously, this is a pretty drastic step, but it got me through.

 

Cheers,

 

Mark Cusack

Highlighted

Re: Error CDH5 oozie

New Contributor
THanks, after I delete /var/lib/oozie/*,It works.
Highlighted

Re: Error CDH5 oozie

Explorer

yep; same exact issue; having a force reinstall flag would be a nice thing.

 

Had to rm -rf name node directory also.

 

I swear the devlopers are trolling us when we hit items like this. 

Highlighted

Re: Error CDH5 oozie

Explorer

Cloudera does not clean-up properely on re-installs;

 

Also noticed if you change hostnames; its is almost unrecoverable; this should be extra fun for manufacturing to customer deployments.

 

Some other pain points; note your paths may be different:

 

rm /mnt/ssd/dfs/nn/current/ -rf

rm /mnt/ssd/dfs/snn/current/ -rf
ansible compute -a "rm -rf /mnt/ssd/dfs/dn/current/"
rm -rf /var/lib/oozie/*

 

Anisble Playbook for uninstalling cloduer manager:

--
- name: unInstall cloudera
shell: service cloudera-scm-agent stop
ignore_errors: true
shell: service cloudera-scm-server stop
ignore_errors: true
- action: yum pkg={{item}} state=absent
with_items:
- cloudera-manager-agent
- cloudera-manager-daemons
- avro-tools
- crunch
- flume-ng
- hadoop-hdfs-fuse
- hadoop-hdfs-nfs3
- hadoop-httpfs
- hbase-solr
- hive-hbase
- hive-webhcat
- hue-beeswax
- hue-hbase
- hue-impala
- hue-pig
- hue-plugins
- hue-rdbms
- hue-search
- hue-spark
- hue-sqoop
- hue-zookeeper
- impala
- impala-shell
- kite
- llama
- mahout
- oozie
- pig
- pig-udf-datafu
- search
- sentry
- solr-mapreduce
- spark-python
- sqoop
- sqoop2
- whirr
- cloudera-manager-server
- cloudera-manager-server-db-2

- shell: yum clean all
- shell: rm -Rf /usr/share/cmf /var/lib/cloudera* /var/cache/yum/cloudera*
#- shell: "for u in hdfs mapred cloudera-scm hbase hue zookeeper oozie hive impala flume; do sudo kill $(ps -u $u -o pid=); done"
- shell: rm /tmp/.scm_prepare_node.lock
ignore_errors: true

Highlighted

Re: Error CDH5 oozie

New Contributor

Hi,

What do you mean "Had to rm -rf name node directory also".

Can you point me to full path of this directory.

Thanks

Srinivas

Highlighted

Re: Error CDH5 oozie

New Contributor

Hi,

What do you mean by "Had to rm -rf name node directory also"

Can you specify the full path of this directory.

I had same issue and doing rm -rf /var/lib/oozie/* did not resolve my issue

 

Thanks

 

Highlighted

Re: Error CDH5 oozie

New Contributor
I had the same issue and I did run the rm -rf /var/lib/oozie/* same command still did not fix the problem, any other thoughts.
Highlighted

Re: Error CDH5 oozie

New Contributor

I had the same problem and I run "sudo rm -rf /var/lib/oozie/*". It did not work.

Highlighted

Re: Error CDH5 oozie

Explorer

I had the same problem.And I fix it after drop database oozie on postgresql.Good Luck.

Don't have an account?
Coming from Hortonworks? Activate your account here