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

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 2.0.15
    • None
    • None
    • Normal

    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

              carlyeks Carl Yeksigian
              miron_p Miroslaw Partyka
              Carl Yeksigian
              Sam Tunnicliffe
              Alan Boudreault Alan Boudreault
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: