Hi all, I'm looking for guidance on a scenario involving NTP clock skew and its impact on Cassandra data.
If an NTP malfunction causes the system clock on multiple Cassandra nodes to jump far into the future (e.g., 100 years), any writes processed during that window will carry far-future timestamps. Once the clock is corrected, these entries effectively become permanent and shadow any new write/delete in the affected partition keys. The only viable recovery approach at scale I've been able to identify is truncating the affected tables. 1. Are there any other known viable recovery procedures that don't require a full truncate? 2. Are there any known existing or planned preventive measures in Cassandra to guard against such scenarios? Any pointers to prior discussions, tooling, or patches would be greatly appreciated. Thanks.
