cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Umang Shah <shahuma...@gmail.com>
Subject Re: ROperationTimedOut in selerct count statement in cqlsh
Date Wed, 22 Apr 2015 10:15:51 GMT
In that case you have to increase the readtimeout as some suggested.

On Wed, Apr 22, 2015 at 10:06 AM, Mich Talebzadeh <mich@peridale.co.uk>
wrote:

> Thanks Umang.
>
>
>
> I have 9GB of memory free here out of 24GB
>
>
>
> cassandra@rhes564::/apps/cassandra> free
>
>              total       used       free     shared    buffers     cached
>
> Mem:      24675328   14774532    9900796          0     539900    9097992
>
> -/+ buffers/cache:    5136640   19538688
>
> Swap:     24579440        668   24578772
>
>
>
> But I am still getting the same error
>
>
>
> cqlsh:ase> select count(1) from t;
>
> OperationTimedOut: errors={}, last_host=127.0.0.1
>
>
>
> thx
>
>
>
> Mich Talebzadeh
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> Author of the books* "A Practitioner’s Guide to Upgrading to Sybase** ASE
> 15", **ISBN 978-0-9563693-0-7*.
>
> co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN
> 978-0-9759693-0-4*
>
> *Publications due shortly:*
>
> *Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and
> Coherence Cache*
>
> *Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4, volume
> one out shortly
>
>
>
> NOTE: The information in this email is proprietary and confidential. This
> message is for the designated recipient only, if you are not the intended
> recipient, you should destroy it immediately. Any information in this
> message shall not be understood as given or endorsed by Peridale Ltd, its
> subsidiaries or their employees, unless expressly so stated. It is the
> responsibility of the recipient to ensure that this email is virus free,
> therefore neither Peridale Ltd, its subsidiaries nor their employees accept
> any responsibility.
>
>
>
> *From:* Umang Shah [mailto:shahumang4@gmail.com]
> *Sent:* 22 April 2015 10:44
> *To:* user@cassandra.apache.org
> *Subject:* Re: ROperationTimedOut in selerct count statement in cqlsh
>
>
>
> HI,
>
>
>
> It is common problem, if your machine has 4 GB of RAM then you can only
> retrieve records about 200000 so you have to increase the RAM of your
> system to avoid this problem..
>
>
>
> Thanks,
>
> Umang Shah
>
>
>
> On Wed, Apr 22, 2015 at 9:34 AM, Mich Talebzadeh <mich@peridale.co.uk>
> wrote:
>
> Hi,
>
>
>
> I have a table of 300,000 rows.
>
>
>
> When I try to do a simple
>
>
>
> cqlsh:ase> select count(1) from t;
>
> OperationTimedOut: errors={}, last_host=127.0.0.1
>
>
>
> Appreciate any feedback
>
>
>
> Thanks,
>
>
>
> Mich
>
>
>
>
>
> NOTE: The information in this email is proprietary and confidential. This
> message is for the designated recipient only, if you are not the intended
> recipient, you should destroy it immediately. Any information in this
> message shall not be understood as given or endorsed by Peridale Ltd, its
> subsidiaries or their employees, unless expressly so stated. It is the
> responsibility of the recipient to ensure that this email is virus free,
> therefore neither Peridale Ltd, its subsidiaries nor their employees accept
> any responsibility.
>
>
>
>
>
>
>
> --
>
> Regards,
>
> Umang Shah
>
> +919886829019
>



-- 
Regards,
Umang Shah
+919886829019

Mime
View raw message