[Bug]: RDS Blue/Green Deployments, not waiting for storage optimisation

[low613]

Terraform Core Version

1.7.3

AWS Provider Version

5.36.0

Affected Resource(s)

• aws_db_instance

Expected Behavior

When modifying storage via blue-green deployment, It should wait for storage optimisation before proceeding

Actual Behavior

It doesnt wait hence throwing an error when it tries to action the switchover

Relevant Error/Panic Output Snippet

│ Error: updating RDS DB Instance (instance): switching over Blue/Green Deployment: operation error RDS: SwitchoverBlueGreenDeployment, https response error StatusCode: 400, RequestID: XXXXXXXXXXXX, InvalidBlueGreenDeploymentStateFault: DB instance instance-green-vl1i0f is not in available state

Terraform Configuration Files

resource "aws_db_instance" "blue_green_test" {
  instance_class        = "db.t4g.micro"
  username              = "test"
  password              = var.password
  allocated_storage     = 35
  max_allocated_storage = 200
  skip_final_snapshot   = true

  engine         = "mariadb"
  engine_version = "10.6"
  blue_green_update {
    enabled = true
  }
  storage_type = "gp3"

  auto_minor_version_upgrade = true
  storage_encrypted          = true
  multi_az                   = false

  performance_insights_enabled          = false
  performance_insights_retention_period = 0
  enabled_cloudwatch_logs_exports       = ["error", "slowquery"]

  backup_retention_period = 7

}

Steps to Reproduce

1. Create Db instance with gp2 storage and blue_green_update enabled
2. update the DB to use gp3
3. run terraform apply

Observe failure when the db is in storage optimisation

Debug Output

No response

Panic Output

No response

Important Factoids

No response

References

No response

Would you like to implement a fix?

None

[github-actions[bot]]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.