[CASSANDRA-14242] Indexed static column returns inconsistent results

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.21, 3.11.7, 4.0-beta1, 4.0
• Component/s: Feature/2i Index

Environment

Cassandra 3.11.2

Java driver 3.4.0

Ubuntu - 4.4.0-112-generic

• Severity: Normal
• Since Version: 3.0.0

Source Control Link

https://ci-cassandra.apache.org/job/Cassandra-devbranch-test/61/

Test and Documentation Plan

New unit tests

• Assignee: Andres de la Peña
• Reporter: Ross Black

Authors

Andres de la Peña

Reviewers

Benjamin Lerer

• Created: 20/Feb/18 03:25
• Updated: 15/May/20 08:54
• Resolved: 27/Apr/20 15:46

Description

I am using Cassandra 3.11.2, and the Java driver 3.4.0

I have a table that has a static column, where the static column has a secondary index.
When querying the table I get incomplete or duplicated results, depending on the fetch size.

e.g.

CREATE KEYSPACE hack WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
CREATE TABLE hack.stuff (id int, kind text, chunk int static, val1 int, PRIMARY KEY (id, kind));
CREATE INDEX stuff_chunk_index ON hack.stuff (chunk);

– repeat with thousands of values for id =>

  INSERT INTO hack.stuff (id, chunk, kind, val1 ) VALUES (${id}, 777, 'A', 123);

Querying from Java:

    final SimpleStatement statement = new SimpleStatement("SELECT id, kind, val1 FROM hack.stuff WHERE chunk = " + chunk); 
    statement.setFetchSize(fetchSize);
    statement.setConsistencyLevel(ConsistencyLevel.ALL);
    final ResultSet resultSet = connection.getSession().execute(statement);
    for (Row row : resultSet) {
        final int id = row.getInt("id");
    }

The number of results returned depends on the fetch-size.

e.g. For 30k values inserted, I get the following:

fetch-size	result-size
40000	30000
20000	30001
5000	30006
100	30303

In production, I have a much larger table where the correct result size for a specific chunk is 20019, but some fetch sizes will return significantly fewer results.

fetch-size	result-size
25000	20019
5000	9999	<== this one is has far fewer results
5001	20026

(so far been unable to reproduce this with the simpler test table)

Thanks,
Ross