Mysql database has gone into inaccessible state

wi77iam 0 Reputation points
2023-05-23T20:11:34.8233333+00:00

The server has gone down unexpectedly.

On the resource page I can see this message

"The server is currently in inaccessible state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long."

This has been going on for over 24h and no indication of what is happening.

Starting the instance will result in an error due to the status of the server

Screenshot 2023-05-23 210624

I've tried restoring into a new instance but it won't allow me indicating that the server is in that state.

Screenshot 2023-05-23 211059

Troubleshooting points at the resource health page which doesn't find anything wrong with it.

Screenshot 2023-05-23 210448

There's nothing on the activity log that might suggest a change.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
    2023-05-24T11:48:46.0333333+00:00

    Hi @wi77iam Welcome to the Microsoft Q&A platform, thanks for posting the question and for using Azure Services.

    If the server is configured for CMK (Byok) and the server is inaccessible, then it means the access to the key vault is lost. I would check the CMK \AKV configuration and revalidate it to make sure the server is back to a ready state.

     Data encryption with customer managed keys – Azure Database for MySQL – Flexible Server | Microsoft Learn

    Set data encryption for Azure Database for MySQL - Flexible Server by using the Azure portal | Microsoft Learn

    Please let me know if this helps

    Regards

    Geetha