Reply
New Contributor
Posts: 5
Registered: ‎06-23-2015

Starting Oozie server failed

Hello,

 

iam completely new in this topic of Cloudera. At the moment iam using the Cloudera Manager on a single Cluster mit CDH 5.4.2.

 

But i have an issue with the Oozie server. Shortly after starting it stops. The oozie-log looks like:

 

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "oozie_oozie_server")
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110)
at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87)
at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91)
... 46 more
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "oozie_oozie_server"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
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 org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource

 

What is the meaning of the failed password authentication? Iam running Cloudera on a Linux Distribution via SSH.

 

Hopefully i can someday execute my first Hive query :/

Thank you

Explorer
Posts: 7
Registered: ‎06-18-2015

Re: Starting Oozie server failed

Can you pls see catalina.log in /var/log/oozie/catalina.log

Since it has tomcat web server. this logs may help better understanding

Posts: 1,896
Kudos: 433
Solutions: 303
Registered: ‎07-31-2013

Re: Starting Oozie server failed

Did you manually alter any DB settings under Oozie Configuration page in CM? Could you try reverting it, if so?
New Contributor
Posts: 5
Registered: ‎06-23-2015

Re: Starting Oozie server failed

I didnt changed anything, its the default setting, sorry

New Contributor
Posts: 5
Registered: ‎06-23-2015

Re: Starting Oozie server failed

Hello,

 

the log file looks like this:

 

Jun 23, 2015 2:21:15 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:21:24 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:21:24 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 11620 ms
Jun 23, 2015 2:21:24 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:21:24 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:21:24 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:22:20 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:22:21 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:22:21 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1104 ms
Jun 23, 2015 2:22:21 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:22:21 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:22:21 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:22:28 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:22:28 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:22:28 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1267 ms
Jun 23, 2015 2:22:28 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina

Jun 23, 2015 2:22:46 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:22:46 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:29:24 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:29:24 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:29:24 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1082 ms
Jun 23, 2015 2:29:24 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:29:24 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:29:24 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:29:31 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:29:32 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:29:32 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1214 ms
Jun 23, 2015 2:29:32 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:29:32 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:29:32 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:36:47 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:36:48 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:36:48 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1098 ms
Jun 23, 2015 2:36:48 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:36:48 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:36:48 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:36:55 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:36:55 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:36:55 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1143 ms
Jun 23, 2015 2:36:55 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:36:55 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:36:55 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:37:03 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:37:03 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:37:03 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 1303 ms
Jun 23, 2015 2:38:30 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:38:30 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:38:30 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:57:28 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:57:29 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:57:29 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1176 ms
Jun 23, 2015 2:57:29 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:57:29 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:57:29 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:57:36 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:57:37 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:57:37 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1071 ms

Jun 23, 2015 2:57:37 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:57:37 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:57:37 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 2:57:45 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 2:57:45 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 2:57:45 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1289 ms
Jun 23, 2015 2:57:46 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 2:57:46 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 2:57:46 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive oozie.war
Jun 23, 2015 3:52:37 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 3:52:37 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 3:52:37 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1294 ms
Jun 23, 2015 3:52:37 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 3:52:37 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 3:52:37 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 3:52:44 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 3:52:44 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 3:52:44 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1242 ms
Jun 23, 2015 3:52:44 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 3:52:45 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 3:52:45 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war
Jun 23, 2015 3:52:53 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environ$
Jun 23, 2015 3:52:54 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-11000
Jun 23, 2015 3:52:54 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 877 ms
Jun 23, 2015 4:16:34 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2015 4:16:34 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.43
Jun 23, 2015 4:16:34 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive oozie.war

 

Maybe it helps!

Highlighted
New Contributor
Posts: 5
Registered: ‎06-23-2015

Re: Starting Oozie server failed

The thing is, when i want to start HUE and under example try to use the HIVE Editor an error occures that says something about that the table could not be installed because the connection to MYIP:10000(code THRIFTTRANSPORT): TTransportException('Could not connecto to MYIP:10000').

 

 

Explorer
Posts: 15
Registered: ‎05-07-2015

Re: Starting Oozie server failed

Hi Fredeli,

 

Seems like some changes have been done for oozie database as the user name mentioned in the error is different than default(sa).

 

Can you paste your configuration file for oozie? oozie-site.xml

Posts: 1,896
Kudos: 433
Solutions: 303
Registered: ‎07-31-2013

Re: Starting Oozie server failed

You can also try to delete and re-add the Oozie service entirely.

Announcements

Our community is getting a little larger. And a lot better.


Learn More about the Cloudera and Hortonworks community merger planned for late July and early August.