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

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.15
• Severity: Normal
• Since Version: 2.0.12
• Assignee: Carl Yeksigian
• Reporter: Miroslaw Partyka

Authors

Carl Yeksigian

Reviewers

Sam Tunnicliffe

• Tester: Alan Boudreault
• Created: 18/Mar/15 16:16
• Updated: 16/Apr/19 09:31
• Resolved: 07/Apr/15 19:23

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

Issue Links

• is duplicated by: CASSANDRA-9502 Range-slice queries with CL>ONE do unnecessary read-repairs