Hi, I'm having some problems to restore a snapshot using sstableloader. I'm using cassandra 3.11.1 and followed the instructions for a creating and restoring from this page: https://docs.datastax.com/en/dse/6.0/dse-admin/datastax_enterprise/tools/toolsSStables/toolsBulkloader.html
1. Called nodetool cleanup on each node $ nodetool cleanup cass_testapp 2. Called nodetool snapshot on each node $ nodetool snapshot -t snap1 -kt cass_testapp.table3 3. Checked the data and snapshot folders: $ ll /var/lib/cassandra/data/cass_testapp/table3-7227e480f3b411e8941285913bce94cb drwxr-xr-x 2 cassandra cassandra 6 Nov 29 03:54 backups -rw-r--r-- 2 cassandra cassandra 43 Nov 30 10:21 mc-11-big-CompressionInfo.db -rw-r--r-- 2 cassandra cassandra 241 Nov 30 10:21 mc-11-big-Data.db -rw-r--r-- 2 cassandra cassandra 9 Nov 30 10:21 mc-11-big-Digest.crc32 -rw-r--r-- 2 cassandra cassandra 16 Nov 30 10:21 mc-11-big-Filter.db -rw-r--r-- 2 cassandra cassandra 21 Nov 30 10:21 mc-11-big-Index.db -rw-r--r-- 2 cassandra cassandra 4938 Nov 30 10:21 mc-11-big-Statistics.db -rw-r--r-- 2 cassandra cassandra 95 Nov 30 10:21 mc-11-big-Summary.db -rw-r--r-- 2 cassandra cassandra 92 Nov 30 10:21 mc-11-big-TOC.txt drwxr-xr-x 3 cassandra cassandra 18 Nov 30 10:30 snapshots and $ ll /var/lib/cassandra/data/cass_testapp/table3-7227e480f3b411e8941285913bce94cb/snapshots/snap1/ total 44 -rw-r--r-- 1 cassandra cassandra 32 Nov 30 10:30 manifest.json -rw-r--r-- 2 cassandra cassandra 43 Nov 30 10:21 mc-11-big-CompressionInfo.db -rw-r--r-- 2 cassandra cassandra 241 Nov 30 10:21 mc-11-big-Data.db -rw-r--r-- 2 cassandra cassandra 9 Nov 30 10:21 mc-11-big-Digest.crc32 -rw-r--r-- 2 cassandra cassandra 16 Nov 30 10:21 mc-11-big-Filter.db -rw-r--r-- 2 cassandra cassandra 21 Nov 30 10:21 mc-11-big-Index.db -rw-r--r-- 2 cassandra cassandra 4938 Nov 30 10:21 mc-11-big-Statistics.db -rw-r--r-- 2 cassandra cassandra 95 Nov 30 10:21 mc-11-big-Summary.db -rw-r--r-- 2 cassandra cassandra 92 Nov 30 10:21 mc-11-big-TOC.txt -rw-r--r-- 1 cassandra cassandra 1043 Nov 30 10:30 schema.cql 4. Truncated the table cqlsh:cass_testapp> TRUNCATE table3 ; 5. Tried to restore table3 on one cassandra node $ sstableloader -d localhost /var/lib/cassandra/data/cass_testapp/table3-7227e480f3b411e8941285913bce94cb/snapshots/snap1/ Established connection to initial hosts Opening sstables and calculating sections to stream Skipping file mc-11-big-Data.db: table snapshots.table3 doesn't exist Summary statistics: Connections per host : 1 Total files transferred : 0 Total bytes transferred : 0.000KiB Total duration : 2652 ms Average transfer rate : 0.000KiB/s Peak transfer rate : 0.000KiB/s I'm always getting the message "Skipping file mc-11-big-Data.db: table snapshots.table3 doesn't exist". I also tried to rename the snapshots folder into the keyspace name (cass_testapp) but then I get the message "Skipping file mc-11-big-Data.db: table snap1.snap1. doesn't exist". What I'm doing wrong? Thanks Oliver
