You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Asanka Sanjaya Herath <an...@gmail.com> on 2016/04/25 15:25:54 UTC
Failed to make the connection
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
Re: Failed to make the connection
Posted by Asanka Sanjaya Herath <an...@gmail.com>.
Hi,
I figured out the cause. I had another set of org.apache.hadoop classes in
my classpath. Once I removed those the error was gone.
On Mon, Apr 25, 2016 at 8:47 PM, Asanka Sanjaya Herath <an...@gmail.com>
wrote:
> Hi Steve,
>
> Thank you for the reply. I'm using cloudbreak and Ambari.
>
> On Mon, Apr 25, 2016 at 7:59 PM, Steve Terrell <st...@oculus360.us>
> wrote:
>
>> 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 <
>> angal.sh@gmail.com> 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
>>>
>>
>>
>
>
> --
> Thanks,
> Regards,
> ASH
>
--
Thanks,
Regards,
ASH
Re: Failed to make the connection
Posted by Asanka Sanjaya Herath <an...@gmail.com>.
Hi Steve,
Thank you for the reply. I'm using cloudbreak and Ambari.
On Mon, Apr 25, 2016 at 7:59 PM, Steve Terrell <st...@oculus360.us>
wrote:
> 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 <angal.sh@gmail.com
> > 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
>>
>
>
--
Thanks,
Regards,
ASH
Re: Failed to make the connection
Posted by Steve Terrell <st...@oculus360.us>.
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 <an...@gmail.com>
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
>