Hi Joel,

On 07/03/14 15:22, Joel Samuelsson wrote:
I try to fetch all the row keys from a column family (there should only be a
couple of hundred in that CF) in several different ways but I get timeouts
whichever way I try:

did you check the node logs for exceptions? You can get this kind of thing if there is an assertion failure when reading a particular row due to corruption for example.

Ciao, Duncan.


Through the cassandra cli:
Fetching 45 rows is fine:
list cf limit 46 columns 0;
.
.
.
45 Rows Returned.
Elapsed time: 298 msec(s).

Fetching 46 rows however gives me a timeout after a minute or so:
list cf limit 46 columns 0;
null
TimedOutException()...

Through pycassa:
keys = cf.get_range(column_count = 1, buffer_size = 2)

for key, val in keys:
      print key

This prints some keys and then gets stuck at the same place each time and then
timeouts.

The columns (column names + value) in the rows should be less than 100 bytes
each, though there may be a lot of them on a particular row.

To me it seems like one of the rows take too long time to fetch but I don't know
why since I am limitiing the number of columns to 0. Without seeing the row, I
have a hard time knowing what could be wrong. Do you have any ideas?



Reply via email to