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?