Hi all,
I'm new to cassandra and DSE and have problems restoring daily backup from DSE to local machine.
There is a DSE cluster managed by OpsCenter, version 6.8.13. OpsCenter reports version 6.8.13 and cqlsh, when connected, reports version 6.8.13
I want to restore entire or partial CF from daily backup to local machine, but without any luck. DSE is configured to take daily backups to s3. What I did:
- download and run exactly the same dse 6.8.13 locally
- locally create a CF with exactly the same structure (DDL taken from OpsCenter)
- find backups.json file in s3 - I take it from one of the nodes. Afterwards I find all rows related to my CF and download corresponding files from s3://buckets/{node-id}/sstables/{filename} to local dir
Now I tried a couple of ways to import those files locally:
- copy downloaded files to /var/lib/cassandra/data/database/table/ and run nodetool refresh - no luck
- copy copy downloaded files to /var/lib/cassandra/data/imported-data and run nodetool import database tablename
- use sstableloader
the result is always the same - empty output from the tools and nothing interesting in logs. After I restart cassandra - it doesn't start with error "Detected unreadable sstables ... imported files"
What am I doing wrong? How can I import sstables from a backup?
[UPDATE] example files I copied:
{'format': 'bti-', 'generation': '20519', 'name': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b-bb-20519-bti-CompressionInfo.db', 'type': 'CompressionInfo', 'keyspace': 'abc', 'size': 27567, 'uniquifier': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b', 'compressed': None, 'cf': 'kpi_monthly', 'version': 'bb'} {'format': 'bti-', 'generation': '20519', 'name': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b-bb-20519-bti-Filter.db', 'type': 'Filter', 'keyspace': 'abc', 'size': 83120, 'uniquifier': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b', 'compressed': None, 'cf': 'kpi_monthly', 'version': 'bb'} {'format': 'bti-', 'generation': '20519', 'name': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b-bb-20519-bti-Data.db', 'type': 'Data', 'keyspace': 'abc', 'size': 86855574, 'uniquifier': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b', 'compressed': None, 'cf': 'kpi_monthly', 'version': 'bb'} {'format': 'bti-', 'generation': '20519', 'name': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b-bb-20519-bti-Partitions.db', 'type': 'Partitions', 'keyspace': 'abc', 'size': 1122076, 'uniquifier': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b', 'compressed': None, 'cf': 'kpi_monthly', 'version': 'bb'} {'format': 'bti-', 'generation': '20519', 'name': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b-bb-20519-bti-Statistics.db', 'type': 'Statistics', 'keyspace': 'abc', 'size': 11710, 'uniquifier': '94a95de27224e63d289662bc34e2c39bc64181407d67f17f7b942370a60fd86b', 'compressed': None, 'cf': 'kpi_monthly', 'version': 'bb'}