cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "DOAN DuyHai (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-7762) range query on secondary index times out (1 row, 1 node)
Date Wed, 13 Aug 2014 19:52:11 GMT

    [ 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)

Mime
View raw message