cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alain RODRIGUEZ <arodr...@gmail.com>
Subject Re: cqlsh problem
Date Wed, 30 Mar 2016 14:13:11 GMT
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
>

Mime
View raw message