cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From George Sigletos <sigle...@textkernel.nl>
Subject Re: cqlsh problem
Date Tue, 20 Sep 2016 09:22:10 GMT
This appears in the system log:

Caused by: java.lang.RuntimeException:
org.apache.cassandra.exceptions.ReadTimeoutException: Operation timed out -
received only 2 responses.
    at org.apache.cassandra.auth.Auth.selectUser(Auth.java:276)
~[apache-cassandra-2.1.14.jar:2.1.14]
    at org.apache.cassandra.auth.Auth.isSuperuser(Auth.java:97)
~[apache-cassandra-2.1.14.jar:2.1.14]
    at
org.apache.cassandra.auth.AuthenticatedUser.isSuper(AuthenticatedUser.java:50)
~[apache-cassandra-2.1.14.jar:2.1.14]
    at
org.apache.cassandra.auth.CassandraAuthorizer.authorize(CassandraAuthorizer.java:67)
~[apache-cassandra-2.1.14.jar:2.1.14]
    at
org.apache.cassandra.auth.PermissionsCache$1.load(PermissionsCache.java:124)
~[apache-cassandra-2.1.14.jar:2.1.14]
    at
org.apache.cassandra.auth.PermissionsCache$1.load(PermissionsCache.java:121)
~[apache-cassandra-2.1.14.jar:2.1.14]
    at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3524)
~[guava-16.0.jar:na]
    at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2317)
~[guava-16.0.jar:na]
    at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2280)
~[guava-16.0.jar:na]
    at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2195)
~[guava-16.0.jar:na]


On Tue, Sep 20, 2016 at 11:12 AM, George Sigletos <sigletos@textkernel.nl>
wrote:

> I am also getting the same error:
> cqlsh <my host> -u cassandra -p cassandra
>
> Connection error: ('Unable to connect to any servers', {'<my host>':
> OperationTimedOut('errors=Timed out creating connection (5 seconds),
> last_host=None',)})
>
> But it is not consistent. Sometimes I manage to connect. It is random.
> Using 2.1.14
>
> On Tue, Jun 14, 2016 at 4:29 AM, joseph gao <gaojf.bokecc@gmail.com>
> wrote:
>
>> hi, Patric, [image: 内嵌图片 1],
>> netstat -lepunt looks like above
>>
>> 2016-05-27 23:16 GMT+08:00 Patrick McFadin <pmcfadin@gmail.com>:
>>
>>> Can you do a netstat -lepunt and show the output? If Cassandra is
>>> running you aren't trying to connect to the ip/port it's bound to.
>>>
>>> Patrick
>>>
>>>
>>> On Monday, May 23, 2016, joseph gao <gaojf.bokecc@gmail.com> wrote:
>>>
>>>> I used to think it's firewall/network issues too. So I make ufw to be
>>>> inactive. I really don't what's the reason.
>>>>
>>>> 2016-05-09 19:01 GMT+08:00 kurt Greaves <kurt@instaclustr.com>:
>>>>
>>>>> Don't be fooled, despite saying tcp6 and :::*, it still listens on
>>>>> IPv4. As far as I'm aware this happens on all 2.1 Cassandra nodes, and
may
>>>>> just be an oddity of netstat. It would be unrelated to your connection
>>>>> timeout issues, that's most likely related to firewall/network issues.
>>>>>
>>>>> On 9 May 2016 at 09:59, joseph gao <gaojf.bokecc@gmail.com> wrote:
>>>>>
>>>>>> 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
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Kurt Greaves
>>>>> kurt@instaclustr.com
>>>>> www.instaclustr.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> ------
>>>> Joseph Gao
>>>> PhoneNum:15210513582
>>>> QQ: 409343351
>>>>
>>>
>>
>>
>> --
>> ------
>> Joseph Gao
>> PhoneNum:15210513582
>> QQ: 409343351
>>
>
>

Mime
View raw message