[
https://issues.apache.org/jira/browse/CASSANDRA-10547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15004378#comment-15004378
]
Susan Perkins commented on CASSANDRA-10547:
-------------------------------------------
Our organization having significant tombstone issues when we update arrays of
doubles in Cassandra. Even if the data doesn't actually change it still
creates a tombstone for every cell, instead of doing an intelligent upsert.
It's making it impossible to use this particular column family.
> 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)
