Issues deleting Azure MySQL flexible server with “Updating” status

Question

My Azure MySQL flexible server is unresponsive and shows “Updating” status, which started a day ago.

It has been running for 10 months without issues.

The server stopped responding with the message “Attention: MySQL Flexible Server Burstable SKU credits are close to being fully utilized”.

I have tried to scale up the server, but it didn't complete the deployment process after several hours, so I canceled it.

I have attempted to restore, reboot, and even stop the server using the portal and Azure CLI, but these methods failed. I was then successful in creating a new DB server from a local backup.

Now, I'm trying to delete the original server, but it has been running for 4 hours and fails with the error message “An error occurred deleting MySQL server *-dbserver. Unknown error.”

I also tried the “az mysql flexible-server db delete ~” command on Azure CLI, but it remains stuck in an indefinite loop.

I attempted a two-step process: first deleting the database and then the server, but it is still stuck on the first phase.

Is there any method to resolve this issue?

Answer 1

Hi @Song Joon ,

It appears that you’ve exhausted all available options, including deleting from the portal, using command-line methods, and rebooting. However, it’s possible that a background process is causing the issue, and resolving it may necessitate intervention from the backend. I recommend opening a support case for a thorough investigation and expediting the resolution process.

If you encounter any challenges while opening the case or if you don’t have a support plan, feel free to reach out.

Thank You!

Answer 2

Hi , Welcome to MS Q&A ,

I would request you to follow steps to delete database , after deleting database try to delete server from the portal or CLI command

To delete a database

1.     In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

2.     Expand Databases, right-click the database to delete, and then select Delete.

3.     Confirm the correct database is selected, and then select OK.

or Using Transact-SQL

For more information, see DROP DATABASE (Transact-SQL).

To delete a database

1.     Connect to the Database Engine.

2.     From the Standard bar, select New Query.

3.     Copy and paste the following example into the query window and select Execute. This example removes the Sales and NewSales databases.

USE master ;

GO

DROP DATABASE Sales, NewSales ;

GO

Reference document- https://learn.microsoft.com/en-us/sql/relational-databases/databases/delete-a-database?view=sql-server-ver16

Kindly follow this and if any further query let me know , if it helps you please accept , Thanks!