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 * 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