Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-16172

materialized view can return stale data even with R+W>N

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Triage Needed
    • Normal
    • Resolution: Unresolved
    • 5.x
    • None
    • Correctness - Recoverable Corruption / Loss
    • Normal
    • Challenging
    • User Report
    • All
    • None

    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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jasonstack Zhao Yang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: