[CASSANDRA-13423] Secondary indexes can return stale data for deleted rows in 2.x

• Type: Bug
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Component/s: Feature/2i Index
• Severity: Normal
• Assignee: Andres de la Peña
• Reporter: Benjamin Lerer

Authors

Andres de la Peña

• Created: 07/Apr/17 07:39
• Updated: 16/Apr/19 09:30

Description

In 2.x when the secondary index detect that a row has been deleted it removes it from the index. This approach can result in stale data being returned if one of the nodes has not yet received the deletion.
The problem come from this line|https://github.com/apache/cassandra/blob/cassandra-2.1/src/java/org/apache/cassandra/db/index/composites/CompositesSearcher.java#L284.

To avoid that problem we should remove the rows from the indexes only once they has been garbage collected.

Issue Links

• depends upon: CASSANDRA-8272 2ndary indexes can return stale data