customize deletion_policy

[lucas-seismic]

TL;DR

hashicorp/terraform-provider-google-beta#4972

# google_sql_database.database will be updated in-place
  ~ resource "google_sql_database" "database" {
      ~ deletion_policy = "ABANDON" -> "DELETE"
        id              = "projects/graphite-test-rileykarson/instances/myinstance/databases/mydb"
        name            = "mydb"
        # (5 unchanged attributes hidden)
    }

The deletion_policy change has 2 implicit steps as follows:

1. ALTER DATABASE [library-main] SET single WITH NO_WAIT.
2. ALTER DATABASE [library-main] SET multi_user WITH NO_WAIT.

In our production, there is an exception after the first step and the database access mode wasn't changed back, so all of the services can't connect to the DB anymore.

Could we expose the deletion_policy as a variable in this module? so we can give it a stable value

Terraform Resources

No response

Detailed design

No response

Additional information

No response

[saez0pub]

Hello,

I'm also facing this issue 👍
It seems solved for postgresql by 8ab6e37 but not released
Is a released planned soon ?

[g-awmalik]

Yes this seems to have been address by #386 and should be available with v14.0. Keep an eye on this: #380. Closing this now.