phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Russell Jurney <russell.jur...@gmail.com>
Subject Re: Phoenix connection never returns
Date Thu, 26 Jun 2014 06:26:30 GMT
I can connect to Phoenix from that machine using SqlLine, and also to HBase
via 'hbase shell'.
ᐧ


On Wed, Jun 25, 2014 at 11:23 PM, anil gupta <anilgupta84@gmail.com> wrote:

> 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
>



-- 
Russell Jurney twitter.com/rjurney russell.jurney@gmail.com datasyndrome.com

Mime
View raw message