Reply
Explorer
Posts: 13
Registered: ‎09-12-2016

Hive error could not create serversocket on address 0.0.0.0/0.0.0.0:9083

Exception in thread "main" org.apache.thrift.transport.TTransportException: Could not create ServerSocket on address 0.0.0.0/0.0.0.0:9083.

 Have started Hive metastore already using

[cloudera@quickstart ~]$ sudo su
[root@quickstart cloudera]# service hive-metastore start
Starting Hive Metastore (hive-metastore): [ OK ]

 

After whihc the hive health goes red with above erorr  in stderr and below in dashboard

Bad : The Hive Metastore canary failed to create the hue hdfs home directory.

 

Any idea what I am missing?

New Contributor
Posts: 4
Registered: ‎07-31-2016

Re: Hive error could not create serversocket on address 0.0.0.0/0.0.0.0:9083

Could you paste the log messages here, looks like the port could already be in use.

 

netstat -tulpn | grep <for the port you are using for thrift, defaul: 10000>

Highlighted
Contributor
Posts: 37
Registered: ‎05-21-2018

Re: Hive error could not create serversocket on address 0.0.0.0/0.0.0.0:9083

I have 3 node cluster and install haproxy on node1.

 

the list of hive services running on my node 1 are : Metastore server, Webcat server, and HiveServer2.

 

one instance of hive server2 is running on node 2 and its working fine.

 

But node1 hive server2 is not running and showing this errot:

 

 

Error starting HiveServer2: could not start ThriftBinaryCLIService
org.apache.thrift.transport.TTransportException: Could not create ServerSocket on address 0.0.0.0/0.0.0.0:10000.
	at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:109)
	at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:91)
	at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:87)
	at org.apache.hadoop.hive.common.auth.HiveAuthUtils.getServerSocket(HiveAuthUtils.java:87)
	at org.apache.hive.service.cli.thrift.ThriftBinaryCLIService.run(ThriftBinaryCLIService.java:67)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Address already in use (Listen failed)
	at java.net.PlainSocketImpl.socketListen(Native Method)
	at java.net.AbstractPlainSocketImpl.listen(AbstractPlainSocketImpl.java:399)
	at java.net.ServerSocket.bind(ServerSocket.java:376)
	at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:106)

 

on cli its showing haproxy is using the port 10000

 

[root@cm1 singhkabir880]# netstat -tulpn | grep 10000tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN 882/haproxy [root@cm1 singhkabir880]#

 

i have add hive server2 role first then install haproxy service and made below changes in  :

/etc/haproxy/haproxy.cfg

:

 

listen hiveserver2 :10000 
#haproxy will listen in port 10000 for hiveserver2 client requests.

mode tcp 
option tcplog
balance leastconn 

#tcp – connection mode between haproxy to hive servers
#leastconn – requests will be sent to server with less connection

server server1 node1:10000
server server2 node2:10000

 

 

What should do i need to order to start newly added hive server2 ?

 

Kindly Suggest.

 

Announcements