cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ian Rose (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-7762) range query on secondary index times out (1 row, 1 node)
Date Wed, 13 Aug 2014 14:58:12 GMT
Ian Rose created CASSANDRA-7762:
-----------------------------------

             Summary: 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)

Mime
View raw message