cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Liu (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-8968) Cassandra cqlsh query return different result randomly
Date Fri, 13 Mar 2015 19:04:38 GMT

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

Jeff Liu resolved CASSANDRA-8968.
---------------------------------
    Resolution: Fixed

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

Mime
View raw message