Test failing for postgresql/mysql backup module examples.

[imrannayer]

TL;DR

Tests execute successfully but fails to delete infra after postgresql/mysql backup module

Expected behavior

No response

Observed behavior

TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: module.backup.google_storage_bucket_iam_member.sql_instance_account[0]: Destruction complete after 4s
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: 
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: Error: Error when reading or editing Job: googleapi: Error 409: sync mutate calls cannot be queued
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: Details:
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: [
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185:   {
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185:     "@type": "type.googleapis.com/google.rpc.ResourceInfo",
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185:     "resourceName": "projects/ci-sql-db-6627/locations/us-central1/jobs/sql-export-example-postgres-247ca22f"
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185:   }
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: ]
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: 
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: 
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: Error: Error when reading or editing Job: googleapi: Error 409: sync mutate calls cannot be queued
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: Details:
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: [
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185:   {
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185:     "@type": "type.googleapis.com/google.rpc.ResourceInfo",
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185:     "resourceName": "projects/ci-sql-db-6627/locations/us-central1/jobs/sql-backup-example-postgres-247ca22f"
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185:   }
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: ]
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z command.go:185: 
TestPostgresqlBackupModuleProvidedServiceAccount 2025-11-19T17:37:36Z retry.go:99: Returning due to fatal error: FatalError{Underlying: error while running command: exit status 1; 
Error: Error when reading or editing Job: googleapi: Error 409: sync mutate calls cannot be queued
Details:
[
  {
    "@type": "type.googleapis.com/google.rpc.ResourceInfo",
    "resourceName": "projects/ci-sql-db-6627/locations/us-central1/jobs/sql-export-example-postgres-247ca22f"
  }
]


Error: Error when reading or editing Job: googleapi: Error 409: sync mutate calls cannot be queued
Details:
[
  {
    "@type": "type.googleapis.com/google.rpc.ResourceInfo",
    "resourceName": "projects/ci-sql-db-6627/locations/us-central1/jobs/sql-backup-example-postgres-247ca22f"
  }
]
}
    destroy.go:11: 
        	Error Trace:	/builder/home/go/pkg/mod/github.com/gruntwork-io/terratest@v0.47.0/modules/terraform/destroy.go:11
        	            				/builder/home/go/pkg/mod/github.com/!google!cloud!platform/cloud-foundation-toolkit/infra/blueprint-test@v0.16.1/pkg/tft/terraform.go:528
        	            				/builder/home/go/pkg/mod/github.com/!google!cloud!platform/cloud-foundation-toolkit/infra/blueprint-test@v0.16.1/pkg/tft/terraform.go:646
        	            				/builder/home/go/pkg/mod/github.com/!google!cloud!platform/cloud-foundation-toolkit/infra/blueprint-test@v0.16.1/pkg/tft/terraform.go:667
        	            				/builder/home/go/pkg/mod/github.com/!google!cloud!platform/cloud-foundation-toolkit/infra/blueprint-test@v0.16.1/pkg/utils/stages.go:31
        	            				/builder/home/go/pkg/mod/github.com/!google!cloud!platform/cloud-foundation-toolkit/infra/blueprint-test@v0.16.1/pkg/tft/terraform.go:671
        	Error:      	Received unexpected error:
        	            	FatalError{Underlying: error while running command: exit status 1; 
        	            	Error: Error when reading or editing Job: googleapi: Error 409: sync mutate calls cannot be queued
        	            	Details:
        	            	[
        	            	  {
        	            	    "@type": "type.googleapis.com/google.rpc.ResourceInfo",
        	            	    "resourceName": "projects/ci-sql-db-6627/locations/us-central1/jobs/sql-export-example-postgres-247ca22f"
        	            	  }
        	            	]
        	            	
        	            	
        	            	Error: Error when reading or editing Job: googleapi: Error 409: sync mutate calls cannot be queued
        	            	Details:
        	            	[
        	            	  {
        	            	    "@type": "type.googleapis.com/google.rpc.ResourceInfo",
        	            	    "resourceName": "projects/ci-sql-db-6627/locations/us-central1/jobs/sql-backup-example-postgres-247ca22f"
        	            	  }
        	            	]
        	            	}
        	Test:       	TestPostgresqlBackupModuleProvidedServiceAccount
--- FAIL: TestPostgresqlBackupModuleProvidedServiceAccount (12.20s)

Terraform Configuration

execute postgresql/mysql backup examples

Terraform Version

NA

Terraform Provider Versions

NA

Additional information

No response