I tried to delete tombstones on a table, but it is not possible.
I did following:
/appl/cassandra/bin/nodetool -u "user" -pw 'pass' -h $(hostname -i) garbagecollect -j 4 keyspaceA tableA
and also with -g CELL
/appl/cassandra/bin/nodetool -u "user" -pw 'pass' -h $(hostname -i) garbagecollect -g CELL -j 4 keyspaceA tableA
but a lot of tombstones still exists.
e.g.
"rows" : [ { "type" : "row", "position" : 30, "clustering" : [ "2019-09-21 02:00+0200", "042c650a-6b42-42c8-813d-e2c91a4831c9" ], "liveness_info" : { "tstamp" : "2019-09-22T00:38:19.287798Z", "ttl" : 34186698, "expires_at" : "2020-10-21T16:56:37Z", "expired" : true }, "cells" : [
I can not find a reason for not deleting expired cells.
gc_grace_time ist 10days (default)
Thanks