Aurora Cluster instance update "storage-optimization" state is not implemented

[alberts-s]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Terraform Version

• v0.11.8

Provaider Version

• v1.27 - the available RDS states have not been changed after v1.27

Affected Resource(s)

• aws_rds_cluster_instance

Expected Behavior

States listed in AWS provider aws_rds_cluster_instance resource should contain "storage-optimization" state and the instance update should not abruptly fail.

Actual Behavior

Whilst applying the database instance type change the following error is shown:
aws_rds_cluster_instance.instance.0: unexpected state 'storage-optimization', wanted target 'available'. last error: %!s(<nil>)

Steps to Reproduce

• Create AWS RDS Aurora MySQL 5.7 cluster with 2 instances with the following instance types
  • r4.2xlarge
  • r4.2xlarge
• Increase size of one of the instances to r4.4xlarge
• During applying of the change Terraform will fail update due to unknown state

Important Factoids

• All available states for RDS instances are documented here.

[github-actions]

Marking this issue as stale due to inactivity. This helps our maintainers find and focus on the active issues. If this issue receives no comments in the next 30 days it will automatically be closed. Maintainers can also remove the stale label.

If this issue was automatically closed and you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. Thank you!

[github-actions]

This functionality has been released in v3.67.0 of the Terraform AWS Provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading.

For further feature requests or bug reports with this functionality, please create a new GitHub issue following the template. Thank you!

[github-actions]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.
If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.