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

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

Agile BoardAttach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Triage Needed
    • Normal
    • Resolution: Unresolved
    • 4.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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            jasonstack Zhao Yang

            Dates

              Created:
              Updated:

              Issue deployment