Azure PostgreSQL Flexible Server Stuck in Restarting State from past 3 hours.

Question

Azure PostgreSQL Flexible Server has been stuck in the "restarting" state for the past 3 hours. I am unable to connect to the server or make any changes. The logs show that storage utilization is at 100%. Since I can't access the server, I'm also unable to increase the storage space.

Can anyone help me with this? How can I get the server back to the "started" state?

Answer 1

Hi Saurabh Gupta (Quadrant Resource),

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

We would like to inform you that, if your Azure PostgreSQL Flexible Server is stuck in the "restarting" state and storage utilization is at 100%, it's likely that the server is unable to complete the restart due to lack of space.

Another reason would be long running transactions are queries that are running for too long which impact database performance and can potentially cause issues during restarts. If it is an intermittent issue, it can get fixed by own.

Please find the troubleshooting steps below to help resolve the issue:

• Sometimes, the server might need more time to complete the restart process. Wait for a few more hours and then try restarting it again using the Azure portal or Azure CLI.
• Since the portal may not allow changes while the server is restarting, try increasing the storage via Azure CLI. Increase storage beyond 100% usage (e.g., if it was 100GB, try setting it to 120GB).
• Check if auto-growth is enabled, Azure might be attempting to allocate more space automatically. You can check this in the Azure portal under Storage Configuration.
• If storage was increased, restart the server via Azure CLI.

    az postgres flexible-server restart --resource-group <your-resource-group> --name <your-server-name>
  

Please find the below mentioned links for more information.

https://techcommunity.microsoft.com/blog/adforpostgresql/why-restarting-azure-database-for-postgresql-took-long/1885780

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-server-cli#scale-compute-and-storage

https://docs.azure.cn/en-us/postgresql/flexible-server/how-to-restart-server-cli#restart-a-server

If the issue still persists, please let us know here. We will respond with more details and try to help you.

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Hi, got internal support from Microsoft team and issue has been resolved. The issue was that storage reached 100% so while restarting it was not having enough space to restart the server.