Not able to insert data into Cassandra./

Question

Hi All,

I have a question regarding inserting data to Cassandra.

I have deleted a row key from a Column Family(CF) after some time I am trying insert data with the same rowkey.

The program gets executed but when I try to access the data with the rowkey from command line I get zero results.

Why is this happening? I know there is some thing called "Tombstone" with each deleted key.

But I am trying to insert the data after compaction.

I have set my <GCGraceSeconds> 0 </GCGraceSeconds>.

Thanks in advance.

Answer 1

probably your delete is happening with a larger timestamp than the insert you did later.

Answer 2

I have seen this same problem happening but I haven't been able to debug it. Currently I'm checking http://wiki.apache.org/cassandra/FAQ#range_ghosts to see if that is causing the problem. Maybe it will help you too.