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.c...@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.c...@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 >