Re: Understanding index builds (updated: crashed cluster)

2011-03-10 Thread Matt Kennedy
Great, that worked, thanks for your time. On Thu, Mar 10, 2011 at 4:57 PM, Jonathan Ellis wrote: > Drop the index, then restart once more. It shouldn't try to rebuild > the index after that. > > On Thu, Mar 10, 2011 at 3:36 PM, Matt Kennedy > wrote: > > Sorry, I wasn't clear on the timeline of

Re: Understanding index builds (updated: crashed cluster)

2011-03-10 Thread Jonathan Ellis
Drop the index, then restart once more. It shouldn't try to rebuild the index after that. On Thu, Mar 10, 2011 at 3:36 PM, Matt Kennedy wrote: > Sorry, I wasn't clear on the timeline of events.  I started the index build > and then posted this message to the list. Once I read the links you poste

Re: Understanding index builds (updated: crashed cluster)

2011-03-10 Thread Matt Kennedy
Sorry, I wasn't clear on the timeline of events. I started the index build and then posted this message to the list. Once I read the links you posted, I did expect the cluster to crash, but I let it run until it blew up anyway, since I didn't really know how to stop the index build. Which is sort

Re: Understanding index builds (updated: crashed cluster)

2011-03-10 Thread Jonathan Ellis
If you read the bugs I linked, you would see that this is expected behavior with 0.7.3 once you get more data than you can index in-memory. You should wait for the next Hudson build (which will include 2295) and use that. Or, create your indexes before adding the data. On Thu, Mar 10, 2011 at 12

Re: Understanding index builds (updated: crashed cluster)

2011-03-10 Thread Matt Kennedy
Well it looks like the index creation job crashed the cluster. All of the nodes were down having dumped out .hprof files. I brought the cluster back up and when I do "describe keyspace ks" it looks like the index build process has started over again. Is it safe to attempt to stop that by running

Re: Understanding index builds

2011-03-09 Thread Jonathan Ellis
https://issues.apache.org/jira/browse/CASSANDRA-2294 https://issues.apache.org/jira/browse/CASSANDRA-2295 On Wed, Mar 9, 2011 at 5:47 PM, Matt Kennedy wrote: > I'm trying to gain some insight into what happens with a cluster when > indexes are being built, or when CFs with indexed columns are bei

Understanding index builds

2011-03-09 Thread Matt Kennedy
I'm trying to gain some insight into what happens with a cluster when indexes are being built, or when CFs with indexed columns are being written to. Over the past couple of days we've been doing some loads into a CF with 29 indexed columns. Eventually, the nodes just got overwhelmed and the clie