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 Mon, 09 May 2016 09:59:15 GMT
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

Mime
View raw message