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 andre.cruz@co.sapo.pt
 designates 212.55.154.23 as permitted sender)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\))
Subject: Re: Strange delay in query
From: =?iso-8859-1?Q?Andr=E9_Cruz?= <andre.cruz@co.sapo.pt>
In-Reply-To: 
 <CAE9BFj-x+UDsG3wB3fBQr0EbA9jPJGgYqG92ffmnb8ru6bbvwA@mail.gmail.com>
Date: Wed, 7 Nov 2012 12:15:55 +0000
Content-Transfer-Encoding: quoted-printable
Message-Id: <4C258FB6-F8BF-43E2-B678-7BF8CECB2A49@co.sapo.pt>
References: <274B0A13-59D2-4220-8711-36F370721DE4@co.sapo.pt>
 <B6CE3D7B-2988-4BB6-9D07-1F55C35BB6F9@co.sapo.pt>
 <CAE9BFj-x+UDsG3wB3fBQr0EbA9jPJGgYqG92ffmnb8ru6bbvwA@mail.gmail.com>
To: <user@cassandra.apache.org>

On Nov 7, 2012, at 2:12 AM, Chuan-Heng Hsiao <hsiao.chuanheng@gmail.com> =
wrote:

> I assume you are using cassandra-cli and connecting to some specific =
node.
>=20
> You can check the following steps:
>=20
> 1. Can you still reproduce this issue? (not -> maybe the system/node =
issue)

Yes. I can reproduce this issue on all 3 nodes. Also, I have a =
replication factor of 3.


> 2. What's the result when query without limit?


This row has 600k columns. I issued a count, and after some 10s:

[disco@Disco] count =
NamespaceRevision[3cd88d97-ffde-44ca-8ae9-5336caaebc4e];
609054 columns


> 3. What's the result after doing nodetool repair -pr on that
> particular column family and that node?

I already issued a "nodetool repair" on all nodes, nothing changed. =
Would your command be any different?


> btw, there seems to be some minor bug in the 1.1.5 cassandra-cli (but
> not in 1.1.6).

This error also happens on my application that uses pycassa, so I don't =
think this is the same bug.


Thanks for the help!

Andr=E9=