You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sylvain Lebresne (JIRA)" <ji...@apache.org> on 2014/08/14 09:37:13 UTC

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

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

Sylvain Lebresne updated CASSANDRA-7762:
----------------------------------------

    Assignee: Tyler Hobbs

> 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
>            Assignee: Tyler Hobbs
>         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)