Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

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,