How do I fix a postgres db (flexible) that is stuck in dropping state.

Hi MehdiDUJARDIN-2872

I kindly request you to please share the details requested in the private message for further investigation, which will help us to address the issue.

Hi MehdiDUJARDIN-2872

Greetings!

As we understand that, you are facing an issue with Azure Database for PostgreSQL – Flexible Server where the server becomes stuck in the "Stopping" state and is unresponsive to CLI or portal commands. 

Here are a few steps you might consider:

• Sometimes servers can take longer to stop due to ongoing processes. You might want to wait a little longer and check if the status changes.
• Go to the Azure portal and check the service health dashboard. There might be some ongoing issues affecting the PostgreSQL service in your region.
• If the server remains stuck, you could consider forcing a stop or restart. You can try using the Azure CLI with the --failover option to perform a forced operation: az postgres flexible-server restart --name <your-server-name> --resource-group <your-resource-group> --failover Forced
• Use the Azure Monitor logs to check for errors or blockers. Run the following to query logs:

DockerfileCopy

az monitor log-analytics query \

         --workspace <workspace-id> \

         --analytics-query "AzureDiagnostics | where ResourceId == '<server-resource-id>'"

• Confirm if the server has management locks that might be preventing the stop action using bash command: az resource lock list --resource-name <server-name> --resource-group <resource-group> --resource-type "Microsoft.DBforPostgreSQL/flexibleServers"
• Remove locks if present: az resource lock delete --ids <lock-id>
• If resource exhaustion is suspected, scale the server up temporarily using bash command: az postgres flexible-server update --name <server-name> --resource-group <resource-group> --sku-name GP_Gen5_4

If the above steps do not resolve the issue, could you please share the requested details via private message as it will help us conduct a more thorough investigation.

I hope this information helps. Please do let us know if you have any further queries

Hello,

it's been multiple days since it's in dropping state and every time I try to use an Azure CLI command the error is "Resource Not Found", even though the server appears when I list the Postgres server.

I am hitting the same issue. The database has been in the Dropping state for almost a whole day. When I try CLI commands I also get "Resource not found" even though it shows up in the portal. And when I try to recreate it, i get a "Resource already exists" error. So I am a bit stuck right now just waiting for the database to be deleted. I would really appreciate support on this issue since it seems like multiple people are hitting this recently.