Jeff Liu created CASSANDRA-8968:
-----------------------------------
Summary: 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 /54.92.168.12 | 18:14:42,308 |
54.82.42.121 | 56
Enqueuing request to /54.82.42.121 | 18:14:42,308 |
54.92.168.12 | 2685
Sending message to /54.82.42.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 /54.92.168.12 | 18:14:42,309 |
54.82.42.121 | 1007
Sending message to /54.92.168.12 | 18:14:42,310 |
54.82.42.121 | 1287
Message received from /54.82.42.121 | 18:14:42,319 |
54.92.168.12 | 13656
Processing response from /54.82.42.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)
