CloudSQL instance disk type is immutable but Terraform provider thinks it can be changed

[philip-harvey]

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.
• If an issue is assigned to the modular-magician user, it is either in the process of being autogenerated, or is planned to be autogenerated soon. If an issue is assigned to a user, that user is claiming responsibility for the issue. If an issue is assigned to hashibot, a community member has claimed the issue already.

Terraform Version

v1.3.6

Affected Resource(s)

• google_sql_database_instance

Terraform Configuration Files

resource "google_sql_database_instance" "main" {
  name             = "main-instance"
  database_version = "POSTGRES_14"
  region           = "us-central1"

  settings {
    # Second-generation instance tiers are based on the machine
    # type. See argument reference below.
    tier = "db-f1-micro"
    disk_type = "PD_HDD"
  }
}

Debug Output

Error: Error, failed to update instance settings for : googleapi: Error 400: Invalid request: Storage type ("dataDiskType") cannot be changed., invalid

Expected Behavior

Instance should be deleted and recreated

Actual Behavior

Error: Error, failed to update instance settings for : googleapi: Error 400: Invalid request: Storage type ("dataDiskType") cannot be changed., invalid

Steps to Reproduce

1. terraform apply
2. Update disk type
3. terraform apply

• #0000

[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.