Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Failed to install Oozie

avatar
Contributor

When I try to install Oozie it give me this error:

2016-02-25 18:22:24,260 INFO org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Overriding configuration with system property. Key [oozie.http.port], Value [11000] 
2016-02-25 18:22:24,268 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.service.ProxyUserService.proxyuser.hue.hosts] 
2016-02-25 18:22:24,268 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.service.GroupsService.hadoop.security.group.mapping] 
2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.service.ProxyUserService.proxyuser.hue.groups] 
2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [hadoop.security.credential.provider.path] 
2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.email.from.address] 
2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.email.smtp.port] 
2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.email.smtp.host] 
2016-02-25 18:22:24,270 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.email.smtp.auth] 
2016-02-25 18:22:24,274 WARN org.apache.oozie.service.Services: SERVER[cloudera1] System ID [oozie-oozi] exceeds maximum length [10], trimming
2016-02-25 18:22:24,275 INFO org.apache.oozie.service.Services: SERVER[cloudera1] Exiting null Entering NORMAL
2016-02-25 18:22:24,276 INFO oozieops: SERVER[cloudera1] Exiting null Entering NORMAL
2016-02-25 18:22:24,276 INFO org.apache.oozie.service.Services: SERVER[cloudera1] Initialized runtime directory [/tmp/oozie-oozi6638948414612903101.dir]

stdout

Thu Feb 25 18:22:22 UTC 2016
JAVA_HOME=/usr/lib/jvm/java-7-oracle-cloudera
using 5 as CDH_VERSION

Validate DB Connection

stderr

Error: Could not connect to the database: org.postgresql.util.PSQLException: The connection attempt failed.

Stack trace for the error was (for debug purposes):
--------------------------------------
java.lang.Exception: Could not connect to the database: org.postgresql.util.PSQLException: The connection attempt failed.
	at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:905)
	at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:185)
	at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:129)
	at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:80)
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:150)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.connect(Driver.java:267)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:215)
	at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:895)
	at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:901)
	... 3 more
Caused by: java.net.UnknownHostException: :
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:178)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:579)
	at java.net.Socket.connect(Socket.java:528)
	at java.net.Socket.<init>(Socket.java:425)
	at java.net.Socket.<init>(Socket.java:208)
	at org.postgresql.core.PGStream.<init>(PGStream.java:62)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
	... 15 more
--------------------------------------

It successfully creates Oozie database but fails creating oozie database tables.

 

 

I'm using the last version of CDH in Ubuntu 14.04.

 

Regards,

 

 

 

 

 

1 ACCEPTED SOLUTION

avatar
Contributor
I had to format all the cluster to solve this.

Regard,

View solution in original post

1 REPLY 1

avatar
Contributor
I had to format all the cluster to solve this.

Regard,