DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


question

sunil281984 avatar image
sunil281984 asked Erick Ramirez answered

Data not restored using sstableloader in DS201 exercise

Hello,

I am working on the exercise of Backup and restore of DSE 210.

I created backup snapshot as per the exercise on below path:

ubuntu@ds210-node1:/$ sudo sh -c 'ls -al /var/lib/cassandra/data/killr_video/user_by_email-*/snapshots/'
total 12
drwxr-xr-x 3 cassandra cassandra 4096 Sep 6 14:00 .
drwxr-xr-x 4 cassandra cassandra 4096 Sep 6 13:56 ..
drwxr-xr-x 2 cassandra cassandra 4096 Sep 6 13:36 1630935377857
ubuntu@ds210-node1:/$

I tried to Restore using sstable loader comand as below and output is as below:

Established connection to initial hosts
Opening sstables and calculating sections to stream

Summary statistics:
Connections per host : 1
Total files transferred : 0
Total bytes transferred : 0.000KiB
Total duration : 3668 ms
Average transfer rate : 0.000KiB/s
Peak transfer rate : 0.000KiB/s

I can see no files are transfereed

and when I check the files on data directory , there no files restored also:

ubuntu@ds210-node1:/$ sudo sh -c 'ls -al /var/lib/cassandra/data/killr_video/user_by_email-*/'
total 16
drwxr-xr-x 4 cassandra cassandra 4096 Sep 6 13:56 .
drwxr-xr-x 3 cassandra cassandra 4096 Aug 13 16:26 ..
drwxr-xr-x 2 cassandra cassandra 4096 Aug 13 16:26 backups
drwxr-xr-x 3 cassandra cassandra 4096 Sep 6 14:00 snapshots
ubuntu@ds210-node1:/$

Please help me on this

ds210
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

The symptoms you described indicate to me that there was no data in the source directory for sstableloader to restore which is why there was no data transferred.

The most likely cause is that you've missed at least 1 step in the exercise instructions.

Start over and try again. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.