Cannot start Phoenix sqlline getting error calling coprocessor service

[#1]

[ec2-user@ip-10-16-129-152 bin]$ ./sqlline.py Setting property: [incremental, false] Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:localhost:2181:/hbase none none org.apache.phoenix.jdbc.PhoenixDriver Connecting to jdbc:phoenix:localhost:2181:/hbase SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/lib/phoenix/phoenix-4.13.0-HBase-1.4-client.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/lib/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 18/05/14 04:07:37 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 18/05/14 04:17:47 WARN ipc.CoprocessorRpcChannel: Call failed on IOException org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=35, exceptions: Mon May 14 04:07:47 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:07:47 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: org.apache.hadoop.hbase.ipc.FailedServerException: This server is in the failed servers list: /<IP ADDRESS>:16020 Mon May 14 04:07:47 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: org.apache.hadoop.hbase.ipc.FailedServerException: This server is in the failed servers list: /<IP ADDRESS>:16020 Mon May 14 04:07:47 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: org.apache.hadoop.hbase.ipc.FailedServerException: This server is in the failed servers list: /<IP ADDRESS>:16020 Mon May 14 04:07:48 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: org.apache.hadoop.hbase.ipc.FailedServerException: This server is in the failed servers list: /<IP ADDRESS>:16020 Mon May 14 04:07:50 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:07:55 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:08:02 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:08:15 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:08:28 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:08:41 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:08:54 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:09:18 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:09:41 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:10:04 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:10:27 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:10:50 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:11:13 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:11:37 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:12:00 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:12:23 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:12:46 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:13:09 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:13:32 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:13:56 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:14:19 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:14:42 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:15:05 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:15:28 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:15:51 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:16:15 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:16:38 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:17:01 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:17:24 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:17:47 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:164) at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:101) at org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:56) at org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService$Stub.getVersion(MetaDataProtos.java:16649) at org.apache.phoenix.query.ConnectionQueryServicesImpl$5.call(ConnectionQueryServicesImpl.java:1198) at org.apache.phoenix.query.ConnectionQueryServicesImpl$5.call(ConnectionQueryServicesImpl.java:1190) at org.apache.hadoop.hbase.client.HTable$15.call(HTable.java:1775) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host at org.apache.hadoop.hbase.ipc.IPCUtil.wrapException(IPCUtil.java:180) at org.apache.hadoop.hbase.ipc.AbstractRpcClient.onCallFinished(AbstractRpcClient.java:389) at org.apache.hadoop.hbase.ipc.AbstractRpcClient.access$100(AbstractRpcClient.java:94) at org.apache.hadoop.hbase.ipc.AbstractRpcClient$3.run(AbstractRpcClient.java:409) at org.apache.hadoop.hbase.ipc.AbstractRpcClient$3.run(AbstractRpcClient.java:405) at org.apache.hadoop.hbase.ipc.Call.callComplete(Call.java:103) at org.apache.hadoop.hbase.ipc.Call.setException(Call.java:118) at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callMethod(AbstractRpcClient.java:422) at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:327) at org.apache.hadoop.hbase.ipc.AbstractRpcClient.access$200(AbstractRpcClient.java:94) at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:571) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.execService(ClientProtos.java:37083) at org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1834) at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:97) at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:88) at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:142) ... 10 more Caused by: java.net.NoRouteToHostException: No route to host at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717) at org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:206) at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:531) at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:495) at org.apache.hadoop.hbase.ipc.BlockingRpcConnection.setupConnection(BlockingRpcConnection.java:256) at org.apache.hadoop.hbase.ipc.BlockingRpcConnection.setupIOstreams(BlockingRpcConnection.java:437) at org.apache.hadoop.hbase.ipc.BlockingRpcConnection.writeRequest(BlockingRpcConnection.java:540) at org.apache.hadoop.hbase.ipc.BlockingRpcConnection.tracedWriteRequest(BlockingRpcConnection.java:520) at org.apache.hadoop.hbase.ipc.BlockingRpcConnection.access$200(BlockingRpcConnection.java:85) at org.apache.hadoop.hbase.ipc.BlockingRpcConnection$4.run(BlockingRpcConnection.java:724) at org.apache.hadoop.hbase.ipc.HBaseRpcControllerImpl.notifyOnCancel(HBaseRpcControllerImpl.java:240) at org.apache.hadoop.hbase.ipc.BlockingRpcConnection.sendRequest(BlockingRpcConnection.java:699) at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callMethod(AbstractRpcClient.java:420) ... 18 more 18/05/14 04:17:47 WARN client.HTable: Error calling coprocessor service org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService for row java.util.concurrent.ExecutionException: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=35, exceptions: Mon May 14 04:07:47 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 14 04:07:47 UTC 2018, RpcRetryingCaller{globalStartTime=1526270864184, pause=100, retries=35}, java.io.IOException: Call to /<IP ADDRESS>:16020 failed on local exception: org.apache.hadoop.hbase.ipc.FailedServerException: This server is in the failed servers list: /<IP ADDRESS>:16020

[#2]

@rachana sri

Your log shows that it is trying to connect the localhost:2181 zookeeper.

issuing: !connect jdbc:phoenix:localhost:2181:/hbase none none org.apache.phoenix.jdbc.PhoenixDriver Connecting to jdbc:phoenix:localhost:2181:/hbase 

Are you sure that you have a Zookeeper pro cess running on "localhost:2181" address? Please check if port 2181 is opened and listening to correct address? Also please check the port 16020 as we see 16020 failed on local exception

# netstat -tnlpa | grep 2181
# netstat -tnlpa | grep 16020

Please try specifying the hostname. Like if you have the zookeeper running on a remote host (like test1.example.com) then please try specifying the Hostname.

#  ./sqlline.py  test1.example.com:2181/hbase

.

Also as we repeatedly see "No route to host" please let us know if you are using correct hostnames/FQDN "hostname -f" ?

java.io.IOException: Call to / :16020 failed on local exception: java.net.NoRouteToHostException: No route to host Mon May 

Are you using correct hostname for your services and Do you have the Firewall Turned Off and able to access the services using their Hostname & ports like using telnet?

# hostname -f

# telnet  $HOSTNAME  $PORT

.

.