[
https://issues.apache.org/jira/browse/CASSANDRA-8968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeff Liu updated CASSANDRA-8968:
--------------------------------
Description:
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}
was:
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}
> 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)
