amazon-redshift-utils icon indicating copy to clipboard operation
amazon-redshift-utils copied to clipboard

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

Open pt1691 opened this issue 1 year ago • 0 comments

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 avatar Sep 14 '23 04:09 pt1691