Agree this is both strictly possible and more common with LCS. The only thing that's strictly correct to do is treat every corrupt sstable exception as a failed host, and replace it just like you would a failed host.
On Thu, Feb 13, 2020 at 10:55 PM manish khandelwal < manishkhandelwa...@gmail.com> wrote: > Thanks Erick > > I would like to explain how data resurrection can take place with single > SSTable deletion. > > Consider this case of table with Levelled Compaction Strategy > > 1. Data A written a long time back. > 2. Data A is deleted and tombstone is created. > 3. After GC grace tombstone is purgeable. > 4. Now the SSTable containing purgeable tombstone in one node is > corruputed. > 4. The node with corrupt SSTable cannot compact the data and purgeable > tombstone > 6. From other two nodes Data A is removed after compaction. > 7. Remove the corrupt SSTable from impacted node. > 8. When you run repair Data A is copied to all the nodes. > > This table in quesiton is using Levelled Compaction Strategy. > > Regards > Manish > > On Fri, Feb 14, 2020 at 12:00 PM Erick Ramirez <erick.rami...@datastax.com> > wrote: > >> The log shows that the the problem occurs when decompressing the SSTable >> but there's not much actionable info from it. >> >> I would like to know what will be "ordinary hammer" in this case. Do you >>> want to suggest that deleting only corrupt sstable file ( in this case >>> mc-1234-big-*.db) would be suffice ? >> >> >> Exactly. I mean if it's just a one-off, why go through the trouble of >> blowing away all the files? :) >> >> I am afraid that this may cause data resurrection (I have prior >>> experience with same). >> >> >> Whoa! That's a long bow to draw. Sounds like there's more history to it. >> >> Note that i am not willing to run the entire node rebuild as it will take >>> lots of time due to presence of multiple big tables (I am keeping it as my >>> last option) >> >> >> I wasn't going to suggest that at all. I didn't like the sledge hammer >> approach. I certainly wouldn't recommend bringing in a wrecking ball. 😁 >> >> Cheers! >> >