Recreating a deleted Postgres flexible server returns Internal Server Error

Paul Toft Duizer 20 Reputation points
2024-09-02T12:47:45.9533333+00:00

When trying to create a Postgres flexible server, a "Conflict" is returned with the error: {"code":"InternalServerError","message":"An unexpected error occured while processing the request. Tracking ID: '87e5916a-efa2-4959-b56e-793a3e81232c'"}

The resource has been created before with the same name and was deleted along with the entire resource group on July 11th. Is there any way of checking deleted Postgres flexible servers and potentially do a purge/force remove?

I have tried to create the server using the Portal, the same error happens. Below is the Bicep-code for the Postgres flexible server - this is part of a larger template and the location is "North Europe".

resource postgresql 'Microsoft.DBforPostgreSQL/flexibleServers@2021-06-01' = {
  name: dbServerName
  location: location
  sku: {
    name: 'Standard_B1ms'
    tier: 'Burstable'
  }
  properties: {
    version: '11'
    administratorLogin: dbAdministratorLogin
    administratorLoginPassword: dbAdministratorLoginPassword
    highAvailability: {
      mode: 'Disabled'
    }
    storage: {
      storageSizeGB: 64
    }
    backup: {
      backupRetentionDays: 7
      geoRedundantBackup: 'Disabled'
    }
  }
}
Azure Database for PostgreSQL
{count} votes

Accepted answer
  1. RahulRandive 9,506 Reputation points
    2024-09-02T13:17:17.1266667+00:00

    Hi @Paul Toft Duizer

    When the server is dropped, the server name is released and can be used by anyone during the gap between dropping and creating the server. A potential issue arises if another customer takes the server name, which can cause problems.

    Azure PostgreSQL Flexible Server does not guarantee that a customer will be able to reuse the same name once a resource has been dropped, as the name can be taken by any other customer.

    You may need to use a different name or try in a different region. If you still require the same name, you need to open a support ticket to check the backend logs or as requested to potentially do a purge/force remove.

    Thank You!


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.