It's a bug in the sstableloader introduced many years ago - before that, it worked as described in documentation...
Oliver Herrmann at "Fri, 30 Nov 2018 17:05:43 +0100" wrote: OH> Hi, OH> I'm having some problems to restore a snapshot using sstableloader. I'm using cassandra 3.11.1 and followed the instructions for OH> a creating and restoring from this page: OH> https://docs.datastax.com/en/dse/6.0/dse-admin/datastax_enterprise/tools/toolsSStables/toolsBulkloader.html OH> 1. Called nodetool cleanup on each node OH> $ nodetool cleanup cass_testapp OH> 2. Called nodetool snapshot on each node OH> $ nodetool snapshot -t snap1 -kt cass_testapp.table3 OH> 3. Checked the data and snapshot folders: OH> $ ll /var/lib/cassandra/data/cass_testapp/table3-7227e480f3b411e8941285913bce94cb OH> drwxr-xr-x 2 cassandra cassandra 6 Nov 29 03:54 backups OH> -rw-r--r-- 2 cassandra cassandra 43 Nov 30 10:21 mc-11-big-CompressionInfo.db OH> -rw-r--r-- 2 cassandra cassandra 241 Nov 30 10:21 mc-11-big-Data.db OH> -rw-r--r-- 2 cassandra cassandra 9 Nov 30 10:21 mc-11-big-Digest.crc32 OH> -rw-r--r-- 2 cassandra cassandra 16 Nov 30 10:21 mc-11-big-Filter.db OH> -rw-r--r-- 2 cassandra cassandra 21 Nov 30 10:21 mc-11-big-Index.db OH> -rw-r--r-- 2 cassandra cassandra 4938 Nov 30 10:21 mc-11-big-Statistics.db OH> -rw-r--r-- 2 cassandra cassandra 95 Nov 30 10:21 mc-11-big-Summary.db OH> -rw-r--r-- 2 cassandra cassandra 92 Nov 30 10:21 mc-11-big-TOC.txt OH> drwxr-xr-x 3 cassandra cassandra 18 Nov 30 10:30 snapshots OH> and OH> $ ll /var/lib/cassandra/data/cass_testapp/table3-7227e480f3b411e8941285913bce94cb/snapshots/snap1/ OH> total 44 OH> -rw-r--r-- 1 cassandra cassandra 32 Nov 30 10:30 manifest.json OH> -rw-r--r-- 2 cassandra cassandra 43 Nov 30 10:21 mc-11-big-CompressionInfo.db OH> -rw-r--r-- 2 cassandra cassandra 241 Nov 30 10:21 mc-11-big-Data.db OH> -rw-r--r-- 2 cassandra cassandra 9 Nov 30 10:21 mc-11-big-Digest.crc32 OH> -rw-r--r-- 2 cassandra cassandra 16 Nov 30 10:21 mc-11-big-Filter.db OH> -rw-r--r-- 2 cassandra cassandra 21 Nov 30 10:21 mc-11-big-Index.db OH> -rw-r--r-- 2 cassandra cassandra 4938 Nov 30 10:21 mc-11-big-Statistics.db OH> -rw-r--r-- 2 cassandra cassandra 95 Nov 30 10:21 mc-11-big-Summary.db OH> -rw-r--r-- 2 cassandra cassandra 92 Nov 30 10:21 mc-11-big-TOC.txt OH> -rw-r--r-- 1 cassandra cassandra 1043 Nov 30 10:30 schema.cql OH> 4. Truncated the table OH> cqlsh:cass_testapp> TRUNCATE table3 ; OH> 5. Tried to restore table3 on one cassandra node OH> $ sstableloader -d localhost /var/lib/cassandra/data/cass_testapp/table3-7227e480f3b411e8941285913bce94cb/snapshots/snap1/ OH> Established connection to initial hosts OH> Opening sstables and calculating sections to stream OH> Skipping file mc-11-big-Data.db: table snapshots.table3 doesn't exist OH> Summary statistics: OH> Connections per host : 1 OH> Total files transferred : 0 OH> Total bytes transferred : 0.000KiB OH> Total duration : 2652 ms OH> Average transfer rate : 0.000KiB/s OH> Peak transfer rate : 0.000KiB/s OH> I'm always getting the message "Skipping file mc-11-big-Data.db: table snapshots.table3 doesn't exist". I also tried to rename OH> the snapshots folder into the keyspace name (cass_testapp) but then I get the message "Skipping file mc-11-big-Data.db: table OH> snap1.snap1. doesn't exist". OH> What I'm doing wrong? OH> Thanks OH> Oliver -- With best wishes, Alex Ott Solutions Architect EMEA, DataStax http://datastax.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org