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)