cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Imri Zvik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-10801) Unexplained inconsistent data with Cassandra 2.1
Date Thu, 03 Dec 2015 16:07:10 GMT

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

Imri Zvik commented on CASSANDRA-10801:
---------------------------------------

This is not what the docs at http://docs.datastax.com/en/cassandra/2.1/cassandra/dml/dml_about_hh_c.html
says.
{quote}
During a write operation, when hinted handoff is enabled and consistency can be met, the coordinator
stores a hint about dead replicas in the local system.hints table under either of these conditions:
A replica node for the row is known to be down ahead of time.
A replica node does not respond to the write request.
{quote}

According to that, it will also write a hint upon a timeout.

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

Mime
View raw message