[ https://issues.apache.org/jira/browse/CASSANDRA-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Cathy Daw updated CASSANDRA-2950: --------------------------------- Comment: was deleted (was: Confirmed this only occurs with Counters. There is a limitation on deleting counters, that they may appear if they haven't been applied to all nodes and compacted away. Not sure if this falls under the same limitation, since in a traditional RDBMS, the semantics for truncate are different from delete.) > Data from truncated Counter 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: Sylvain Lebresne > > * 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=COUNTER_ADD --family-type=Standard --num-keys=1000 > --num-different-keys=10 --columns=1 --consistency-level=QUORUM > --average-size-values --replication-factor=3 --nodes=node1,node1 > // Verify 10 keys in CLI > use Keyspace1; > list Counter1; > //TRUNCATE CF in CLI > use Keyspace1; > truncate counter1; > list counter1; > // Run stress tool and verify creation of 1 key with 1 column valued @ 1000 > stress --operation=COUNTER_ADD --family-type=Standard --num-keys=1000 > --num-different-keys=1 --columns=1 --consistency-level=QUORUM > --average-size-values --replication-factor=3 --nodes=node1,node1 > // Run stress tool and verify update of existing key -- Final result is 2 > columns valued at 1500, 500. > stress --operation=COUNTER_ADD --family-type=Standard --num-keys=500 > --num-different-keys=1 --columns=2 --consistency-level=QUORUM > --average-size-values --replication-factor=3 --nodes=node1,node1 > // Run stress tool and verify update of existing key -- Final result is 3 > columns valued at 2100, 1100, 600. > stress --operation=COUNTER_ADD --family-type=Standard --num-keys=600 > --num-different-keys=1 --columns=3 --consistency-level=QUORUM > --average-size-values --replication-factor=3 --nodes=node1,node1 > {code} > *Data while all three nodes are up* > {code} > [default@Keyspace1] list Counter1; > Using default limit of 100 > ------------------- > RowKey: 30 > => (counter=4330, value=2100) > => (counter=4331, value=1100) > => (counter=4332, value=600) > {code} > * Shutdown nodes 1,2,3 > * Startup nodes 1,2,3 > * Verify in CLI: 11 keys. I am expecting only 1. > *Data after bouncing nodes* > {code} > [default@Keyspace1] list Counter1; > Using default limit of 100 > ------------------- > RowKey: 3036 > => (counter=4330, value=500597) > ------------------- > RowKey: 3038 > => (counter=4330, value=500591) > ------------------- > RowKey: 3039 > => (counter=4330, value=500609) > ------------------- > RowKey: 3033 > => (counter=4330, value=500607) > ------------------- > RowKey: 3037 > => (counter=4330, value=500601) > ------------------- > RowKey: 30 > => (counter=4330, value=2708611) > => (counter=4331, value=606482) > => (counter=4332, value=180798) > ------------------- > RowKey: 3030 > => (counter=4330, value=500616) > ------------------- > RowKey: 3032 > => (counter=4330, value=500596) > ------------------- > RowKey: 3031 > => (counter=4330, value=500613) > ------------------- > RowKey: 3035 > => (counter=4330, value=500624) > ------------------- > RowKey: 3034 > => (counter=4330, value=500618) > 11 Rows Returned. > {code} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira