Cloudera Manager CDH5 - Installation Failure on Oozie Database

Posted by Nerrve on Server Fault See other posts from Server Fault or by Nerrve
Published on 2014-06-13T14:33:08Z Indexed on 2014/06/13 15:27 UTC
Read the original article Hit count: 801

Filed under:

cloudera

|

cloudera-manager

While doing the installation, i keep getting a failure on the step "Creating Oozie database"

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)

How do i fix this? Where do i get the password/username/dbname for the PostgreSQL database to drop the existing schema?

I tried cat /etc/cloudera-scm-server/db*.properties | grep pass

and

/var/lib/cloudera-scm-server-db/data/generated-password.txt

but the passwords don't work!

© Server Fault or respective owner

Related posts about cloudera

Cloudera Hadoop Certification Value in IT Industry for freshers

as seen on Programmers - Search for 'Programmers'
I am a software developer with 8 months of experience in IT industry working on development of tools for BIG DATA analytics. I have learned Hadoop basics on my own and I am pretty comfortable with writing MapReduce Jobs, PIG, HIVE, Flume and other related projects. I am thinking of appearing for Cloudera… >>> More
Cloudera Manager agent deploy failing to receive heartbeat from agent

as seen on Server Fault - Search for 'Server Fault'
All, I am getting the error on the console at the last phase of the installation: Installation failed. Failed to receive heartbeat from agent Server Log: 2012-12-19 00:32:12,132 INFO [NodeConfiguratorThread-4- 0:node.NodeConfiguratorProgress@503] 192.168.1.100: Setting WAIT_FOR_HEARTBEAT… >>> More
Make cloudera-vm work on Oracle VM VirtualBox

as seen on Server Fault - Search for 'Server Fault'
I downloaded this and the instructions say: Important: You must enable the I/O APIC in order to use 64-bit mode. (See http://www.virtualbox.org/manual/ch03.html.) On newer versions of VirtualBox, it may default to using SATA as the disk interface. This can cause a kernel panic in the VM. Switching… >>> More
Configuring correct port for Oozie (invoking PIG script) in Cloudera Hue

as seen on Stack Overflow - Search for 'Stack Overflow'
I am new to CDH4 Oozie workflow editor. While trying to invoke a pig script from Oozie workflow editor, i am getting the following error. HadoopAccessorException: E0900: Jobtracker [mymachine:8032] not allowed, not in Oozies whitelist It looks like Oozie is submitting the job to Yarn port (8032)… >>> More
Cloudera Manager CDH5 - Installation Failure on Oozie Database

as seen on Server Fault - Search for 'Server Fault'
While doing the installation, i keep getting a failure on the step "Creating Oozie database" 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… >>> More

Related posts about cloudera-manager

Cloudera Manager CDH5 - Installation Failure on Oozie Database

as seen on Server Fault - Search for 'Server Fault'
While doing the installation, i keep getting a failure on the step "Creating Oozie database" 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… >>> More
Cloudera Manager agent deploy failing to receive heartbeat from agent

as seen on Server Fault - Search for 'Server Fault'
All, I am getting the error on the console at the last phase of the installation: Installation failed. Failed to receive heartbeat from agent Server Log: 2012-12-19 00:32:12,132 INFO [NodeConfiguratorThread-4- 0:node.NodeConfiguratorProgress@503] 192.168.1.100: Setting WAIT_FOR_HEARTBEAT… >>> More
Typical Hadoop setup for remote job submission

as seen on Stack Overflow - Search for 'Stack Overflow'
So I am still a bit new to hadoop and am currently in the process of setting up a small test cluster on Amazonaws. So my question relates to some tips on the structuring of the cluster so it is possible to work submit jobs from remote machines. Currently I have 5 machines. 4 are basically the Hadoop… >>> More
Big Data Appliance X4-2 Release Announcement

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Today we are announcing the release of the 3rd generation Big Data Appliance. Read the Press Release here. Software Focus The focus for this 3rd generation of Big Data Appliance is: Comprehensive and Open - Big Data Appliance now includes all Cloudera Software, including Back-up… >>> More
Configuring correct port for Oozie (invoking PIG script) in Cloudera Hue

as seen on Stack Overflow - Search for 'Stack Overflow'
I am new to CDH4 Oozie workflow editor. While trying to invoke a pig script from Oozie workflow editor, i am getting the following error. HadoopAccessorException: E0900: Jobtracker [mymachine:8032] not allowed, not in Oozies whitelist It looks like Oozie is submitting the job to Yarn port (8032)… >>> More