[ https://issues.apache.org/jira/browse/CASSANDRA-2942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-2942: -------------------------------------- Description: * Bring up 3 node cluster * From node1: Run Stress Tool {code} stress --num-keys=10 --columns=10 --consistency-level=ALL --average-size-values --replication-factor=3 --nodes=node1,node2 {code} * Shutdown node3 * From node1: drop the Standard1 CF in Keyspace1 * Shutdown node2 and node3 * Bring up node1 and node2. Check that the Standard1 files are gone. {code} ls -al /var/lib/cassandra/data/Keyspace1/ {code} * Bring up node3. The log file shows the drop column family occurs {code} INFO 00:51:25,742 Applying migration 9a76f880-b4c5-11e0-0000-8901a7c5c9ce Drop column family: Keyspace1.Standard1 {code} * Restart node3 to clear out dropped tables from the filesystem {code} root@cathy3:~/cass-0.8/bin# ls -al /var/lib/cassandra/data/Keyspace1/ total 36 drwxr-xr-x 3 root root 4096 Jul 23 00:51 . drwxr-xr-x 6 root root 4096 Jul 23 00:48 .. -rw-r--r-- 1 root root 0 Jul 23 00:51 Standard1-g-1-Compacted -rw-r--r-- 2 root root 5770 Jul 23 00:51 Standard1-g-1-Data.db -rw-r--r-- 2 root root 32 Jul 23 00:51 Standard1-g-1-Filter.db -rw-r--r-- 2 root root 120 Jul 23 00:51 Standard1-g-1-Index.db -rw-r--r-- 2 root root 4276 Jul 23 00:51 Standard1-g-1-Statistics.db drwxr-xr-x 3 root root 4096 Jul 23 00:51 snapshots {code} *Bug: The files for Standard1 are orphaned on node3* was: * Bring up 3 node cluster * From node1: Run Stress Tool {code} stress --num-keys=10 --columns=10 --consistency-level=ALL --average-size-values --replication-factor=3 --nodes=node1,node2 {code} * Shutdown node3 * From node1: drop the Standard1 CF in Keyspace1 * Shutdown node2 and node3 * Bring up node1 and node2. Check that the Standard1 files are gone. {code} ls -al /var/lib/cassandra/data/Keyspace1/ {code} * Bring up node3. The log file shows the drop column family occurs {code} INFO 00:51:25,742 Applying migration 9a76f880-b4c5-11e0-0000-8901a7c5c9ce Drop column family: Keyspace1.Standard1 {code} * Restart node3 to clear out dropped tables from the filesystem {code} root@cathy3:~/cass-0.8/bin# ls -al /var/lib/cassandra/data/Keyspace1/ total 36 drwxr-xr-x 3 root root 4096 Jul 23 00:51 . drwxr-xr-x 6 root root 4096 Jul 23 00:48 .. -rw-r--r-- 1 root root 0 Jul 23 00:51 Standard1-g-1-Compacted -rw-r--r-- 2 root root 5770 Jul 23 00:51 Standard1-g-1-Data.db -rw-r--r-- 2 root root 32 Jul 23 00:51 Standard1-g-1-Filter.db -rw-r--r-- 2 root root 120 Jul 23 00:51 Standard1-g-1-Index.db -rw-r--r-- 2 root root 4276 Jul 23 00:51 Standard1-g-1-Statistics.db drwxr-xr-x 3 root root 4096 Jul 23 00:51 snapshots {code} *Bug: The files for Standard1 are orphaned on node3* Summary: Dropped columnfamilies can leave orphaned data files that do not get cleared on restart (was: If you drop a CF when one node is down the files are orphaned on the downed node) > Dropped columnfamilies can leave orphaned data files that do not get cleared > on restart > --------------------------------------------------------------------------------------- > > Key: CASSANDRA-2942 > URL: https://issues.apache.org/jira/browse/CASSANDRA-2942 > Project: Cassandra > Issue Type: Bug > Affects Versions: 0.7.0 > Reporter: Cathy Daw > Assignee: Jonathan Ellis > Priority: Minor > Fix For: 1.0.0 > > Attachments: 2942.txt > > > * Bring up 3 node cluster > * From node1: Run Stress Tool > {code} stress --num-keys=10 --columns=10 --consistency-level=ALL > --average-size-values --replication-factor=3 --nodes=node1,node2 {code} > * Shutdown node3 > * From node1: drop the Standard1 CF in Keyspace1 > * Shutdown node2 and node3 > * Bring up node1 and node2. Check that the Standard1 files are gone. > {code} > ls -al /var/lib/cassandra/data/Keyspace1/ > {code} > * Bring up node3. The log file shows the drop column family occurs > {code} > INFO 00:51:25,742 Applying migration 9a76f880-b4c5-11e0-0000-8901a7c5c9ce > Drop column family: Keyspace1.Standard1 > {code} > * Restart node3 to clear out dropped tables from the filesystem > {code} > root@cathy3:~/cass-0.8/bin# ls -al /var/lib/cassandra/data/Keyspace1/ > total 36 > drwxr-xr-x 3 root root 4096 Jul 23 00:51 . > drwxr-xr-x 6 root root 4096 Jul 23 00:48 .. > -rw-r--r-- 1 root root 0 Jul 23 00:51 Standard1-g-1-Compacted > -rw-r--r-- 2 root root 5770 Jul 23 00:51 Standard1-g-1-Data.db > -rw-r--r-- 2 root root 32 Jul 23 00:51 Standard1-g-1-Filter.db > -rw-r--r-- 2 root root 120 Jul 23 00:51 Standard1-g-1-Index.db > -rw-r--r-- 2 root root 4276 Jul 23 00:51 Standard1-g-1-Statistics.db > drwxr-xr-x 3 root root 4096 Jul 23 00:51 snapshots > {code} > *Bug: The files for Standard1 are orphaned on node3* -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira