Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,405 questions
Azure Postgresql Scheduled Maintenance stuck
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bho
5
Reputation points
I have a flexible server (Burstable, B1ms, 1 vCores, 2 GiB RAM, 32 GiB storage). I have received 18 health events over the course of two days, relating to Scheduled Maintenance. Attempts to e.g. restart the server have resultet in "Unknown error".
Azure Database for PostgreSQL
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani 2,985 Reputation points Microsoft External Staff Moderator2024-10-28T12:17:20.1533333+00:00 Hi @bho,
Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.
We apologize for the inconvenience caused.
As we understand that, you are trying to restart the server but unable to do it. server will be currently undergoing maintenance and is not available for restart. In this case, you should wait until the maintenance is complete before attempting to restart the server.
You can try the below mentioned steps to check the status of server.
1.Open a command prompt or terminal window.
2.Log in to your Azure account using the 'az login' command.
3.Run the following command to check the status of your PostgreSQL server:
az postgres flexible-server show --resource-group <resource-group-name> --name <server-name>
I would request you to refer the below mentioned link.
https://learn.microsoft.com/en-us/cli/azure/postgres/flexible-server?view=azure-cli-latest
Replace <resource-group-name> and <server-name> with the appropriate values for your environment. This command returns the current state of the server, which can be one of the following values:
Ready: The server is running and ready to accept connections.
Creating: The server is being created.
Updating: The server is being updated.
Deleting: The server is being deleted.
Failed: The server has encountered an error and cannot be started.
You can use the above-mentioned command to check the status of your server and ensure that it is running correctly. If the server is in a failed state, you may need to troubleshoot the issue.
If this does not help, If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan please let us know here.
I hope this information helps. Please do let us know if you have any further queries.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 73%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Cade 0 Reputation points2024-10-28T22:03:32.3966667+00:00 @Vijayalaxmi Kattimani
I am having a similar issue, my service went into maintenance and it has been stuck in maintenance for 3 days now.Pricing tier
Burstable
Compute size
Standard_B1ms (1 vCore, 2 GiB memory, 640 max iops)
Storage
32 GiB
The only thing I can see it changed was my properties.highAvailability.state from "NotAvailable" to "" and it cannot list the database(s) that should be under it.
az postgres flexible-server show:
"highAvailability": { "mode": "Disabled", "standbyAvailabilityZone": null, "state": "" },Trying to list the databases:
"error": { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID: ''" } -
Vijayalaxmi Kattimani 2,985 Reputation points Microsoft External Staff Moderator
2024-10-29T14:39:26.12+00:00 Hi @Cade,
Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.
We apologize for the inconvenience caused.
Are you saying the server has been in a restarting state for 3 days. Do you see any health events? A portal screenshot or any additional details would be helpful.
Meanwhile, I would request you to check CPU utilization for Azure Database for PostgreSQL - Flexible Server, you can use the Azure portal
Check CPU utilization using the Azure portal:
Go to the Azure portal and navigate to your Azure Database for PostgreSQL - Flexible Server instance.
1. Click on the 'Metrics' tab in the left-hand menu.
2. Select 'CPU usage' from the list of available metrics.
3. Choose the time range for which you want to view the CPU utilization data.
4. Review the graph to see the CPU utilization over time.
If this does not help, If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan please let us know here.
I hope this information helps. Please do let us know if you have any further queries.
-
Vijayalaxmi Kattimani 2,985 Reputation points Microsoft External Staff Moderator
2024-10-29T15:20:04.1233333+00:00 Hi @bho,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Vijayalaxmi Kattimani 2,985 Reputation points Microsoft External Staff Moderator
2024-10-30T13:43:19.09+00:00 Hi @bho,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer