Re: Recovery for deleted SSTables files for one column family.

2016-05-19 Thread Mike Yeap
Hi Ben, the scenario that I was trying to test was all sstables (deleted) from one node. So I did what you suggested (rebuild the sstables from other replicas in the cluster) and it rebuilt the sstables successfully. I think the reason that I didn't see the sstables rebuilt earlier on was because

Re: Recovery for deleted SSTables files for one column family.

2016-05-19 Thread Ben Slater
Use nodetool listsnapshots to check if you have a snapshot - in default configuration, Cassandra takes snapshots for operations like truncate. Failing that, is it all sstables from all nodes? In this case, your data has gone I’m afraid. If it’s just all sstables from one node then running repair w

Recovery for deleted SSTables files for one column family.

2016-05-19 Thread Mike Yeap
Hi all, I would like to know, is there any way to rebuild a particular column family when all the SSTables files for this column family are missing?? Say we do not have any backup of it. Thank you. Regards, Mike Yeap