[CASSANDRA-16174] During bootstrap streaming, skipping write path may create orphan MV rows

• 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:20
• Updated: 07/Mar/23 10:53

Description

CASSANDRA-13065 improves the speed of bootstrap streaming by skipping write path for base table with MV.

Unfortunately during bootstrapping, the bootstrapping node may receive a base write that is already deleted or shadowed on other replicas, but the bootstrapping node didn't receive all sstables yet thus bootstapping node may create an orphan view row based on received sstables. Without write path, the newer version data will not create tombstone to shadow orphan view row.

For example, node-A has a base sstable containing: "k=1, v=1@2019", but bootstrapping node didn't receive it yet. A write "k=1, v=0@2018" hitting on bootstrapping node will create an orphan view row: "v=0@2018, k=1". Applying streaming sstables from bootstrap or rebuild through write path can help, but that's something we want to get rid of.

Issue Links

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