Good afternoon! I have a question related to a system level keyspace.

Problem: While running a routine full repair on a specific keyspace and
table where i had to remove one of the big data portions for corruption
(sstablescrub failed), the system.log indicated that the specific keyspace
and table repaired successfully. Nevertheless, the system.log also
indicated that one of the big data files related to system.sstable_activity
was corrupted.

I tried running nodetool scrub on the system.sstable_activity, but it
tombstoned 0 rows and still states it is corrupted. I also verified, via
cqlsh, that the specific node's sstable_activity is not queryable either.

Because the system keyspace is local, i don't think i can repair it with
nodetool repair. What would be the steps involved to correct this table?

Version of Apache Cassandra: 3.9 ( its old )

Current ideas i have not yet performed:

1.) Stop cassandra manually. Remove the offending .db file throwing the
corruption error. Restart cassandra. See if cassandra will rebuild the
table automatically.

2.) As (1) above, but remove the entire folder instead of specific db file.

3.) Drop the node from the cluster ( would like to avoid this, some data is
RF 1, and i still need to complete other full repairs)

4.) Sstablescrub on system.sstable_activity? ( i dont believe this will do
anything because RF is still local )



Any suggestions moving forward would be appreciated! Thanks!

Reply via email to