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 >
