phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Phoenix 4.6.0: sqlline.py Hangs From Remote Host
Date Sat, 31 Oct 2015 21:02:14 GMT
If you're trying to run locally on a Mac, see this thread:
http://search-hadoop.com/m/9UY0h2s6mxw4Opgf2/%252Fetc%252Fhosts&subj=Re+testing+problem

On Saturday, October 31, 2015, Naor David <tron47@gmail.com> wrote:

> run netstat -a 1 | grep "SYN_SENT" and check if port 2181 is blocked in
> your network..
>
> On Sat, Oct 31, 2015 at 8:00 PM, Steve Terrell <sterrell@oculus360.us
> <javascript:_e(%7B%7D,'cvml','sterrell@oculus360.us');>> wrote:
>
>> OK, did some more troubleshooting.  Still can't run sqlline.py from my
>> macbook laptop.  Still hangs.
>>
>> My HBase cluster is an Amazon EMR, and I can run sqlline.py from any of
>> nodes in the cluster, be they master, core, or task nodes.
>>
>> So maybe it's not so much a remote host issue but a problem with my Mac
>> or some kind of Amazon EMR security issue.  But, I've tried opening up all
>> ports just in case something other than 2181 is required, and no luck.
>>
>> Has anyone run this version of Phoenix on EMR and been able to use
>> sqlline.py or SQuirreL client remotely from outside of AWS's private
>> network?
>>
>> (My ultimate goal was to get SQuirreL working, but though sqlline.py
>> would be an easier problem to tackle.  SQuirreL is getting timeouts which I
>> suspect are due to the same hanging that I see with sqlline.py.)
>>
>> Thanks,
>>     Steve
>>
>> On Wed, Oct 28, 2015 at 5:04 PM, Steve Terrell <sterrell@oculus360.us
>> <javascript:_e(%7B%7D,'cvml','sterrell@oculus360.us');>> wrote:
>>
>>> Yes, I can:
>>>
>>> $ telnet *<my master ip>* 2181
>>> Trying 54.174.32.95...
>>> Connected to *<my master host name>*.
>>> Escape character is '^]'.
>>>
>>> Thanks,
>>>     Steve
>>>
>>> On Wed, Oct 28, 2015 at 4:48 PM, Alok Singh <alok@cloudability.com
>>> <javascript:_e(%7B%7D,'cvml','alok@cloudability.com');>> wrote:
>>>
>>>> It looks like a zookeeper node is also on the master. Can you connect
>>>> to <master ip> on port 2181 from the machine that you are running
>>>> sqlline.py on?
>>>>
>>>> Alok
>>>>
>>>> Alok
>>>>
>>>> alok@cloudability.com
>>>> <javascript:_e(%7B%7D,'cvml','alok@cloudability.com');>
>>>>
>>>> On Wed, Oct 28, 2015 at 2:23 PM, Steve Terrell <sterrell@oculus360.us
>>>> <javascript:_e(%7B%7D,'cvml','sterrell@oculus360.us');>> wrote:
>>>>
>>>>> I can get "sqlline.py localhost" to work fine from the master node.
>>>>>
>>>>> However, when I try to run it remotely, all I get is this:
>>>>>
>>>>> java -cp "*<my path>*/phoenix-4.6.0-HBase-0.98-client.jar"
>>>>> -Dlog4j.configuration=file:*<my path>*/log4j.properties
>>>>> sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver -u jdbc:phoenix:*<my
>>>>> master ip*>:2181:/hbase -n none -p none --color=true
>>>>> --fastConnect=false --verbose=true --isolation=TRANSACTION_READ_COMMITTED
>>>>>
>>>>> Setting property: [isolation, TRANSACTION_READ_COMMITTED]
>>>>> issuing: !connect jdbc:phoenix:*<my master ip*>:2181:/hbase none
none
>>>>> org.apache.phoenix.jdbc.PhoenixDriver
>>>>> Connecting to jdbc:phoenix:*<my master ip*>:2181:/hbase
>>>>> 15/10/28 15:29:44 WARN util.NativeCodeLoader: Unable to load
>>>>> native-hadoop library for your platform... using builtin-java classes
where
>>>>> applicable
>>>>>
>>>>> And then it just hangs.  Has anyone else come across this?
>>>>>
>>>>> Thanks,
>>>>>     Steve
>>>>>
>>>>
>>>>
>>>
>>
>

Mime
View raw message