google_sql_user with CLOUD_IAM_SERVICE_ACCOUNT type is now totally broken

red8888 commented 2 years ago

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

Terraform v0.14.11

provider registry.terraform.io/cyrilgdn/postgresql v1.14.0
provider registry.terraform.io/hashicorp/aws v3.56.0
provider registry.terraform.io/hashicorp/google v3.81.0
provider registry.terraform.io/hashicorp/google-beta v3.81.0
provider registry.terraform.io/hashicorp/http v2.1.0

Affected Resource(s)

google_sql_user

Terraform Configuration Files


resource "google_sql_user" "my-user" {
  name     = my-user@me.com
  instance = "mydb"
  type     = "CLOUD_IAM_SERVICE_ACCOUNT"
}

Debug Output

When applying changes to google_sql_user.my-user, provider
"registry.terraform.io/hashicorp/google" produced an unexpected new value:
Root resource was present, but now absent.

This is a bug in the provider, which should be reported in the provider's own
issue tracker.

Expected Behavior

Resource is created without error

Actual Behavior

Cannot create new google_sql_user with CLOUD_IAM_SERVICE_ACCOUNT type AND all existing google_sql_user CLOUD_IAM_SERVICE_ACCOUNT resources are seen as new resources- like its not reading their state correctly anymore.

Steps to Reproduce

Attempt to create a google_sql_user with CLOUD_IAM_SERVICE_ACCOUNT set

Important Factoids

I'm not sure if google_sql_user is totally broken or if this is just for CLOUD_IAM_SERVICE_ACCOUNT type.
Importing is broken for these resources as well
Downgrading to v3.65.0 of google provider fixes the issue, but I'm sure whatever version behind latest would work too
0000

b/301412603

manterfield commented 2 years ago

I just had the same issue, downgrading to v3.77.0 also works.

dbslone commented 2 years ago

Having the same issue with hashicorp/google ~> 3.86. According to #9723 this was resolved and released in 3.79 but downgrading to 3.77 resolved the issue

bluemalkin commented 2 years ago

Edit: This seems to be working now in 3.89

hashicorp / terraform-provider-google