You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jim Witschey (JIRA)" <ji...@apache.org> on 2015/11/06 23:16:11 UTC

[jira] [Commented] (CASSANDRA-10547) Updating a CQL List many times creates many tombstones

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

Jim Witschey commented on CASSANDRA-10547:
------------------------------------------

[~benedict] or [~slebresne] can you have a look at this? I'd expect 1000 updates to a list to generate ~1,000 tombstones, not ~100,000.

> Updating a CQL List many times creates many tombstones 
> -------------------------------------------------------
>
>                 Key: CASSANDRA-10547
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10547
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: Cassandra 2.1.9, Java driver 2.1.5
>            Reporter: James Bishop
>         Attachments: tombstone.snippet
>
>
> We encountered a TombstoneOverwhelmingException in cassandra system.log which caused some of our CQL queries to fail.
> We are able to reproduce this issue by updating a CQL List column many times. The number of tombstones created seems to be related to (number of list items * number of list updates). We update the entire list on each update using the java driver. (see attached code for details)
> Running nodetool compact does not help, but nodetool flush does. It appears that the tombstones are being accumulated in memory. 
> For example if we update a list of 100 items 1000 times, this creates more  than 100,000 tombstones and exceeds the default tombstone_failure_threshold.



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