[CASSANDRA-17789] Extend nodetool verify with functionality to detect partitions with duplicate keys

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 5.0-alpha1, 5.0
• Component/s: Tool/nodetool
• Change Category: Operability
• Complexity: Low Hanging Fruit
• Platform: All

Source Control Link

https://gitbox.apache.org/repos/asf?p=cassandra.git;a=commit;h=e36aeb49e008568a2f551bb749bbb55aeaa80a72

Test and Documentation Plan

No new testing; relying on current testing functionality to ensure existing scrub/verify logic works.

• Assignee: Josh McKenzie
• Reporter: Josh McKenzie

Authors

Josh McKenzie

Reviewers

Marcus Eriksson

• Created: 01/Aug/22 18:30
• Updated: 12/Sep/23 13:03
• Resolved: 04/Aug/22 16:44

Description

We've seen instances where, during upgrades across major versions and in mixed version clusters, we end up with data in a table that has duplication of primary keys. This is obviously an illegal state and being able to quickly scan for this and log partition keys for which we're seeing this state has proven quite useful.

It's a fairly small change to verify/scrub to integrate this extra functionality.