Clocks are in sync: cluster04:~/cassandra$ dsh -g development "date" Tue Apr 27 17:36:33 EDT 2010 Tue Apr 27 17:36:33 EDT 2010 Tue Apr 27 17:36:33 EDT 2010 Tue Apr 27 17:36:33 EDT 2010 Tue Apr 27 17:36:34 EDT 2010 Tue Apr 27 17:36:34 EDT 2010 Tue Apr 27 17:36:34 EDT 2010 Tue Apr 27 17:36:34 EDT 2010 Tue Apr 27 17:36:34 EDT 2010 Tue Apr 27 17:36:35 EDT 2010 Tue Apr 27 17:36:35 EDT 2010 Tue Apr 27 17:36:35 EDT 2010
On Tue, Apr 27, 2010 at 5:35 PM, Nathan McCall <n...@vervewireless.com> wrote: > Have you confirmed that your clocks are all synced in the cluster? > This may be the result of an unintentional read-repair occurring if > that were the case. > > -Nate > > On Tue, Apr 27, 2010 at 2:20 PM, Joost Ouwerkerk <jo...@openplaces.org> wrote: >> Hmm... Even after deleting with cl.ALL, I'm getting data back for some >> rows after having deleted them. Which rows return data is >> inconsistent from one run of the job to the next. >> >> On Tue, Apr 27, 2010 at 1:44 PM, Joost Ouwerkerk <jo...@openplaces.org> >> wrote: >>> To check that rows are gone, I check that KeySlice.columns is empty. And as >>> I mentioned, immediately after the delete job, this returns the expected >>> number. >>> Unfortunately I reproduced with QUORUM this morning. No node outages. I am >>> going to try ALL to see if that changes anything, but I am starting to >>> wonder if I'm doing something else wrong. >>> On Mon, Apr 26, 2010 at 9:45 PM, Jonathan Ellis <jbel...@gmail.com> wrote: >>>> >>>> How are you checking that the rows are gone? >>>> >>>> Are you experiencing node outages during this? >>>> >>>> DC_QUORUM is unfinished code right now, you should avoid using it. >>>> Can you reproduce with normal QUORUM? >>>> >>>> On Sat, Apr 24, 2010 at 12:23 PM, Joost Ouwerkerk <jo...@openplaces.org> >>>> wrote: >>>> > I'm having trouble deleting rows in Cassandra. After running a job that >>>> > deletes hundreds of rows, I run another job that verifies that the rows >>>> > are >>>> > gone. Both jobs run correctly. However, when I run the verification >>>> > job an >>>> > hour later, the rows have re-appeared. This is not a case of "ghosting" >>>> > because the verification job actually checks that there is data in the >>>> > columns. >>>> > >>>> > I am running a cluster with 12 nodes and a replication factor of 3. I >>>> > am >>>> > using DC_QUORUM consistency when deleting. >>>> > >>>> > Any ideas? >>>> > Joost. >>>> > >>>> >>>> >>>> >>>> -- >>>> Jonathan Ellis >>>> Project Chair, Apache Cassandra >>>> co-founder of Riptano, the source for professional Cassandra support >>>> http://riptano.com >>> >>> >> >