On Wed, Feb 1, 2012 at 12:58 AM, Todd Fast <t...@conga.com> wrote:
> I added a row with a single column to my 1.0.8 single-node cluster:
>
> RowKey: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa
> => (column=test, value=hi, timestamp=...)
>
> I immediately deleted the row using both the CLI and CQL:
>
> del Foo[lexicaluuid('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')];
> delete from Foo using consistency all where
> KEY=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa
>
> In either case, the column "test" is gone but the empty row key still
> remains, and the row count reflects the presence of this phantom row.
>
> I've tried nodetool compact/repair/flush/cleanup/scrub/etc. and nothing
> removes the row key.
http://wiki.apache.org/cassandra/FAQ#range_ghosts
--
Benjamin Hawkes-Lewis
