Hi I see a corrupt SSTable in one of my keyspace table on one node. Cluster is 3 nodes with replication 3. Cassandra version is 3.11.2. I am thinking on following lines to resolve the corrupt SSTable issue. 1. Run nodetool scrub. 2. If step 1 fails, run offline sstabablescrub. 3. If step 2 fails, stop node. Remove all SSTables from problematic table.Start the node and run full repair on table.I am removing all SSTABLES of the particular table so as to avoid resurrection of data or any data corruption.
I would like to know are there any side effects of executing step 3 if step 1 and step 2 fails. Regards Manish