Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

haizafrul_110648 avatar image
haizafrul_110648 asked ·

PIT Restore fails with known exception; find all tables that need to be re-created

Environment:

[cqlsh 5.0.1 | DSE 6.7.4 | CQL spec 3.4.5 | DSE protocol v2]

I tried performing a PIT restore and it failed with the following error.

 Error starting restore: PIT Restore cannot restore commit logs for tables that have to be re-created in Cassandra 2.1+ and DSE 4.7+ (keyspace: dba table: iris_with_id) 

My inference from this is this particular table needs to be re-created in cassandra 2.1+ for PIT restores to work. If that is correct, how can I identify all the tables in my environment which need to be re-created?

Thanks.

restoredatastax enterprise server 6.7.4operationspit restore
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.

haizafrul_110648 avatar image
haizafrul_110648 answered ·

Makes sense on the version difference part. But I should be able to restore a table which does not exists in the current schema, right? @Erick Ramirez

1 comment 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.

@haizafrul_110648 Just a friendly note that you have posted a comment as an "answer". Please edit and re-post so other users in the future don't mistake it as an answer. Thanks for your understanding. Cheers!

0 Likes 0 · ·
Erick Ramirez avatar image
Erick Ramirez answered ·

@haizafrul_110648 the error you posted indicates that you were trying to restore very old OpsCenter backups for tables which do not currently exist in the schema. The commit logs for the timeperiod you selected are DSE 4.8 format but your cluster is now DSE 6.7 so they are not compatible. Say you tried to restore to Oct 2018 when the cluster was DSE 4.8. This is not possible since those commit logs are not compatible with DSE 6.7. Cheers!

1 comment 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.

@haizafrul_110648 yes, you can but the problem here is that you're restoring data from a point-in-time when the cluster was either DSE 4.7 or 4.8 and those commit logs are not compatible with DSE 6.7. Cheers!

0 Likes 0 · ·