Proper error message for HTTP 409 while provisioning Google Cloud SQL instance

[gtirloni]

The issue is described in detail in #4557:

* google_sql_database_instance.default: Error, failed to create instance master-instance: googleapi: Error 409: The instance or operation is not in an appropriate state to handle the request., invalidState

This happens because instance names cannot be reused for up to a week after it's deleted.

The enhancement landed in #4577 but it's not showing properly which is leading to confused users.

Terraform 0.11.13

[apparentlymart]

Hi @gtirloni! Sorry for this unhelpful error message.

It looks like this message comes from inside the Google Cloud Platform provider code, rather than from the Terraform Core code. Back in 2016 when #4577 was merged, all of the providers were inside this codebase too, but they've since been split out into their own repositories.

I'm going to ask our bot to migrate this over to the Google Cloud Platform provider repository so that the provider team can see it and decide what to do about it.

Thanks for reporting this!

[ghost]

This issue has been automatically migrated to hashicorp/terraform-provider-google#3404 because it looks like an issue with that provider. If you believe this is not an issue with the provider, please reply to hashicorp/terraform-provider-google#3404.

[ghost]

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.