incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chuan-Heng Hsiao <hsiao.chuanh...@gmail.com>
Subject Re: Strange delay in query
Date Wed, 07 Nov 2012 02:12:59 GMT
Hi Andre,

I am just a cassandra user, the following suggestions may not be valid.

I assume you are using cassandra-cli and connecting to some specific node.

You can check the following steps:

1. Can you still reproduce this issue? (not -> maybe the system/node issue)
2. What's the result when query without limit?
3. What's the result after doing nodetool repair -pr on that
particular column family and that node?

btw, there seems to be some minor bug in the 1.1.5 cassandra-cli (but
not in 1.1.6).
I got error msg after creating an empty keyspace and updating the
replication factor as 3 across 3-4 nodes.
but when I showed the schema again, the result was correct (including
replication factor).

Sincerely,
Hsiao


On Wed, Nov 7, 2012 at 8:34 AM, André Cruz <andre.cruz@co.sapo.pt> wrote:
> Can anyone shed some light on this matter, please? I don't want to just increase the
timeout without understanding why this is happening. Some pointer for me to investigate would
be helpful.
>
> I'm running Cassandra 1.1.5 and these are wide rows (lots of small columns). I would
think that fetching the first 34 columns would be fast, and just a little bit slower than
33 columns, but this is a big difference.
>
> Thank you and best regards,
> André Cruz
>
> On Nov 6, 2012, at 2:43 PM, André Cruz <andre.cruz@co.sapo.pt> wrote:
>
>> Hello.
>>
>> I have a SCF that is acting strange. See these 2 query times:
>>
>>
>> get NamespaceRevision[3cd88d97-ffde-44ca-8ae9-5336caaebc4e] limit 33;
>> ...
>> Returned 33 results.
>> Elapsed time: 41 msec(s).
>>
>> get NamespaceRevision[3cd88d97-ffde-44ca-8ae9-5336caaebc4e] limit 34;
>> ...
>> Returned 34 results.
>> Elapsed time: 3569 msec(s).
>>
>>
>> What can be the cause of this delay? I have a 3 node cluster with a replication factor
of 3, so all of the nodes should have a copy of the data.
>>
>> -> describe cluster;
>> Cluster Information:
>>   Snitch: org.apache.cassandra.locator.PropertyFileSnitch
>>   Partitioner: org.apache.cassandra.dht.RandomPartitioner
>>   Schema versions:
>>       a354e01a-d342-3755-9821-c550dcd1caba: [zzz, yyy, xxx]
>>
>>
>> Is there more information that I can provide?
>>
>> Best regards,
>> André Cruz
>

Mime
View raw message