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
posta 5 mesi fa302 visualizzazioni
2 Risposte
0
Risposta accettata

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
ESPERTO
con risposta 5 mesi fa
profile picture
ESPERTO
verificato 5 mesi fa
  • 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
ESPERTO
con risposta 5 mesi fa
profile picture
ESPERTO
verificato 5 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande