You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by divye sheth <di...@gmail.com> on 2015/07/09 09:08:27 UTC

Unable to connect to Phoenix

Hi Team,

I am trying to connect to a remote phoenix cluster and I keep on getting
these in my logs and the connection does not take place.

*2015-07-09 12:33:35.227  INFO 15635 --- [           main]
o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=20,
retries=35, retryTime=1932211ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
hostname=b33d4527a069,60020,1436423451942, seqNum=0*
*2015-07-09 12:33:55.371  INFO 15635 --- [           main]
o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=21,
retries=35, retryTime=1952355ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
hostname=b33d4527a069,60020,1436423451942, seqNum=0*
*2015-07-09 12:34:15.465  INFO 15635 --- [           main]
o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=22,
retries=35, retryTime=1972449ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
hostname=b33d4527a069,60020,1436423451942, seqNum=0*
*2015-07-09 12:34:35.562  INFO 15635 --- [           main]
o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=23,
retries=35, retryTime=1992546ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
hostname=b33d4527a069,60020,1436423451942, seqNum=0*

I am using the following versions:
Hadoop-2.6.0
Hbase.0.98.13
Phoenix-4.4.0

This installation is inside a docker. I am able to connect to zookeeper but
cant get a connection.
Please advice.

Thanks!

Re: Unable to connect to Phoenix

Posted by divye sheth <di...@gmail.com>.
Got it working. I had to open the regionserver port 60020. Once I did that
it got working.

Thanks!

On Thu, Jul 9, 2015 at 1:13 PM, divye sheth <di...@gmail.com> wrote:

> Even I feel the same. So this is how my cluster looks like.
> I have a psuedo-distributed cluster setup on a Docker Container (sort of a
> virtual instance). I am able to access phoenix and create tables when
> inside of the Docker environment.
>
> Now when accessing the Cluster from the Host machine where the docker is
> installed, I get these exceptions. When running the docker I have to
> mention beforehand which ports I want open i.e. which ports will be
> accessible from host machine and which port do they map to. Is it that
> Phoenix uses arbitrary ports in order to serve the client? Will have to
> read about the internals of how zookeeper/phoenix/hbase connections work. I
> am sure that this has to do with some ports being not mapped while starting
> Docker.
>
> If at all you have links to how phoenix connects with client, please do
> let me know.
>
> Thanks!
>
> On Thu, Jul 9, 2015 at 12:54 PM, Fulin Sun <su...@certusnet.com.cn> wrote:
>
>> Hi there,
>>
>> I suspect the Call exception is not the root cause for unreachable for
>> your phoenix cluster. From the log info,
>>
>> seems that there are some rpc timeout issues, which may due to some
>> network or hosts exception. Did you try
>>
>> sqlline to connect to phoenix directely?
>>
>> Best,
>> Sun.
>>
>> ------------------------------
>> ------------------------------
>>
>> CertusNet
>>
>>
>> *From:* divye sheth <di...@gmail.com>
>> *Date:* 2015-07-09 15:38
>> *To:* user <us...@phoenix.apache.org>
>> *Subject:* Unable to connect to Phoenix
>> Hi Team,
>>
>> I am trying to connect to a remote phoenix cluster and I keep on getting
>> these in my logs and the connection does not take place.
>>
>> *2015-07-09 12:33:35.227  INFO 15635 --- [           main]
>> o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=20,
>> retries=35, retryTime=1932211ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
>> on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
>> hostname=b33d4527a069,60020,1436423451942, seqNum=0*
>> *2015-07-09 12:33:55.371  INFO 15635 --- [           main]
>> o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=21,
>> retries=35, retryTime=1952355ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
>> on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
>> hostname=b33d4527a069,60020,1436423451942, seqNum=0*
>> *2015-07-09 12:34:15.465  INFO 15635 --- [           main]
>> o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=22,
>> retries=35, retryTime=1972449ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
>> on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
>> hostname=b33d4527a069,60020,1436423451942, seqNum=0*
>> *2015-07-09 12:34:35.562  INFO 15635 --- [           main]
>> o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=23,
>> retries=35, retryTime=1992546ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
>> on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
>> hostname=b33d4527a069,60020,1436423451942, seqNum=0*
>>
>> I am using the following versions:
>> Hadoop-2.6.0
>> Hbase.0.98.13
>> Phoenix-4.4.0
>>
>> This installation is inside a docker. I am able to connect to zookeeper
>> but cant get a connection.
>> Please advice.
>>
>> Thanks!
>>
>>
>

Re: Unable to connect to Phoenix

Posted by divye sheth <di...@gmail.com>.
Even I feel the same. So this is how my cluster looks like.
I have a psuedo-distributed cluster setup on a Docker Container (sort of a
virtual instance). I am able to access phoenix and create tables when
inside of the Docker environment.

