[jira] [Commented] (CASSANDRA-9086) CAS precondition mismatch - row is still inserted

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

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

Vladimir commented on CASSANDRA-9086:
-------------------------------------

Carl, could you please explain how in client code I can understood - was data inserted by this last "failed" operation or it was exists before? Maybe ResultSet have some additional information.

> CAS precondition mismatch - row is still inserted
> -------------------------------------------------
>
>                 Key: CASSANDRA-9086
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9086
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: Cassandra version 2.0.11
> 24 nodes in 4 datacenters (6 nodes per dc)
>            Reporter: Roger Schildmeijer
>            Assignee: Carl Yeksigian
>            Priority: Critical
>             Fix For: 2.0.15
>
>         Attachments: conditional_insert_failure_cleaned.txt
>
>
> Cassandra claims CAS precondition didn't match current values[1], but the row is still inserted.
> We are having a quite simple cf schema:
> {code:xml}
> create table index (
>   u text PRIMARY KEY,
>   abc set<uuid>,
> ) WITH
>   compaction={'class': 'LeveledCompactionStrategy'};
> {code}
> CQL statement:
> {code:xml}
> INSERT INTO index(u, abc) VALUES(?, ?) IF NOT EXISTS
> {code}
> Sometimes, especially during some write load, Cassandra claims the conditional insert wasn't satisfied ([applied] false), but the row is still inserted.
> The response from the conditional insert contains [applied]=false + the data we tried to insert.
> A full CQL trace is attached.
> [1] CAS precondition      CAS precondition org.apache.cassandra.cql3.statements.CQL3CasConditions@1b2576ce does not match current values ColumnFamily(username_index -{deletedAt=-9223372036854775808, localDeletion=2147483647, ranges=[abc-abc:!, deletedAt=1427889576525999, localDeletion=1427889564]}- [:false:0@1427889576526000,abc:39f1a470ee694761a8197c0d0ada8e8f:false:0@1427889576526000,]) | 11:59:37.060 | /10.0.0.1 | 533702



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)