Re: Insert after Delete fails silently

[Benjamin Black <b...@b3k.us>]

On Thu, Sep 30, 2010 at 5:25 PM, Peter Harrison <ch...@gmail.com> wrote:
> If you delete a row, and it therefore is marked as tombstone, and
> subsequently you try to insert the row again it appears to succeed,
> but if you try to request the row you don't get a result.
>
> If you try to insert a row that has been recently deleted, and has an
> active tombstone I would expect either the tombstone marker to be
> removed, or the insert to fail. It seems to currently accept the
> insert and then subsequently the row can't be found.
>

The SSTables are immutable, so "removing" the tombstone is not an
option.  Instead, a new cell is written out as normal and the conflict
detection and resolution proceeds as usual.  As Aaron suggested, you
have most likely re-used or otherwise erred in your use of timestamps.


b