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?