[
https://issues.apache.org/jira/browse/CASSANDRA-7762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Lebresne updated CASSANDRA-7762:
----------------------------------------
Assignee: (was: 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
> 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)
