I'm using simple phoenix hello world program in a amazon cluster. When I run *./sqlline.py <zookeeper>* it connects properly. But when I use the java program it gives me following error. I took the *phoenix-4.4.0.2.3.4.0-3485-client.jar* from phoenix installation directory and copied it to the class path. Same zookeeper host name is used in both cases.
16/04/25 12:58:56 INFO zookeeper.RecoverableZooKeeper: Process identifier=hconnection-0x7e31ce0f connecting to ZooKeeper ensemble=ip-10-0-134-242:2181 12:58:56.084 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:zookeeper.version=3.4.6-1569965, built on 02/20/2014 09:09 GMT 12:58:56.084 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:host.name=ip-10-0-125-44.ec2.internal 12:58:56.085 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.version=1.8.0_72 12:58:56.085 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.vendor=Oracle Corporation 12:58:56.086 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.home=/usr/lib/jvm/java-8-oracle/jre 12:58:56.086 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.class.path=/home/ubuntu/batch-jobs/job-xx/target/job-xx-1.0-SNAPSHOT.jar:/home/ubuntu/phoenix-4.4.0.2.3.4.0-3485-client.jar:. 12:58:56.087 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib 12:58:56.088 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.io.tmpdir=/tmp 12:58:56.089 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:java.compiler=<NA> 12:58:56.090 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:os.name=Linux 12:58:56.091 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:os.arch=amd64 12:58:56.091 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:os.version=3.13.0-74-generic 12:58:56.093 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:user.name=ubuntu 12:58:56.093 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:user.home=/home/ubuntu 12:58:56.094 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client environment:user.dir=/home/ubuntu/batch-jobs 12:58:56.096 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=ip-10-0-134-242:2181 sessionTimeout=90000 watcher=hconnection-0x7e31ce0f0x0, quorum=ip-10-0-134-242:2181, baseZNode=/hbase 12:58:56.106 [logback-1] DEBUG org.apache.zookeeper.ClientCnxn - zookeeper.disableAutoWatchReset is false 12:58:56.140 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] INFO org.apache.zookeeper.ClientCnxn - Opening socket connection to server ip-10-0-134-242.ec2.internal/10.0.134.242:2181. Will not attempt to authenticate using SASL (unknown error) 12:58:56.162 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] INFO org.apache.zookeeper.ClientCnxn - Socket connection established to ip-10-0-134-242.ec2.internal/10.0.134.242:2181, initiating session 12:58:56.165 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] DEBUG org.apache.zookeeper.ClientCnxn - Session establishment request sent on ip-10-0-134-242.ec2.internal/10.0.134.242:2181 12:58:56.178 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] INFO org.apache.zookeeper.ClientCnxn - Session establishment complete on server ip-10-0-134-242.ec2.internal/10.0.134.242:2181, sessionid = 0x153df7a2df00c31, negotiated timeout = 40000 12:58:56.190 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] DEBUG org.apache.zookeeper.ClientCnxn - Reading reply sessionid:0x153df7a2df00c31, packet:: clientPath:null serverPath:null finished:false header:: 1,3 replyHeader:: 1,17180112691,-101 request:: '/hbase/hbaseid,F response:: 16/04/25 12:58:56 INFO client.ZooKeeperRegistry: ClusterId read in ZooKeeper is null 16/04/25 12:58:56 INFO client.ConnectionManager$HConnectionImplementation: Closing zookeeper sessionid=0x153df7a2df00c31 12:58:56.250 [main] DEBUG org.apache.zookeeper.ZooKeeper - Closing session: 0x153df7a2df00c31 12:58:56.251 [main] DEBUG org.apache.zookeeper.ClientCnxn - Closing client for session: 0x153df7a2df00c31 12:58:56.255 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] DEBUG org.apache.zookeeper.ClientCnxn - Reading reply sessionid:0x153df7a2df00c31, packet:: clientPath:null serverPath:null finished:false header:: 2,-11 replyHeader:: 2,17180112692,0 request:: null response:: null 12:58:56.255 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] DEBUG org.apache.zookeeper.ClientCnxn - An exception was thrown while closing send thread for session 0x153df7a2df00c31 : Unable to read additional data from server sessionid 0x153df7a2df00c31, likely server has closed socket 12:58:56.255 [main] DEBUG org.apache.zookeeper.ClientCnxn - Disconnecting client for session: 0x153df7a2df00c31 12:58:56.256 [main-EventThread] INFO org.apache.zookeeper.ClientCnxn - EventThread shut down 12:58:56.256 [main] INFO org.apache.zookeeper.ZooKeeper - Session: 0x153df7a2df00c31 closed Exception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.metrics2.lib.DefaultMetricsSystem.instance()Lorg/apache/hadoop/metrics2/MetricsSystem; at org.apache.phoenix.metrics.Metrics.<clinit>(Metrics.java:29) at org.apache.phoenix.trace.TraceMetricSource.<init>(TraceMetricSource.java:86) at org.apache.phoenix.trace.util.Tracing.addTraceMetricsSource(Tracing.java:269) at org.apache.phoenix.jdbc.PhoenixConnection.<clinit>(PhoenixConnection.java:146) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1848) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1820) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77) at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1820) at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:180) at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:132) at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:151) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at com.xxx.xxx.core.connector.PhoenixConnector.<init>(PhoenixConnector.java:22) at com.xxx.xxx.core.connector.storage.HadoopImmutableStore.<init>(HadoopImmutableStore.java:48) at com.xxx.xx.job.xx.xx.main(xxxx.java:68) -- Thanks, Regards, ASH
