question

haizafrul_110648 avatar image
haizafrul_110648 asked haizafrul_110648 commented

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.

restore
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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 haizafrul_110648 commented

@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!

3 comments Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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 commented ·

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

0 Likes 0 ·
Erick Ramirez avatar image Erick Ramirez ♦♦ haizafrul_110648 commented ·

@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 ♦♦ commented ·

@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 ·