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 - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http://www.thelastpickle.com 2016-03-30 6:09 GMT+02:00 joseph gao <gaojf.bok...@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.bok...@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 <arodr...@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 - al...@thelastpickle.com >>> France >>> >>> The Last Pickle - Apache Cassandra Consulting >>> http://www.thelastpickle.com >>> >>> 2016-03-21 9:59 GMT+01:00 joseph gao <gaojf.bok...@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 <arodr...@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 - al...@thelastpickle.com >>>>> France >>>>> >>>>> The Last Pickle - Apache Cassandra Consulting >>>>> http://www.thelastpickle.com >>>>> >>>>> 2016-03-18 4:49 GMT+01:00 joseph gao <gaojf.bok...@gmail.com>: >>>>> >>>>>> Of course yes. >>>>>> >>>>>> 2016-03-17 22:35 GMT+08:00 Vishwas Gupta <vishwas.gu...@snapdeal.com> >>>>>> : >>>>>> >>>>>>> Have you started the Cassandra service? >>>>>>> >>>>>>> sh cassandra >>>>>>> On 17-Mar-2016 7:59 pm, "Alain RODRIGUEZ" <arodr...@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 - al...@thelastpickle.com >>>>>>>> France >>>>>>>> >>>>>>>> The Last Pickle - Apache Cassandra Consulting >>>>>>>> http://www.thelastpickle.com >>>>>>>> >>>>>>>> 2016-03-17 14:26 GMT+01:00 joseph gao <gaojf.bok...@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 >
