[jira] [Resolved] (CASSANDRA-7762) range query on secondary index times out (1 row, 1 node)

["Sylvain Lebresne (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-7762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sylvain Lebresne resolved CASSANDRA-7762.
-----------------------------------------

    Resolution: Duplicate

This is a duplicate of CASSANDRA-6612. The same AssertionError shows in the server log in particular (and the trace confirms that the no index is used while it should have). I've confirmed that this does work properly on the current cassandra-2.0 branch.

> range query on secondary index times out (1 row, 1 node)
> --------------------------------------------------------
>
>                 Key: CASSANDRA-7762
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7762
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: Mac OSX 10.7.5
> Fresh install of Cassandra 2.0.9
>            Reporter: Ian Rose
>         Attachments: query-trace.txt
>
>
> Setup: 
> - single cassandra node (on localhost)
> - in cassandra.yaml, listen_address: "127.0.0.1" and seeds: "127.0.0.1"
> Here is my test schema:
> CREATE TABLE foo (
>   foo_name ascii,
>   foo_shard bigint,
>   int_val bigint,
>   PRIMARY KEY ((foo_name, foo_shard))
> ) WITH read_repair_chance=0.1;
> CREATE INDEX ON foo (int_val);
> CREATE INDEX ON foo (foo_name);
> I have inserted just a single row into this table:
> insert into foo(foo_name, foo_shard, int_val) values('dave', 27, 100);
> This query works fine:
> > select * from foo where foo_name='dave';
> But when I run this query, I get an RPC timeout:
> > select * from foo where foo_name='dave' and int_val > 0 allow filtering;
> Request did not complete within rpc_timeout.
> With tracing enabled, here is the trace output (also attached):
> http://pastebin.com/raw.php?i=6XMEVUcQ
> (In short, everything looks fine to my untrained eye until 10s elapsed, at which time the following event is logged: "Timed out; received 0 of 1 responses for range 257 of 257")
> Also note that if I *remove* the index on int_val (leaving just the index on foo_name), then the query works fine:
> > select * from foo where foo_name='dave' and int_val > 0 allow filtering;
>  foo_name | foo_shard | int_val
> ----------+-----------+---------
>      dave |        27 |     100
> (1 rows)



--
This message was sent by Atlassian JIRA
(v6.2#6252)