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.

Starting Oozie server failed

Starting Oozie server failed

New Contributor

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

7 REPLIES 7

Re: Starting Oozie server failed

Explorer

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

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

Re: Starting Oozie server failed

New Contributor

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!

Re: Starting Oozie server failed

Master Guru
Did you manually alter any DB settings under Oozie Configuration page in CM? Could you try reverting it, if so?

Re: Starting Oozie server failed

New Contributor

I didnt changed anything, its the default setting, sorry

Re: Starting Oozie server failed

New Contributor

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').

 

 

Re: Starting Oozie server failed

Explorer

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

Re: Starting Oozie server failed

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