Hi all,
I have a table (with default gc_grace_seconds) where we have some row
tombstones created. Currently there are 2 sstables for this.
When we check the sstablemetadata, we found Estimated droppable tombstones:
0.689(for sstable1) and 1.094(for sstable2)
After executing nodetool compact on this table, we found that row
tombstones still exist.
Even after executing nodetool garbagecollect and compact one after another,
we were not able to delete these tombstones.
Please suggest how to remove these.
*Sample of sstabledump (for sstable 1)*
[
{
"partition" : {
"key" : [ "114168" ],
"position" : 733
},
"rows" : [
{
"type" : "row",
"position" : 755,
"clustering" : [ "Disposable Catheter" ],
"deletion_info" : { "marked_deleted" : "2020-10-12T08:57:57.015Z",
"local_delete_time" : "2020-10-12T08:57:57Z" },
"cells" : [ ]
},
{
"type" : "row",
"position" : 791,
"clustering" : [ "Disposable Catheter Akash" ],
"deletion_info" : { "marked_deleted" : "2020-10-12T09:01:28.927Z",
"local_delete_time" : "2020-10-12T09:01:28Z" },
"cells" : [ ]
},
{
"type" : "row",
"position" : 869,
"clustering" : [ "Single Use Catheter test" ],
"liveness_info" : { "tstamp" : "2020-10-12T09:03:00.223Z" },
"cells" : [
{ "name" : "my_id", "value" : 1 }
]
}
]
}
]
*Sample of sstabledump (for sstable 2)*
[
{
"partition" : {
"key" : [ "114168" ],
"position" : 544360
},
"rows" : [
{
"type" : "row",
"position" : 544382,
"clustering" : [ "Disposable Catheter" ],
"deletion_info" : { "marked_deleted" : "2020-10-12T08:57:57.015Z",
"local_delete_time" : "2020-10-12T08:57:57Z" },
"cells" : [ ]
},
{
"type" : "row",
"position" : 544418,
"clustering" : [ "Disposable Catheter Akash" ],
"deletion_info" : { "marked_deleted" : "2020-10-12T09:01:28.927Z",
"local_delete_time" : "2020-10-12T09:01:28Z" },
"cells" : [ ]
},
{
"type" : "row",
"position" : 544496,
"clustering" : [ "Single Use Catheter test" ],
"liveness_info" : { "tstamp" : "2020-10-12T09:03:00.223Z" },
"cells" : [
{ "name" : "my_id", "value" : 1 }
]
},
{
"type" : "row",
"position" : 544551,
"clustering" : [ "Catheter" ],
"liveness_info" : { "tstamp" : "2020-05-26T08:07:38.153026Z" },
"cells" : [
{ "name" : "my_id", "value" : 1 }
]
}
]
}
]
Regards,
Ashish
