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

Philip Thompson resolved CASSANDRA-8968.
----------------------------------------
    Resolution: Not a Problem

> Cassandra cqlsh query return different result randomly
> ------------------------------------------------------
>
>                 Key: CASSANDRA-8968
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8968
>             Project: Cassandra
>          Issue Type: Wish
>         Environment: Cassandra 2.0
>            Reporter: Jeff Liu
>
> Noticed that a select query in cqlsh returns different result randomly. It 
> would be nice to get consistent result when same query is performed.
> {noformat}
> cqlsh> select * from cass_dc.cass_dc ;
>  key | value
> -----+-------
>    c |   ccc
>    b |   bbb
> Tracing session: d20490f0-c9ac-11e4-a527-23b8e6fcc12b
>  activity                                                    | timestamp    | 
> source       | source_elapsed
> -------------------------------------------------------------+--------------+--------------+----------------
>                                           execute_cql3_query | 18:14:42,305 | 
> 54.92.168.12 |              0
>          Parsing select * from cass_dc.cass_dc  LIMIT 10000; | 18:14:42,306 | 
> 54.92.168.12 |            855
>                                          Preparing statement | 18:14:42,307 | 
> 54.92.168.12 |           1950
>                                Determining replicas to query | 18:14:42,307 | 
> 54.92.168.12 |           2101
>                          Message received from /x.x.x.12 | 18:14:42,308 | 
> 54.82.42.121 |             56
>                           Enqueuing request to /x.x.x.121 | 18:14:42,308 | 
> 54.92.168.12 |           2685
>                             Sending message to /x.x.x.121 | 18:14:42,308 | 
> 54.92.168.12 |           2825
>  Executing seq scan across 0 sstables for [min(-1), min(-1)] | 18:14:42,309 | 
> 54.82.42.121 |            556
>                           Read 1 live and 0 tombstoned cells | 18:14:42,309 | 
> 54.82.42.121 |            868
>                           Read 1 live and 0 tombstoned cells | 18:14:42,309 | 
> 54.82.42.121 |            956
>                                 Scanned 2 rows and matched 2 | 18:14:42,309 | 
> 54.82.42.121 |            989
>                          Enqueuing response to /x.x.x.12 | 18:14:42,309 | 
> 54.82.42.121 |           1007
>                             Sending message to /x.x.x.12 | 18:14:42,310 | 
> 54.82.42.121 |           1287
>                          Message received from /x.x.x.121 | 18:14:42,319 | 
> 54.92.168.12 |          13656
>                       Processing response from /x.x.x.121 | 18:14:42,319 | 
> 54.92.168.12 |          14133
>                                             Request complete | 18:14:42,319 | 
> 54.92.168.12 |          14808
> cqlsh> select * from cass_dc.cass_dc ;
>  key | value
> -----+-------
>    a |   aaa
>    c |   ccc
>    b |   bbb
> Tracing session: d4ecbcc0-c9ac-11e4-a527-23b8e6fcc12b
>  activity                                                    | timestamp    | 
> source       | source_elapsed
> -------------------------------------------------------------+--------------+--------------+----------------
>                                           execute_cql3_query | 18:14:47,180 | 
> 54.92.168.12 |              0
>          Parsing select * from cass_dc.cass_dc  LIMIT 10000; | 18:14:47,180 | 
> 54.92.168.12 |             81
>                                          Preparing statement | 18:14:47,181 | 
> 54.92.168.12 |            224
>                                Determining replicas to query | 18:14:47,181 | 
> 54.92.168.12 |            383
>  Executing seq scan across 0 sstables for [min(-1), min(-1)] | 18:14:47,184 | 
> 54.92.168.12 |           3611
>                           Read 1 live and 0 tombstoned cells | 18:14:47,184 | 
> 54.92.168.12 |           4073
>                           Read 1 live and 0 tombstoned cells | 18:14:47,185 | 
> 54.92.168.12 |           4239
>                           Read 1 live and 0 tombstoned cells | 18:14:47,185 | 
> 54.92.168.12 |           4559
>                                 Scanned 3 rows and matched 3 | 18:14:47,185 | 
> 54.92.168.12 |           4601
>                                             Request complete | 18:14:47,185 | 
> 54.92.168.12 |           5812
> cqlsh> select * from cass_dc.cass_dc ;
>  key | value
> -----+-------
>    a |   aaa
>    c |   ccc
>    b |   bbb
> Tracing session: 10247f30-c9ad-11e4-a527-23b8e6fcc12b
>  activity                                                    | timestamp    | 
> source       | source_elapsed
> -------------------------------------------------------------+--------------+--------------+----------------
>                                           execute_cql3_query | 18:16:26,531 | 
> 54.92.168.12 |              0
>          Parsing select * from cass_dc.cass_dc  LIMIT 10000; | 18:16:26,531 | 
> 54.92.168.12 |            116
>                                          Preparing statement | 18:16:26,531 | 
> 54.92.168.12 |            237
>                                Determining replicas to query | 18:16:26,531 | 
> 54.92.168.12 |            386
>  Executing seq scan across 0 sstables for [min(-1), min(-1)] | 18:16:26,532 | 
> 54.92.168.12 |           1280
>                           Read 1 live and 0 tombstoned cells | 18:16:26,533 | 
> 54.92.168.12 |           1447
>                           Read 1 live and 0 tombstoned cells | 18:16:26,533 | 
> 54.92.168.12 |           1560
>                           Read 1 live and 0 tombstoned cells | 18:16:26,533 | 
> 54.92.168.12 |           1646
>                                 Scanned 3 rows and matched 3 | 18:16:26,533 | 
> 54.92.168.12 |           1683
>                                             Request complete | 18:16:26,532 | 
> 54.92.168.12 |           1978
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to