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:29:47 GMT
And the configuration files of your cluster are present in the classpath of
your java client?


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

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



-- 
Thanks & Regards,
Anil Gupta

Mime
View raw message