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.

Oozie CMAgent isn't able to communicate with this role's WS. Cannot create PoolableConnectionFactory

Oozie CMAgent isn't able to communicate with this role's WS. Cannot create PoolableConnectionFactory

New Contributor

Hello.

 

I installed CDH 5.8.0 Parcels with:

Flume -> GOOD HEALTH
HDFS -> GOOD HEALTH, 1 CRITICAL (Filesystem checkpoint), 1 WARNING
Hive  -> 2 CONCERNING, 1 WARNING
Hue -> 1 CONCERNING
Impala -> 2 CONCERNING
Oozie -> BAD HEALTH, 2 CRITICAL: 

    Process Status - This role's process exited. This role is supposed to be started.

    Web Server Status -The Cloudera Manager Agent is not able to communicate with this role's web server.
YARN (MR2 Included) -> 3 CONCERNING
ZooKeeper-> 1 CONCERNING, 1 WARNING

 

4 hosts:

SATURNO -> GOOD HEALTH

  • HDFS Balancer -> NONE
  • HDFS NameNode -> BAD HEALTH
  • HDFS SecondaryNameNode -> CONCERNING HEALTH
  • Hive Gateway -> NONE
  • Hive Metastore Server  -> CONCERNING HEALTH
  • HiveServer2  -> CONCERNING HEALTH
  • Hue Server  -> CONCERNING HEALTH
  • Impala Catalog Server -> CONCERNING HEALTH
  • Impala StateStore -> CONCERNING HEALTH
  • Cloudera Management Service Alert Publisher -> CONCERNING HEALTH
  • Cloudera Management Service Event Server -> CONCERNING HEALTH
  • Cloudera Management Service Host Monitor -> CONCERNING HEALTH
  • Cloudera Management Service Service Monitor -> CONCERNING HEALTH
  • Oozie Server -> DOWN
  • YARN (MR2 Included) JobHistory Server -> CONCERNING HEALTH
  • YARN (MR2 Included) ResourceManager -> CONCERNING HEALTH
  • ZooKeeper Server

 

TITAN (GOOD HEALTH), TETIS (GOOD HEALTH), REA (GOOD HEALTH)

  • Flume Agent -> BAD
  • HDFS DataNode -> GOOD HEALTH
  • Hive Gateway -> NONE
  • Impala Daemon -> GOOD HEALTH
  • YARN (MR2 Included) NodeManager -> GOOD HEALTH

 

 

In logFiles:

SERVER[saturno] E0103: Could not load service classes, Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)

 

 

oozie-site.xml:

<property>
   <name>oozie.service.JPAService.jdbc.driver</name>
   <value>com.mysql.jdbc.Driver</value>
</property>
<property>
   <name>oozie.service.JPAService.jdbc.username</name>
   <value>oozie_oozie_server</value>
</property>
<property>
   <name>oozie.service.JPAService.jdbc.password</name>
   <value>********</value>
</property>
<property>
   <name>oozie.service.JPAService.jdbc.url</name>
   <value>jdbc:mysql://saturno:7432/oozie_oozie_server?useUnicode=true&amp;characterEncoding=UTF-8</value>
</property>
<property>
   <name>oozie.base.url</name>
   <value>http://saturno:11000/oozie</value>
</property>

 

 

It isn´t possible to connect to http://saturno:11000/oozie in a web-navigator (Firefox).

Libraries:

/opt/cloudera/parcels/CDH-5.8.0-1.cdh5.8.0.p0.42/lib/oozie/libtools/openjpa-persistence-jdbc-2.2.2.jar
/opt/cloudera/parcels/CDH-5.8.0-1.cdh5.8.0.p0.42/lib/oozie/libtools/openjpa-jdbc-2.2.2.jar
/opt/cloudera/parcels/CDH-5.8.0-1.cdh5.8.0.p0.42/lib/oozie/libtools/openjpa-persistence-jdbc-2.2.2.jar
/opt/cloudera/parcels/CDH-5.8.0-1.cdh5.8.0.p0.42/lib/oozie/libtools/openjpa-jdbc-2.2.2.jar
/opt/cloudera/parcels/CDH-5.8.0-1.cdh5.8.0.p0.42/jars/openjpa-persistence-jdbc-2.2.2.jar
/opt/cloudera/parcels/CDH-5.8.0-1.cdh5.8.0.p0.42/jars/openjpa-jdbc-2.2.2.jar

 

2 REPLIES 2

Re: Oozie CMAgent isn't able to communicate with this role's WS. Cannot create PoolableConnectionFac

Explorer

were you able to solve this? I am getting the same error for Hue and Oozie as well. 

Re: Oozie CMAgent isn't able to communicate with this role's WS. Cannot create PoolableConnectionFac

Super Guru

@DataYogi,

 

Can you clarify what the problem is for you?  This thread showed an issue where the Oozie web service was not funtioning but the issue was not explored enough to identify the cause or what the original issue was precisely.

 

If you are seeing Oozie in a bad state due to the agent ont being able to communicate with the Oozie web service, then check the agent log on the oozie host (/var/log/cloudera-scm-agent/cloudera-scm-agent.log)

You should see a stack trace for any failed attempt by the agent to request information from the Oozie server.

If you cannot identify the cause of the problem based on that, please share the stack with us.