Re: TimedOutException and UnavailableException from multiGetSliceQuery

2011-10-05 Thread Yuhan Zhang
Hi Aaron, thanks for the suggestion. It works again after I cut back the # of rows. On Wed, Oct 5, 2011 at 1:43 PM, aaron morton wrote: > 5000 rows in a mutli get is way, way, way (did I say way ? ) to many. > > Whenever you get a TimedOutException check the tp stats on the nodes, you > will nor

Re: TimedOutException and UnavailableException from multiGetSliceQuery

2011-10-05 Thread aaron morton
5000 rows in a mutli get is way, way, way (did I say way ? ) to many. Whenever you get a TimedOutException check the tp stats on the nodes, you will normally see a high pending count. Every row get get turns into an message in a TP. So if you ask for 5k rows you flood the TP with 5k messages wh

TimedOutException and UnavailableException from multiGetSliceQuery

2011-10-05 Thread Yuhan Zhang
Hi all, I have been experiencing the unavailableException and TimedOutException on a 3-node cassandra cluster during a multiGetSliceQuery with 1000 columns. Since there are many keys involved in the query, I divided them into groups of 5000 rows and process each group individually in a for loop. b