mysql CLOUD_IAM_GROUP user creation error

[allevimi]

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 a user, that user is claiming responsibility for the issue.
• Customers working with a Google Technical Account Manager or Customer Engineer can ask them to reach out internally to expedite investigation and resolution of this issue.

Terraform Version & Provider Version(s)

Terraform v1.14.7
on darwin_arm64

• provider registry.terraform.io/hashicorp/google v7.24.0

Affected Resource(s)

google_sql_user

Terraform Configuration

resource "google_sql_user" "super_user" {
  instance = "<redacted>"

  name           = "<redacted_group>@<redacted_domain>"
  type           = "CLOUD_IAM_GROUP"
  database_roles = ["cloudsqlsuperuser"]
}

Debug Output

https://gist.github.com/allevimi/fcb78f6660e4b962fe016df609ccb5c6

Expected Behavior

iam group user created on GCP and terraform state updated accordingly

Actual Behavior

iam group user is created on GCP but terraform not succeed

Steps to reproduce

1. terraform apply

Important Factoids

authenticating as a user

References

No response

[ggtisc]

Hi @allevimi

Is your DB Postgres or MySQL? https://registry.terraform.io/providers/hashicorp/google/latest/docs/resources/sql_user#type-10

Otherwise you need to share with us the terraform code of your google_sql_database_instance. For sensitive data you could use dummy values like:

project = "my-project"
member = "user:my-user@my-domain.com"
org_id = 1234567890