You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "DOAN DuyHai (JIRA)" <ji...@apache.org> on 2014/08/13 21:52:11 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14096009#comment-14096009 ]
DOAN DuyHai commented on CASSANDRA-7762:
----------------------------------------
I actually can reproduce the same issue. Mac OS X Mavericks, C* 2.0.9
My traces are quite similar, shorter
{code:sql}
Tracing session: 9967bb90-2322-11e4-aad7-f75797a92abd
activity | timestamp | source | source_elapsed
-------------------------------------------------------------------------------------------------+--------------+-----------+----------------
execute_cql3_query | 21:47:03,754 | 127.0.0.1 | 0
Parsing select * from foo where foo_name='dave' and int_val > 0 allow filtering; | 21:47:03,755 | 127.0.0.1 | 1116
Preparing statement | 21:47:03,756 | 127.0.0.1 | 1826
Determining replicas to query | 21:47:03,758 | 127.0.0.1 | 4584
No applicable indexes found | 21:47:03,769 | 127.0.0.1 | 14993
Executing seq scan across 0 sstables for [min(-9223372036854775808), min(-9223372036854775808)] | 21:47:03,769 | 127.0.0.1 | 15048
Read 1 live and 0 tombstoned cells | 21:47:03,769 | 127.0.0.1 | 15123
Scanned 1 rows and matched 0 | 21:47:03,769 | 127.0.0.1 | 15215
Timed out; received 0 of 1 responses for range 257 of 257 | 21:47:13,771 | 127.0.0.1 | 10017413
Request complete | 21:47:13,775 | 127.0.0.1 | 10021748
{code}
The duration goes through the roof for the "Scanned 1 rows and matched 0" step
> 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)