Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MultipleTableRestoreUtility Fails With InvalidClusterState Error When Restoring Multiple Tables From A Snapshot #699

Open
pt1691 opened this issue Sep 14, 2023 · 0 comments

Comments

@pt1691
Copy link

pt1691 commented Sep 14, 2023

When using the MultipleTableRestoreUtility, it only works for the first item in the list and fails for the next item due to "InvalidClusterState" exception as Redshift is in a modifying state for a uncertain amount of time (ranging from a few mins to about 15 mins). Adding exception handling on this error with some exponential back-off could be very helpful.

Exception:
botocore.errorfactory.InvalidClusterStateFault: An error occurred (InvalidClusterState) when calling the RestoreTableFromClusterSnapshot operation: There is an operation running on the Cluster. Please try to restore table from snapshot at a later time.

@pt1691 pt1691 changed the title MultipleTableRestoreUtility fails with InvalidClusterState when restoring multiple tables from Snapsot MultipleTableRestoreUtility fails with InvalidClusterState when restoring multiple tables from Snapshot Sep 14, 2023
@pt1691 pt1691 changed the title MultipleTableRestoreUtility fails with InvalidClusterState when restoring multiple tables from Snapshot MultipleTableRestoreUtility Fails With InvalidClusterState Error When Restoring Multiple Tables From A Snapshot Sep 14, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant