Error creating a Flexible Postgres Database in Azure

Question

Getting this error when creating the database trough the Azure portal in south central US

{
    "status": "Failed",
    "error": {
        "code": "InternalServerError",
        "message": "An unexpected error occured while processing the request. Tracking ID: '02adf56b-0ef6-4fd7-9121-de2c631f28fa'"
    }
}

Answer 1

Hi @Juan Ribon ,

Thanks for sharing the tracking id. Based on tracking id, I have checked the backend log to find the root cause of the failure and here is the error

Allocation failed. We do not have sufficient capacity for the requested VM size in this zone. Read more about improving likelihood of allocation success at http://aka.ms/allocation-guidance

Kindly check the mention document and retry the operation or if the region is not constrained, then create the server in other region.

Let us know if you have any question.

Thank You!

Answer 2

Hello @Juan Ribon

Welcome to Microsoft QnA!

have you validated your demands vs the support Matrix;

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview#azure-regions

Please have a good look and see whether your setup is supported ( e.g High availability !

I can see a Conflict message

Please go to the Service selection and see if you have a Menu [Manage deleted resources]

Check if you have a deleted resource , and purge it

Also have a look :https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/quickstart-create-server-arm-template?tabs=portal%2Cazure-portal

---

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards