HiveServer2 not starting up

karan_alang1 — Thu, 13 Apr 2017 01:48:30 GMT

Hi All - I've an 8 Node HDP 2.5.3 cluster, and Hive is installed on Node-6. From Ambari - Hiveserver 2 is not startup, it gives the following error (as shown on the Ambari UI)

---------------------------------------------------------------------------------------

Connection failed on host <Node7>:10000

(Traceback (most recent call last): File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/alerts/alert_hive_thrift_port.py", line 200, in execute check_command_timeout=int(check_command_timeout)) File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/hive_check.py", line 74, in check_thrift_port_sasl timeout=check_command_timeout) File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 155, in __init__ self.env.run() File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 160, in run self.run_action(resource, action) File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 124, in run_action provider_action() File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 273, in action_run tries=self.resource.tries, try_sleep=self.resource.try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 70, in inner result = function(command, **kwargs) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 92, in checked_call tries=tries, try_sleep=try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 140, in _call_wrapper result = _call(command, **kwargs_copy) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 293, in _call raise ExecutionFailed(err_msg, code, out, err)

ExecutionFailed: Execution of '! beeline -u 'jdbc:hive2://<Node7>:10000/;transportMode=binary' -e '' 2>&1| awk '{print}'|grep -i -e 'Connection refused' -e 'Invalid URL'' returned 1. Error: Could not open client transport with JDBC Uri: jdbc:hive2://nwk2-bdp-hadoop-07.gdcs-qa.apple.com:10000/;transportMode=binary: java.net.ConnectException:

Connection refused (Connection refused) (state=08S01,code=0) Error: Could not open client transport with JDBC Uri: jdbc:hive2://<Node-7>:10000/;transportMode=binary: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0) )

---------------------------------------------------------------------------------------------

Pls note -> In the above error, it is trying to connect to Node-7, instead of Node-6

When i start HiveServer2 on commandline from Node-6, i'm able to start it & connect to Hive using Beeline.

Any ideas where the issue is ?

Attaching the HiveServer.log & the hive-site.xml as well.

Re: HiveServer2 not starting up

karan_alang1 — Thu, 13 Apr 2017 02:15:59 GMT

@Pardeep, @Kuldeep Kulkarni, @Jitendra Yadav - looping you in, any ideas on this ?

Re: HiveServer2 not starting up

karan_alang1 — Thu, 13 Apr 2017 04:24:00 GMT

@Artem Ervits, @vpoornalingam, @Mark Herring - looping you in, any ideas on this ?

Re: HiveServer2 not starting up

karan_alang1 — Sat, 15 Apr 2017 02:30:25 GMT

@mqureshi - looping you in, pls. let me know if you have any ideas on this... thnx

Re: HiveServer2 not starting up

mqureshi — Sat, 15 Apr 2017 02:52:03 GMT

@Karan Alang

you are getting invalid url. Shouldn't the url start with '!connect jdbc:hive2://<host>:<port>/<db>'

Re: HiveServer2 not starting up

karan_alang1 — Wed, 19 Apr 2017 11:25:23 GMT

@mqureshi - the issue was that /tmp/hive had incorrect permissions, similar issue was recorded in

hiveserver2-not-starting-using-ambari

question Re: HiveServer2 not starting up in Archives of Support Questions (Read Only)

HiveServer2 not starting up

Re: HiveServer2 not starting up

Re: HiveServer2 not starting up

Re: HiveServer2 not starting up

Re: HiveServer2 not starting up

Re: HiveServer2 not starting up