[jira] [Commented] (CASSANDRA-10801) Unexplained inconsistent data with Cassandra 2.1

["Philip Thompson (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-10801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15037942#comment-15037942 ] 

Philip Thompson commented on CASSANDRA-10801:
---------------------------------------------

Your consistency appears to match the CL you are querying with. I don't see the issue here.

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