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.

Who agreed with this topic

HiveServer2 may be unavailable

New Contributor
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-5.9.1-1.cdh5.9.1.p0.4/jars/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/data/11/yarn/nm/filecache/4718/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Connecting to xxx/
Connected to: Apache Hive (version 1.1.0-cdh5.9.1)
Driver: Hive JDBC (version 1.1.0-cdh5.9.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
No rows affected (0.479 seconds)
No rows affected (0.003 seconds)
No rows affected (0.003 seconds)
No rows affected (0.003 seconds)
No rows affected (0.003 seconds)
No rows affected (0.002 seconds)
No rows affected (0.003 seconds)
HS2 may be unavailable, check server status
Error: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (state=08S01,code=0)
Closing: 0: xxx/
HS2 may be unavailable, check server status
Error: Error while cleaning up the server resources (state=,code=0)
Intercepting System.exit(2)
Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.Hive2Main], exit code [2]

 

I have series of hive actions in a oozie workflow and I am getting the same error everyday in or the other hive actions. I have attached the logs of the job which failed. Please help me resolve it.

 

Running it on CDH 5.9.1 . Have set following global parameters in workflow.xml as well :

 

hive_server2_session_check_interval=3600000
hive_server2_idle_operation_timeout=86400000
hive_server2_idle_session_timeout=259200000

 

Who agreed with this topic