cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maor Cohen (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-10801) Unexplained inconsistent data with Cassandra 2.1
Date Thu, 17 Dec 2015 09:09:46 GMT

    [ 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:09 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.

See tracing.log


was (Author: maor.cohen):
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.

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

Mime
View raw message