Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Redshift cluster stuck at modifying

0

Hi team, hope you are all fine.

We have a Redshift Cluster that is stuck in "Modifying" status since Redshift outage that occurred yesterday. We have tried everything to bring it back or even delete it and it's impossible to do so.

Hope you guys can give me a solution to either bring back my cluster or create a new one with the same host in order to maintain the connection info.

Thanks.

Topics
Analytics
Tags
Amazon Redshift
Language
English
asked 4 years ago4.5K views
4 Answers
2

FYI, I opened up a trouble ticket and they told me that I will need to delete the cluster and create a new one from backup. If you use the same cluster name, the endpoint will also be the same. It will have a different IP, but the conx string should be the same.

edit: My redshift instance finally came back online!

answered 4 years ago
1

Same problem here. Ours is stuck in Modifying too since the outage yesterday.

answered 4 years ago
0

Same problem here. Production database has started modification without any prerequisites. Because of that modification, production Redshift cluster is unreachable anymore.

answered 3 years ago
  • quanns
    2 years ago

    How did you solve this? I'm facing the same problem with Redshift serverless. I could not query data and delete the namespace/workgroup.

0

hello guys, the same problem here. redshift is almost 4 hours, in modify, and it has a zero -etl attached and I can't delete neither the zero etl nor the redshift. Any suggestions?

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content