[CASSANDRA-5854] SELECT with WHERE condition on primary-key secondary-index caused rpc_timeout

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Invalid
• Component/s: Feature/2i Index, Legacy/CQL

Environment

[cqlsh 4.0.0 | Cassandra 2.0.0-beta2 | CQL spec 3.1.0 | Thrift protocol 19.37.0]
Ubuntu 12 lts

• Severity: Normal
• Since Version: 2.0 beta 1
• Assignee: Unassigned
• Reporter: Le Duc Duy
• Created: 06/Aug/13 17:54
• Updated: 16/Apr/19 09:32
• Resolved: 06/Aug/13 18:15

Description

I'm trying to use new feature in cql 3.1 (create secondary index on primary key)
Following cql will reproduce the rpc_timeout bug. I included the response for your convenience

cqlsh> create KEYSPACE gurugara WITH replication =

{'class': 'SimpleStrategy', 'replication_factor': 1}

;
cqlsh> create table Gurugara.incoming_edge (dest_id bigint, source_id bigint, type ascii, time_id timestamp, PRIMARY KEY (dest_id,time_id,source_id)) WITH CLUSTERING ORDER BY (time_id DESC);
cqlsh> CREATE INDEX incoming_edge_source_id ON gurugara.incoming_edge ( source_id );

cqlsh> SELECT time_id FROM gurugara.incoming_edge WHERE source_id = 1 AND dest_id = 2 AND type = 'like';
Bad Request: Cannot execute this query as it might involve data filtering and thus may have unpredictable performance. If you want to execute this query despite the performance unpredictability, use ALLOW FILTERING

cqlsh> SELECT time_id FROM gurugara.incoming_edge WHERE source_id = 1 AND dest_id = 2 AND type = 'like' ALLOW FILTERING;
Request did not complete within rpc_timeout.

cqlsh> INSERT INTO gurugara.incoming_edge (dest_id, time_id , source_id , type ) VALUES ( 1,2,3,'see');

cqlsh> SELECT time_id FROM gurugara.incoming_edge WHERE source_id = 1 AND dest_id = 2 AND type = 'like' ALLOW FILTERING;
Request did not complete within rpc_timeout.

cqlsh> SELECT time_id FROM gurugara.incoming_edge WHERE source_id = 3 AND dest_id = 1 AND type = 'see' ALLOW FILTERING;
Request did not complete within rpc_timeout.
cqlsh>

Issue Links

• duplicates: CASSANDRA-5851 Fix 2i on composite components omissions