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

Reading from table which contains collection type using token function and with CL > ONE causes overwhelming writes to replicas

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 2.0.15
    • Component/s: None
    • Labels:
      None
    • Severity:
      Normal
    • Since Version:

      Description

      When reading from a table at the aforementioned conditions, each read from replica also casues write to the replica.

      Confimed in version 2.0.12 & 2.0.13, version 2.1.3 seems ok.

      To reproduce:

      CREATE KEYSPACE test WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1': 2};
      USE test;
      CREATE TABLE bug(id int PRIMARY KEY, val map<int,int>);
      INSERT INTO bug(id, val) VALUES (1, {2: 3});
      CONSISTENCY LOCAL_QUORUM
      TRACING ON
      SELECT * FROM bug WHERE token(id) <= 0;

      trace contains twice:
      Appending to commitlog
      Adding to bug memtable

        Attachments

        1. trace.txt
          7 kB
          Miroslaw Partyka
        2. 8989-2.0.txt
          7 kB
          Carl Yeksigian

          Issue Links

            Activity

              People

              • Assignee:
                carlyeks Carl Yeksigian
                Reporter:
                miron_p Miroslaw Partyka
                Authors:
                Carl Yeksigian
                Reviewers:
                Sam Tunnicliffe
                Tester:
                Alan Boudreault
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: