[
https://issues.apache.org/jira/browse/CASSANDRA-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13081941#comment-13081941
]
Brandon Williams commented on CASSANDRA-2950:
---------------------------------------------
Currently, truncate does:
* force a flush
* record the time
* delete any sstables older than the time
This isn't quite enough if the machine crashes shortly afterward, however,
since there can be mutations present in the commitlog that were previously
truncated and are now resurrected by CL replay.
One thing we could do is record the truncate time for the CF in the system ks
and then ignore mutations older than that, however this would require time
synchronization between the client and the server to be accurate.
> Data from truncated CF reappears after server restart
> -----------------------------------------------------
>
> Key: CASSANDRA-2950
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2950
> Project: Cassandra
> Issue Type: Bug
> Reporter: Cathy Daw
> Assignee: Brandon Williams
>
> * Configure 3 node cluster
> * Ensure the java stress tool creates Keyspace1 with RF=3
> {code}
> // Run Stress Tool to generate 10 keys, 1 column
> stress --operation=INSERT -t 2 --num-keys=50 --columns=20
> --consistency-level=QUORUM --average-size-values --replication-factor=3
> --create-index=KEYS --nodes=cathy1,cathy2
> // Verify 50 keys in CLI
> use Keyspace1;
> list Standard1;
> // TRUNCATE CF in CLI
> use Keyspace1;
> truncate counter1;
> list counter1;
> // Run stress tool and verify creation of 1 key with 10 columns
> stress --operation=INSERT -t 2 --num-keys=1 --columns=10
> --consistency-level=QUORUM --average-size-values --replication-factor=3
> --create-index=KEYS --nodes=cathy1,cathy2
> // Verify 1 key in CLI
> use Keyspace1;
> list Standard1;
> // Restart all three nodes
> // You will see 51 keys in CLI
> use Keyspace1;
> list Standard1;
> {code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
