[
https://issues.apache.org/jira/browse/CASSANDRA-10801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15061757#comment-15061757
]
Maor Cohen edited comment on CASSANDRA-10801 at 12/17/15 9:08 AM:
------------------------------------------------------------------
Tracing result of 3 query executions. First and last queries returned one row
as expected (seems to be found by key cache). Second returned nothing.
was (Author: maor.cohen):
Tracing result of 3 query executions. First and last queries return 1 row as
expected (seems to be found by key cache). Second returned nothing.
> Unexplained inconsistent data with Cassandra 2.1
> ------------------------------------------------
>
> Key: CASSANDRA-10801
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10801
> Project: Cassandra
> Issue Type: Bug
> Reporter: Imri Zvik
> Fix For: 2.1.x
>
> Attachments: tracing.log
>
>
> We are experiencing weird behavior which we cannot explain.
> We have a CF, with RF=3, and we are writing and reading data to it with
> consistency level of ONE.
> For some reason, we see inconsistent results when querying for data.
> Even for rows that were written a day ago, we're seeing inconsistent results
> (1 replca has the data, the two others don't).
> Now, I would expect to see timeouts/dropped mutations, but all relevant
> counters are not advancing, and I would also expect hints to fix this
> inconsistency within minutes, but yet it doesn't.
> {code}
> cqlsh:testing> SELECT WRITETIME(last_update),site_id, tree_id, individual_id,
> last_update FROM testcf WHERE site_id = 229673621 AND tree_id = 9 AND
> individual_id = 9032483;
> writetime(last_update) | site_id | tree_id | individual_id | last_update
> ------------------------+-----------+---------+---------------+-------------
> 1448988343028000 | 229673621 | 9 | 9032483 | 1380912397
> (1 rows)
> cqlsh:testing> SELECT WRITETIME(last_update),site_id, tree_id, individual_id,
> last_update FROM testcf WHERE site_id = 229673621 AND tree_id = 9 AND
> individual_id = 9032483;
> site_id | tree_id | individual_id | last_update
> -----------+---------+---------------+-------------
> (0 rows)
> cqlsh:testing> SELECT dateof(now()) FROM system.local ;
> dateof(now())
> --------------------------
> 2015-12-02 14:48:44+0000
> (1 rows)
> {code}
> We are running with Cassandra 2.1.11 with Oracle Java 1.8.0_65-b17
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
