CODEWITHSUNDEEP
mysqlamazon-web-servicesrds
JoeNyland
JoeNyland

Reputation: 292

Error when trying to increase storage on RDS MySQL instance

I'm trying to increase the allocated storage from 2000GB to 2260GB (and IOPS from 6000 to 7000) on an RDS MySQL instance and I'm getting the following error message:

null (Service: AmazonRDS; Status Code: 500; Error Code: InternalFailure; Request ID: ea593451-3454-11e5-bc38-b7fa8a060cf1)

The read replica for this instance has had it's storage and IOPS increased, so that's not the issue.

Any ideas what might be causing this? If I've missed any key info, please let me know in the comments.

Upvotes: 0

Views: 1279

Answers (1)

JoeNyland
JoeNyland

Reputation: 292

This error was caused by the fact that Memchached was one enabled in the options group that was assigned to the RDS instance that I was trying to increase storage for.

From AWS support engineer:

You got in contact as you were unable to initiate a scale storage for your RDS instance olympus- you were receiving an internal error.

After reviewing this further on my side I let you know that the following error was being reported:

The option 'MEMCACHED' cannot be deleted as instance olympus has Read Replica which has the MEMCACHED present.

This has been brought up with the RDS team as an issue. They are aware of it and are working on a fix, unfortunately Im unable to give a timeframe on this.

To workaround the issue I suggested:

  1. Modify the instance so that the instance is using the default option group i.e. disable memcache
  2. Then modify the allocated storage on the instance.
  3. Once the scale is complete re-add the memcache option group

After carrying out the above suggested steps, I was able to resize the instance and all is well now.

Upvotes: 1

Related Questions