RDS Instance class modification error

0

Cannot modify the instance class because there are not enough availability zones that have the requested instance class. Please try your request again at a later time.

Getting this error while trying to modify the RDS SQL Server instance t3.xlarge in us-east-1 region.. Could someone help what the issue is and how to solve it

profile picture
asked 4 months ago290 views
2 Answers
0
Accepted Answer

Hi,

Please, have a look at https://repost.aws/knowledge-center/aurora-mysql-instance-class-error

1st part of section "Resolution" clearly explains the cause of your issue and how to remediate it.

Best,

Didier

profile pictureAWS
EXPERT
answered 4 months ago
profile picture
EXPERT
reviewed 4 months ago
  • Hi, thanks for the answer. 'm able to see my RDS AZ in the command output of the resolution. aws rds describe-orderable-db-instance-options --engine aurora --engine-version 5.6.10a --db-instance-class db.t3.medium --query 'OrderableDBInstanceOptions[].AvailabilityZones' still i'm able to see the same error.

  • Ok, in how many AZs do you deploy the RDS instance? Just one or more ?

  • it's a multi-az instance for which subnet groups are spawned in two AZs

  • Hi, so do you see the 2 AZ replicas for your RDS instance ?

  • hey sorry, i didn't get the 2 AZ replicas thing. sorry. But my RDS is running on 2 AZs which means multi-AZ is turned on.

0

I have had the same error before and even raised a support ticket with AWS and they came back with the same answer as Didier.

I had to work around this issue and AWS never fixed it.

  1. Create snapshot of existing RDS instance.
  2. delete existing instance.
  3. restore snapshot with the size you need

2nd option.

  1. Create snapshot of RDS instance.
  2. delete existing snapshot.
  3. restore snapshot in different AZ and the problem never happens again.
profile picture
EXPERT
answered 4 months ago
profile picture
EXPERT
reviewed 4 months 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.

Guidelines for Answering Questions