Hive Error - transport error 202: bind failed: Address already in use

[#1]

Dear Team,

Attached an error found after used hive -debug command

hive-error.png

Regards,

Nilesh

[#2]

@Nilesh Try this hive --hiveconf hive.root.logger=DEBUG,console

[#3]

@Neeraj Sabharwal

I tried this command hive --hiveconf hive.root.logger=DEBUG,console and getting below error on screen.

16/01/05 18:29:03 [IPC Client (79644918) connection to nn1.hortonwork.local/192.168.3.138:8050 from hive]: DEBUG ipc.Client: IPC Client (79644918) connection to nn1.hortonwork.local/192.168.3.138:8050 from hive got value #127 16/01/05 18:29:03 [main]: DEBUG ipc.ProtobufRpcEngine: Call: getApplicationReport took 7ms

PFA an error file.

hive-error1.png

[#4 · Accepted solution]

From the error you posted it seems that the default debug port is already taken. You can change the default port by following invocation

hive --debug:port=8101

[#5]

@Deepesh

I run hive --debug:port=8101 command in terminal but there is no activity on screen. Also hive command is unresponsive. stuck on below output.

[hive@nn1 ~]$ hive WARNING: Use "yarn jar" to launch YARN applications. 16/01/06 11:43:29 WARN conf.HiveConf: HiveConf of name hive.server2.enable.impersonation does not exist Logging initialized using configuration in file:/etc/hive/2.3.2.0-2950/0/hive-log4j.properties

[#6]

What is your goal? The above command is to start hive cli to enable Java debugging, the expectation is that you attach your debugger to the port and then step through the code. The reason its stuck is that its waiting for you to attach the debugger.

[#7]

Hive is not started via command and stuck on below output.

[hive@nn1 ~]$ hive WARNING: Use "yarn jar" to launch YARN applications. 16/01/06 17:37:07 WARN conf.HiveConf: HiveConf of name hive.server2.enable.impersonation does not exist Logging initialized using configuration in file:/etc/hive/2.3.2.0-2950/0/hive-log4j.properties

[#8]

Team, any updates

[#9]

If i understand you correctly, you are saying even invocation of "hive" without any arguments is stuck. That can likely happen if there is no capacity on YARN Resource Manager available. Can you check the RM UI?

[#10]

Yes, Hive is stuck without any arguments. How can check capacity on YARN Resource Manager from RM UI?