cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan McCall <n...@vervewireless.com>
Subject Re: Cassandra reverting deletes?
Date Tue, 27 Apr 2010 21:35:38 GMT
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 <joost@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 <joost@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 <jbellis@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 <joost@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
>>
>>
>

Mime
View raw message