amazon-redshift-utils
amazon-redshift-utils copied to clipboard
MultipleTableRestoreUtility Fails With InvalidClusterState Error When Restoring Multiple Tables From A Snapshot
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.