Error when setting custom `database_instance_tier` value

[udit-001]

I encounter the following error when trying to use a custom database_instance_tier for a Cloud SQL instance with the ENTERPRISE edition:

Configuration snippet

database_instance_tier    = "db-custom-2-4096"
database_instance_edition = "ENTERPRISE"

Error Message

╷
│ Error: Error, failed to update instance settings for : googleapi: Error 400: Invalid request: The number of transaction log retention days must be between 1 and 7., invalid
│ 
│   with module.langfuse.google_sql_database_instance.this,
│   on .terraform/modules/langfuse/postgres.tf line 1, in resource 'google_sql_database_instance' 'this':
│    1: resource "google_sql_database_instance" 'this' {
│ 
╵

Any guidance on resolving this or clarifying constraints for db-custom-* tiers with the ENTERPRISE edition would be appreciated.

[Steffen911]

@udit-001 Thank you for the report. Could you share which version of the google provider you're using? We don't explicitly set this property and my understanding from https://registry.terraform.io/providers/hashicorp/google/latest/docs/resources/sql_database_instance#transaction_log_retention_days-1 is that it should be optional.

[udit-001]

Hi @Steffen911
Here is the content of the versions.tf file:

terraform {
  required_version = ">= 1.0"

  required_providers {
    google = {
      source  = "hashicorp/google"
      version = "~> 6.0"
    }

    random = {
      source  = "hashicorp/random"
      version = "~> 3.0"
    }

    tls = {
      source  = "hashicorp/tls"
      version = "~> 4.0"
    }

    kubernetes = {
      source  = "hashicorp/kubernetes"
      version = "~> 2.0"
    }

    helm = {
      source  = "hashicorp/helm"
      version = "~> 2.0"
    }
  }
}

[Steffen911]

Could you share the output of the terraform plan for the google_sql_database_instance resource?