Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of hsiao.chuanheng@gmail.com
 designates 209.85.219.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <B6CE3D7B-2988-4BB6-9D07-1F55C35BB6F9@co.sapo.pt>
References: <274B0A13-59D2-4220-8711-36F370721DE4@co.sapo.pt>
 <B6CE3D7B-2988-4BB6-9D07-1F55C35BB6F9@co.sapo.pt>
From: Chuan-Heng Hsiao <hsiao.chuanheng@gmail.com>
Date: Wed, 7 Nov 2012 10:12:59 +0800
Message-ID: 
 <CAE9BFj-x+UDsG3wB3fBQr0EbA9jPJGgYqG92ffmnb8ru6bbvwA@mail.gmail.com>
Subject: Re: Strange delay in query
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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=E9 Cruz <andre.cruz@co.sapo.pt> wrote:
> Can anyone shed some light on this matter, please? I don't want to just i=
ncrease the timeout without understanding why this is happening. Some point=
er for me to investigate would be helpful.
>
> I'm running Cassandra 1.1.5 and these are wide rows (lots of small column=
s). I would think that fetching the first 34 columns would be fast, and jus=
t a little bit slower than 33 columns, but this is a big difference.
>
> Thank you and best regards,
> Andr=E9 Cruz
>
> On Nov 6, 2012, at 2:43 PM, Andr=E9 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 repl=
ication 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=E9 Cruz
>