0
votes

While running the command vc.sql(testsql), getting following error

com.sap.spark.vora.VoraConfigurationException: No ZooKeeper hosts found

Zookeeper services up and running on all three nodes.

Error log shows the following:

2016-09-14 15:14:32,418 - INFO [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxnFactory@197] - Accepted socket connection from /10.78.1.240:46458 2016-09-14 15:14:32,418 - WARN [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxn@357] - caught end of stream exception EndOfStreamException: Unable to read additional data from client sessionid 0x0, likely client has closed socket at org.apache.zookeeper.server.NIOServerCnxn.doIO(NIOServerCnxn.java:228) at org.apache.zookeeper.server.NIOServerCnxnFactory.run(NIOServerCnxnFactory.java:208) at java.lang.Thread.run(Thread.java:745) 2016-09-14 15:14:32,418 - INFO [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxn@1007] - Closed socket connection for client /10.78.1.240:46458 (no session established for client) 2016-09-14 15:15:32,429 - INFO [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxnFactory@197] - Accepted socket connection from /10.78.1.240:46832 2016-09-14 15:15:32,429 - WARN [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxn@357] - caught end of stream exception EndOfStreamException: Unable to read additional data from client sessionid 0x0, likely client has closed socket at org.apache.zookeeper.server.NIOServerCnxn.doIO(NIOServerCnxn.java:228) at org.apache.zookeeper.server.NIOServerCnxnFactory.run(NIOServerCnxnFactory.java:208) at java.lang.Thread.run(Thread.java:745) 2016-09-14 15:15:32,429 - INFO [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxn@1007] - Closed socket connection for client /10.78.1.240:46832 (no session established for client)

2

2 Answers

0
votes

Just try go to Ambari and restart all services.

0
votes
  1. Check if Zookeeper server(s) is/are running

In your cluster manager (e.g. Ambari) check if the Zookeeper server(s) is/are running. Also check the status of Zookeeper on command line as discussed at How to check if ZooKeeper is running or up from command prompt?

For example:

$ <path>/zkServer.sh status
$ echo stat | nc <zookeeper ip> 2181

If Zookeeper is not running properly, the issue is with Zookeeper and not with Vora. In that case check the Zookeeper logs (usually /var/log/zookeeper).

  1. Check if Zookeeper is known to Vora

If Zookeeper is running, check in the UI of Vora Discovery Service (http://:8500/ui) if an entry 'zookeeper' is listed. If no entry is listed on the UI, check the log files at /var/log/vora-discovery.