Now when accessing the Cluster from the Host machine where the docker is
installed, I get these exceptions. When running the docker I have to
mention beforehand which ports I want open i.e. which ports will be
accessible from host machine and which port do they map to. Is it that
Phoenix uses arbitrary ports in order to serve the client? Will have to
read about the internals of how zookeeper/phoenix/hbase connections work. I
am sure that this has to do with some ports being not mapped while starting
Docker.

If at all you have links to how phoenix connects with client, please do let
me know.

Thanks!

On Thu, Jul 9, 2015 at 12:54 PM, Fulin Sun <su...@certusnet.com.cn> wrote:

> Hi there,
>
> I suspect the Call exception is not the root cause for unreachable for
> your phoenix cluster. From the log info,
>
> seems that there are some rpc timeout issues, which may due to some
> network or hosts exception. Did you try
>
> sqlline to connect to phoenix directely?
>
> Best,
> Sun.
>
> ------------------------------
> ------------------------------
>
> CertusNet
>
>
> *From:* divye sheth <di...@gmail.com>
> *Date:* 2015-07-09 15:38
> *To:* user <us...@phoenix.apache.org>
> *Subject:* Unable to connect to Phoenix
> Hi Team,
>
> I am trying to connect to a remote phoenix cluster and I keep on getting
> these in my logs and the connection does not take place.
>
> *2015-07-09 12:33:35.227  INFO 15635 --- [           main]
> o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=20,
> retries=35, retryTime=1932211ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
> on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
> hostname=b33d4527a069,60020,1436423451942, seqNum=0*
> *2015-07-09 12:33:55.371  INFO 15635 --- [           main]
> o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=21,
> retries=35, retryTime=1952355ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
> on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
> hostname=b33d4527a069,60020,1436423451942, seqNum=0*
> *2015-07-09 12:34:15.465  INFO 15635 --- [           main]
> o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=22,
> retries=35, retryTime=1972449ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
> on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
> hostname=b33d4527a069,60020,1436423451942, seqNum=0*
> *2015-07-09 12:34:35.562  INFO 15635 --- [           main]
> o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=23,
> retries=35, retryTime=1992546ms, msg=row 'SYSTEM.CATALOG,,99999999999999'
> on table 'hbase:meta' at region=hbase:meta,,1.1588230740,
> hostname=b33d4527a069,60020,1436423451942, seqNum=0*
>
> I am using the following versions:
> Hadoop-2.6.0
> Hbase.0.98.13
> Phoenix-4.4.0
>
> This installation is inside a docker. I am able to connect to zookeeper
> but cant get a connection.
> Please advice.
>
> Thanks!
>
>

Re: Unable to connect to Phoenix

Posted by Fulin Sun <su...@certusnet.com.cn>.
Hi there,

I suspect the Call exception is not the root cause for unreachable for your phoenix cluster. From the log info, 

seems that there are some rpc timeout issues, which may due to some network or hosts exception. Did you try 

sqlline to connect to phoenix directely? 

Best,
Sun.





CertusNet 

From: divye sheth
Date: 2015-07-09 15:38
To: user
Subject: Unable to connect to Phoenix
Hi Team,

I am trying to connect to a remote phoenix cluster and I keep on getting these in my logs and the connection does not take place.

2015-07-09 12:33:35.227  INFO 15635 --- [           main] o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=20, retries=35, retryTime=1932211ms, msg=row 'SYSTEM.CATALOG,,99999999999999' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=b33d4527a069,60020,1436423451942, seqNum=0
2015-07-09 12:33:55.371  INFO 15635 --- [           main] o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=21, retries=35, retryTime=1952355ms, msg=row 'SYSTEM.CATALOG,,99999999999999' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=b33d4527a069,60020,1436423451942, seqNum=0
2015-07-09 12:34:15.465  INFO 15635 --- [           main] o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=22, retries=35, retryTime=1972449ms, msg=row 'SYSTEM.CATALOG,,99999999999999' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=b33d4527a069,60020,1436423451942, seqNum=0
2015-07-09 12:34:35.562  INFO 15635 --- [           main] o.a.h.hbase.client.RpcRetryingCaller     : Call exception, tries=23, retries=35, retryTime=1992546ms, msg=row 'SYSTEM.CATALOG,,99999999999999' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=b33d4527a069,60020,1436423451942, seqNum=0

I am using the following versions:
Hadoop-2.6.0
Hbase.0.98.13
Phoenix-4.4.0

This installation is inside a docker. I am able to connect to zookeeper but cant get a connection.
Please advice.

Thanks!