[CASSANDRA-16172] materialized view can return stale data even with R+W>N

• Type: Bug
• Status: Triage Needed
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Feature/Materialized Views
• Bug Category: Correctness - Recoverable Corruption / Loss
• Severity: Normal
• Complexity: Challenging
• Discovered By: User Report
• Platform: All
• Assignee: Unassigned
• Reporter: Zhao Yang
• Created: 02/Oct/20 15:12
• Updated: 07/Mar/23 10:54

Description

This is a similar issue as CASSANDRA-8272.

With a key-value table on a 2-node cluster with RF2 and there is a MV that put `value` as partition key.

Insert with ConsistencyLevel.ONE twice with different data, assuming there is a network partition between 2 nodes:

• Node 1 received: pk="a" -> value=1 @ts1
• Node 2 received: pk="a" -> value=2 @ts2 where ts2 > ts1

When querying `value`=1 on MV with ConsistencyLevel.ALL, we got stale row: "a" -> 1.

Issue Links

• is a child of: CASSANDRA-15921 4.0 quality testing: Materialized View