Are you using Amazon EMR as your cluster? Are you trying to connect to Phoenix on an EMR master or from outside the cluster?
On Mon, Apr 25, 2016 at 8:25 AM, Asanka Sanjaya Herath <[email protected]> wrote: > 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 >
