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