[google-cloud-sql-discuss] Re: Why cannot we reuse CloudSQL instance name until a week after deletion?

Hello,

Thank you for your question. I was able to find the documentation that describes the error but I cannot find any public documentation that answers your question about that week.

409 - DUPLICATE

INSTANCE_ALREADY_EXISTS

The Cloud SQL instance already exists. When you delete an instance, you can't reuse the name of the deleted instance until one week from the deletion date.

It would be useful to have the reasoning available to the community but it may have been done on purpose to protect the inner workings of GCP infrastructure or process. I wanted you to know this.

To make sure, I went ahead and sent feedback to see if they may provide more detail. Ex. You want to know if reason is related to data retention.

You may follow the progress here on the public facing issue.  Please note that there is no guarantee that they may provide that information.

On Thursday, December 17, 2020 at 1:10:12 PM UTC-5 georgi....@siteground.com wrote:

It is mentioned in the docs that "You cannot reuse an instance name until a week after you have deleted the instance.", but I wonder why exactly there is such restriction for CloudSQL instances?

There is no such restriction on other resources (e.g. Compute engine, Filestore, Memorystore, Network services, etc.). It means I have to enumerate names in order to test building infrastructure with tools like Terraform, because otherwise an error is generated:

Error: Error, failed to create instance my-sql: googleapi: Error 409: The Cloud SQL instance already exists. When you delete an instance, you cannot reuse the name of the deleted instance until one week from the deletion date., instanceAlreadyExists

I'm just trying to understand the real reason(s) behind this restriction. Is it related to data retention just in case of something else?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/71990dc3-a770-4c8c-a2d8-a8550289816en%40googlegroups.com.