cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From joseph gao <gaojf.bok...@gmail.com>
Subject Re: cqlsh problem
Date Tue, 24 May 2016 06:48:43 GMT
I used to think it's firewall/network issues too. So I make ufw to be
inactive. I really don't what's the reason.

2016-05-09 19:01 GMT+08:00 kurt Greaves <kurt@instaclustr.com>:

> Don't be fooled, despite saying tcp6 and :::*, it still listens on IPv4.
> As far as I'm aware this happens on all 2.1 Cassandra nodes, and may just
> be an oddity of netstat. It would be unrelated to your connection timeout
> issues, that's most likely related to firewall/network issues.
>
> On 9 May 2016 at 09:59, joseph gao <gaojf.bokecc@gmail.com> wrote:
>
>> It doesn't work ,still using ipv6 [image: 内嵌图片 1]
>>
>> And I already set [image: 内嵌图片 2]
>>
>> Now I'm using 4.1.1 using 9160 port instead of 5.x.x。
>>
>> Hopefully this could be resolved, Thanks!
>>
>> 2016-03-30 22:13 GMT+08:00 Alain RODRIGUEZ <arodrime@gmail.com>:
>>
>>> Hi Joseph,
>>>
>>> why cassandra using tcp6 for 9042 port like :
>>>> tcp6       0      0 0.0.0.0:9042            :::*
>>>>  LISTEN
>>>>
>>>
>>> if I remember correctly, in 2.1 and higher, cqlsh uses native transport,
>>> port 9042  (instead of thrift port 9160) and your clients (if any) are also
>>> probably using native transport (port 9042). So yes, this could be an issue
>>> indeed.
>>>
>>> You should have something like:
>>>
>>> tcp        0      0  1.2.3.4:9042   :::*                        LISTEN
>>>
>>> You are using IPv6 and no rpc address. Try setting it to the listen
>>> address and using IPv4.
>>>
>>> C*heers,
>>>
>>> -----------------------
>>>
>>> Alain Rodriguez - alain@thelastpickle.com
>>>
>>> France
>>>
>>> The Last Pickle - Apache Cassandra Consulting
>>>
>>> http://www.thelastpickle.com
>>>
>>> 2016-03-30 6:09 GMT+02:00 joseph gao <gaojf.bokecc@gmail.com>:
>>>
>>>> why cassandra using tcp6 for 9042 port like :
>>>> tcp6       0      0 0.0.0.0:9042            :::*
>>>>  LISTEN
>>>> would this be the problem
>>>>
>>>> 2016-03-30 11:34 GMT+08:00 joseph gao <gaojf.bokecc@gmail.com>:
>>>>
>>>>> still have not fixed it . cqlsh: error: no such option:
>>>>> --connect-timeout
>>>>> cqlsh version 5.0.1
>>>>>
>>>>>
>>>>>
>>>>> 2016-03-25 16:46 GMT+08:00 Alain RODRIGUEZ <arodrime@gmail.com>:
>>>>>
>>>>>> Hi Joseph.
>>>>>>
>>>>>> As I can't reproduce here, I believe you are having network issue
of
>>>>>> some kind.
>>>>>>
>>>>>> MacBook-Pro:~ alain$ cqlsh --version
>>>>>> cqlsh 5.0.1
>>>>>> MacBook-Pro:~ alain$ echo 'DESCRIBE KEYSPACES;' | cqlsh
>>>>>> --connect-timeout=5 --request-timeout=10
>>>>>> system_traces  system
>>>>>> MacBook-Pro:~ alain$
>>>>>>
>>>>>> It's been a few days, did you manage to fix it ?
>>>>>>
>>>>>> C*heers,
>>>>>> -----------------------
>>>>>> Alain Rodriguez - alain@thelastpickle.com
>>>>>> France
>>>>>>
>>>>>> The Last Pickle - Apache Cassandra Consulting
>>>>>> http://www.thelastpickle.com
>>>>>>
>>>>>> 2016-03-21 9:59 GMT+01:00 joseph gao <gaojf.bokecc@gmail.com>:
>>>>>>
>>>>>>> cqlsh version 5.0.1. nodetool tpstats looks good, log looks good.
>>>>>>> And I used specified port 9042. And it immediately returns fail
(less than
>>>>>>> 3 seconds). By the way where should I use '--connect-timeout',
cqlsh seems
>>>>>>> don't have such parameters.
>>>>>>>
>>>>>>> 2016-03-18 17:29 GMT+08:00 Alain RODRIGUEZ <arodrime@gmail.com>:
>>>>>>>
>>>>>>>> Is the node fully healthy or rejecting some requests ?
>>>>>>>>
>>>>>>>> What are the outputs for "grep -i "ERROR"
>>>>>>>> /var/log/cassandra/system.log" and "nodetool tpstats"?
>>>>>>>>
>>>>>>>> Any error? Any pending / blocked or dropped messages?
>>>>>>>>
>>>>>>>> Also did you try using distinct ports (9160 for thrift, 9042
for
>>>>>>>> native) - out of curiosity, not sure this will help.
>>>>>>>>
>>>>>>>> What is your version of cqlsh "cqlsh --version" ?
>>>>>>>>
>>>>>>>> doesn't work most times. But some time it just work fine
>>>>>>>>>
>>>>>>>>
>>>>>>>> Do you fill like this is due to a timeout (query being too
big,
>>>>>>>> cluster being to busy)? Try setting this higher:
>>>>>>>>
>>>>>>>> --connect-timeout=CONNECT_TIMEOUT
>>>>>>>>
>>>>>>>>                         Specify the connection timeout in
seconds
>>>>>>>> (default: 5 seconds).
>>>>>>>>
>>>>>>>>   --request-timeout=REQUEST_TIMEOUT
>>>>>>>>
>>>>>>>>                         Specify the default request timeout
in
>>>>>>>> seconds (default: 10 seconds).
>>>>>>>>
>>>>>>>> C*heers,
>>>>>>>> -----------------------
>>>>>>>> Alain Rodriguez - alain@thelastpickle.com
>>>>>>>> France
>>>>>>>>
>>>>>>>> The Last Pickle - Apache Cassandra Consulting
>>>>>>>> http://www.thelastpickle.com
>>>>>>>>
>>>>>>>> 2016-03-18 4:49 GMT+01:00 joseph gao <gaojf.bokecc@gmail.com>:
>>>>>>>>
>>>>>>>>> Of course yes.
>>>>>>>>>
>>>>>>>>> 2016-03-17 22:35 GMT+08:00 Vishwas Gupta <
>>>>>>>>> vishwas.gupta@snapdeal.com>:
>>>>>>>>>
>>>>>>>>>> Have you started the Cassandra service?
>>>>>>>>>>
>>>>>>>>>> sh cassandra
>>>>>>>>>> On 17-Mar-2016 7:59 pm, "Alain RODRIGUEZ" <arodrime@gmail.com>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi, did you try with the address of the node
rather than
>>>>>>>>>>> 127.0.0.1
>>>>>>>>>>>
>>>>>>>>>>> Is the transport protocol used by cqlsh (not
sure if it is
>>>>>>>>>>> thrift or binary - native in 2.1)  active ? What
is the "nodetool info"
>>>>>>>>>>> output ?
>>>>>>>>>>>
>>>>>>>>>>> C*heers,
>>>>>>>>>>> -----------------------
>>>>>>>>>>> Alain Rodriguez - alain@thelastpickle.com
>>>>>>>>>>> France
>>>>>>>>>>>
>>>>>>>>>>> The Last Pickle - Apache Cassandra Consulting
>>>>>>>>>>> http://www.thelastpickle.com
>>>>>>>>>>>
>>>>>>>>>>> 2016-03-17 14:26 GMT+01:00 joseph gao <gaojf.bokecc@gmail.com>:
>>>>>>>>>>>
>>>>>>>>>>>> hi, all
>>>>>>>>>>>> cassandra version 2.1.7
>>>>>>>>>>>> When I use cqlsh to connect cassandra, something
is wrong
>>>>>>>>>>>>
>>>>>>>>>>>> Connection error: ( Unable to connect to
any servers',
>>>>>>>>>>>> {'127.0.0.1': OperationTimedOut('errors=None,
last_host=None,)})
>>>>>>>>>>>>
>>>>>>>>>>>> This happens lots of times, but sometime
it works just fine.
>>>>>>>>>>>> Anybody knows why?
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> ------
>>>>>>>>>>>> Joseph Gao
>>>>>>>>>>>> PhoneNum:15210513582
>>>>>>>>>>>> QQ: 409343351
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> ------
>>>>>>>>> Joseph Gao
>>>>>>>>> PhoneNum:15210513582
>>>>>>>>> QQ: 409343351
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> ------
>>>>>>> Joseph Gao
>>>>>>> PhoneNum:15210513582
>>>>>>> QQ: 409343351
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> ------
>>>>> Joseph Gao
>>>>> PhoneNum:15210513582
>>>>> QQ: 409343351
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> ------
>>>> Joseph Gao
>>>> PhoneNum:15210513582
>>>> QQ: 409343351
>>>>
>>>
>>>
>>
>>
>> --
>> ------
>> Joseph Gao
>> PhoneNum:15210513582
>> QQ: 409343351
>>
>
>
>
> --
> Kurt Greaves
> kurt@instaclustr.com
> www.instaclustr.com
>



-- 
------
Joseph Gao
PhoneNum:15210513582
QQ: 409343351

Mime
View raw message