google_sql_database.users: operationInProgress error on terraform apply

[ghost]

This issue was originally opened by @maryamklabib as hashicorp/terraform#9018. It was migrated here as a result of the provider split. The original body of the issue is below.

---

Hi there,

We're seeing google_sql_database.users: Error, failed to insert database [name] into instance [name]: googleapi: Error 403: Operation failed because another operation was already in progress., operationInProgress very frequently but not always. We see it only on google_sql_database.users, but terraform applying other resources reliably works.

Terraform Version

Terraform v0.7.4

Affected Resource(s)

• google_sql_database.users

Terraform Configuration Files

resource "google_sql_database_instance" "master" {
  region = "${var.sql_region}"
  settings {
    tier = "${var.google_sql_db_tier}"
   }

  count = "${var.google_sql_instance_count}"
}

resource "google_sql_database" "users" {
  name = "${var.env_name}-db"
  instance = "${google_sql_database_instance.master.name}"

  count = "${var.google_sql_instance_count}"
}

resource "google_sql_user" "users" {
  name = "${var.google_sql_db_username}"
  password = "${var.google_sql_db_password}"
  instance = "${google_sql_database_instance.master.name}"
  host     = "${var.google_sql_db_host}"

  count = "${var.google_sql_instance_count}"
}

Debug Output

https://gist.github.com/maryamklabib/5681f634691f2e09782df962cf016ce8

Steps to Reproduce

1. terraform apply

Important Factoids

We're creating First Generation GoogleSQL users

[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 feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!