Azure Database for PostgreSQL flexible server stuck in restart state

Question

Azure Database for PostgreSQL flexible server stuck in restart state

Cosmin Ardeleanu 5

I have restarted an Azure Database for PostgreSQL flexible server and is now stuck in Restarting state for a few hours, but the server is accessible. Of course I cannot manage it since Azure doesn't think this is running. Anyone encountered anything like this? I tried PS to restart/stop/start getting InternalServerError

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2024-03-01T16:30:35.1666667+00:00

Hi, @Cosmin Ardeleanu Welcome to Microsoft Q&A thanks for posting your question.

I suggest checking the Azure portal to see if server is still in the "Restarting" state. If it is, wait for a few more hours to see if it completes the restart process. If the server is still stuck in the "Restarting" state, try restarting it again using the Azure portal or Azure CLI.

If you still having the same issue, please send an email to AzCommunity[at]Microsoft[dot]com with the below details, to understand more about your use case.

Email subject: <Attn - Geetha : Microsoft Q&A Thread title>

Thread URL: <Microsoft Q&A Thread>

Subscription ID: <your subscription id>

Looking forward to your reply.

Regards

Geetha
Cosmin Ardeleanu 5 Reputation points

2024-03-04T09:12:07.57+00:00

Still restarting after 3 days. Will do, thanks.

1 answer

Your answer

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2024-03-01T16:30:35.1666667+00:00

Hi, @Cosmin Ardeleanu Welcome to Microsoft Q&A thanks for posting your question.

I suggest checking the Azure portal to see if server is still in the "Restarting" state. If it is, wait for a few more hours to see if it completes the restart process. If the server is still stuck in the "Restarting" state, try restarting it again using the Azure portal or Azure CLI.

If you still having the same issue, please send an email to AzCommunity[at]Microsoft[dot]com with the below details, to understand more about your use case.

Email subject: <Attn - Geetha : Microsoft Q&A Thread title>

Thread URL: <Microsoft Q&A Thread>

Subscription ID: <your subscription id>

Looking forward to your reply.

Regards

Geetha
Cosmin Ardeleanu 5 Reputation points

2024-03-04T09:12:07.57+00:00

Still restarting after 3 days. Will do, thanks.

Answer 1

RahulRandive 10,486 Volunteer Moderator

Hi @Cosmin Ardeleanu

What causes long recovery on Azure Database for PostgreSQL Recent checkpoints are critical for fast server recovery. Once a restart happens, either it was a new instance (failover to healthy instance) or same instance (in-place restart) will connect to disk that has all logs, all WAL logs after the last successful checkpoint need to be applied to the data pages before the server starts to accept connections again.

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.

I hope your server is back online now. If not, you'll need to open a support case to get it back online.

Thank You!

Cosmin Ardeleanu 5 Reputation points

2024-03-04T09:10:56.7+00:00

Is still in restart state, this is extremely concerning since as I said the server works, we can connect to it, run queries etc. I closed all active active sessions (except the one I was running that query) and still nothing. So seems Azure lost connection with it since not even PS scripts can't do anything on this instance.
RahulRandive 10,486 Reputation points Volunteer Moderator

2024-03-05T12:21:04.7133333+00:00

Hi Cosmin Ardeleanu

I'm sorry to hear that. You may need to open a support case to check the backend logs, assess the server's health, and take necessary actions for mitigation.

Thank you!

Share via

Azure Database for PostgreSQL flexible server stuck in restart state

1 answer

Your answer