cassandra restore error

[shayan]

I tried to restore Cassandra with a fresh Apigee hybrid installation and followed the documentation, but the restore pod is failing. The restore job fails multiple times, then the restore pod is removed, and the restoration is not successful. The logs of the restore pods show a series of "AlreadyExists" messages:

# few logs

Table 'perses.cleanser_job' already exists
/tmp/tmp/schema.cql:1441:AlreadyExists: Table 'perses.marked_entity' already exists
/tmp/tmp/schema.cql:1465:AlreadyExists: Table 'perses.entity_count' already exists

ERROR: cqlsh failed to create schema

[shayan · Accepted solution]

This issue has been resolved.

Check the backup files. 

I deleted the files except schema file that's why it is giving me these already exists error.

If you are facing this issue kindly check your backup files.

[dperezga]

Hi Shayan, I'm facing the same issue. i have 7 backup files, the schema one, and other 6 called ...apigee-cassandra-default-x.tgz . did you delete the others and only left the schema one?

[shayan]

Hi @dperezga ,

No, you don't need to delete the other files. Please check the following points:

1. Overrides File: Ensure that everything is set up according to the documentation.

2. Version Compatibility: Make sure your version matches. For example, if you take a backup from version 10, you can only restore it on version 10, not 11 or 12.

3. Logs and Access: Check the logs of the backup pods and ensure you have access to the backup server or backup directory.

4. SSH Connection: Ensure you have a passwordless SSH connection to the backup server.

Please share your overrides file for the backup module only (make sure to hide the IP of the backup server).

If you need further assistance, I'm available.

#AbacusCambridgePartners