How to fix MySql Flexible Server- The server is currently in updating state. Please wait for the operation to complete.

Tawfeeq Jamal 5 Reputation points
2023-08-10T21:20:35.0333333+00:00

Hi.

MySql Flexible server is stuck in an updating state for over an hour. i have tried to stop and restart via Azure CLI and still not successful. any suggestions?

Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
768 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,408 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
986 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
    2023-08-14T19:57:04.2733333+00:00

    Tawfeeq Jamal

    Thank you for confirming issue is now working by deleting the MySql flexible server service and creating a new service.

    This is sometimes an intermittent issue or a portal issue. You just need to wait or recreate a new one after sometimes.

    Regards,

    Oury

    0 comments No comments

  2. Steven R 1 Reputation point
    2023-08-22T19:56:22.6033333+00:00

    We have a rarely used DB that I had to touch today and saw the same thing 'server is currently in updating state'.

    This DB hasn't been touched in 8 months and it isn't very large.

    A peer suggest we run this

    select current_timestamp-query_start, * from pg_stat_activity where state='active' order by 1 desc

    It yielded:

    User's image

    User's image

    If I am interpreting correctly, it looks like a replication has been running for 11 days.

    Interestingly, that would put it at about the same date as the initial post (Aug 10)


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.