phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <anilgupt...@gmail.com>
Subject Re: Phoenix connection never returns
Date Thu, 26 Jun 2014 06:23:20 GMT
Hi Russell,

Just a naive question, Are you able to connect to HBase via HBase shell or
any other HBase client from that node? I have seen this kind of behavior
when the client does not have the HBase cluster conf in its classpath.

Thanks,
Anil Gupta


On Wed, Jun 25, 2014 at 10:51 PM, Russell Jurney <russell.jurney@gmail.com>
wrote:

> HBase is alive, and I can connect via sqlline from the same host.
> /etc/hosts has entries for each host of the quorum.
>
> Logs... no logs generated by this code:
>
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.Statement;
> import com.salesforce.phoenix.jdbc.PhoenixDriver
>
> #Class.forName("com.salesforce.phoenix.jdbc.PhoenixDriver")
>
> Java::com.salesforce.phoenix.jdbc.PhoenixDriver
> DriverManager.registerDriver("com.salesforce.phoenix.jdbc.PhoenixDriver")
> conn = DriverManager.get_connection("jdbc:phoenix:hiveapp1,hiveapp2:2181")
>
> <hang forever>
>
>
> :(
> ᐧ
>
>
> On Wed, Jun 25, 2014 at 9:09 PM, Alex Kamil <alex.kamil@gmail.com> wrote:
>
>> well, I'd chk a few things:
>> - enable logger on the client to see if there are any exceptions  -
>> Logger.getRootLogger().setLevel(Level.DEBUG);
>> - chk if hbase is alive, if there are any errors in the hbase logs, if
>> you can access hbase master url, or hbase shell without issues,
>> - see if you can connect with sqlline locally,
>> - if you are connecting from this client machine for the first time, make
>> sure /etc/hosts has the ip address of zookeeper quorum used by hbase
>>
>>
>>
>>
>>
>> On Wed, Jun 25, 2014 at 11:54 PM, Russell Jurney <
>> russell.jurney@gmail.com> wrote:
>>
>>> We're running Phoenix 2.2.2.
>>> ᐧ
>>>
>>>
>>> On Wed, Jun 25, 2014 at 8:31 PM, Alex Kamil <alex.kamil@gmail.com>
>>> wrote:
>>>
>>>> Russell, which version of Phoenix are you using on the server vs
>>>> client?
>>>> the most recent phoenix driver is
>>>> *org.apache.phoenix.jdbc.PhoenixDriver *
>>>>
>>>> I see older salesforce driver in your log, could be mismatch between
>>>> client and server phoenix versions
>>>> DriverManager.registerDriver("*com.salesforce*
>>>> .phoenix.jdbc.PhoenixDriver")
>>>>
>>>>
>>>> On Wed, Jun 25, 2014 at 11:23 PM, Russell Jurney <
>>>> russell.jurney@gmail.com> wrote:
>>>>
>>>>> https://gist.github.com/rjurney/c30123ddb1dec87afd8e
>>>>>
>>>>> I can't get a connection via JDBC to Phoenix. It simply sits there
>>>>> forever...
>>>>>
>>>>> --
>>>>> Russell Jurney twitter.com/rjurney russell.jurney@gmail.com
>>>>> datasyndrome.com
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Russell Jurney twitter.com/rjurney russell.jurney@gmail.com datasyndrome
>>> .com
>>>
>>
>>
>
>
> --
> Russell Jurney twitter.com/rjurney russell.jurney@gmail.com datasyndrome.
> com
>



-- 
Thanks & Regards,
Anil Gupta

Mime
View raw message