Cannot modify db instance when it's state is Available

0

I am trying to increase the storage for a single AZ postgres instance. The current DBInstanceStatus is "available" and there have been no other storage changes for some time, however when trying to resize it, I'm getting the below error

  $ aws rds modify-db-instance --db-instance-identifier dbname --allocated-storage 14644
An error occurred (InvalidParameterCombination) when calling the ModifyDBInstance operation: You can't currently modify the storage of this DB instance because the previous storage change is being optimized.

Has anyone seen this before or know how to fix?

Thanks

5개 답변
0

If this persists I suspect you will need to open a support case. The forums are for community discussion and don't function well for individualized support (though sometimes you do get lucky and an AWS employee intervenes here).

HalTemp
답변함 6년 전
0

While the support case answer is probably correct, paying for the support to tell AWS about a bug on their side is not in the budget. I can work around it if it gets to the critical stage but a quick fix would have been nicer.

답변함 6년 전
0

This is a expected behavior and can be found in the below link-
"https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html#CHAP_Storage.AddingChanging"

After you modify the storage for a DB instance, the status of the DB instance is storage-optimization. The DB instance is fully operational after a storage modification. However, you can't make further storage modifications for either six hours or while the DB instance status is storage-optimization, whichever is longer.

답변함 6년 전
0

It has been several days now and I'm still getting the same error, which I don't expect. The issue is that I believe is a bug is that the status of the DB instance is "available", usually I have seen it enter that state after "storage-optimization" is complete.

답변함 6년 전
0

I eventually managed to resize the storage by converting the instance to Multi-AZ, then forcing a failover and convert back to single-AZ.

답변함 6년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