How to fix error "The resource write operation failed to complete successfully, because it reached terminal provisioning state Failed" while creating Azure Mysql Flexible server

Rohith 20

Hi Team, I am getting below error when i try to create Azure Database for MySQL servers.

{
    "status": "Failed",
    "error": {
        "code": "InternalServerError",
        "message": "An unexpected error occured while processing the request. Tracking ID: 'b4cb0b51-510c-4edb-89d2-dfe9bf49765d'"
    }
}

Accepted answer

Rahul Randive 8,751 Reputation points Microsoft Employee

2024-02-28T12:37:03.85+00:00

Hi @Rohith
Thanks for sharing tracking id. According to the backend log, it appears that you are attempting to create a server in the East US region and encountering a failure due to a Quota issue.

If possible, you can try creating the server in another region.

Alternatively, if you prefer to create the server in the same region, you may need to open a support case to request additional capacity for server creation in your subscription.

Thank you!
Please sign in to rate this answer.

1 person found this answer helpful.
Rohith 20 Reputation points

2024-02-28T13:06:03.0266667+00:00

Thankyou it worked.

Rahul Randive 8,751 Reputation points Microsoft Employee

2024-02-28T13:25:03.8266667+00:00

Awesome! Glad it worked. Thanks for an update and visiting Microsoft Q&A.
Sign in to comment

1 additional answer

TP 78,976 Reputation points

2024-02-28T12:06:35.5833333+00:00

Hello,

Have you tried deleting any related resource(s) that may have been created in the resource group and then tried to create it again from scratch? Sometimes when you get a failure like that if you try it again a few minutes later it will succeed.

-TP
Please sign in to rate this answer.
Rohith 20 Reputation points

2024-02-28T12:11:05.86+00:00

I have created Mysql in new resource group then also getting same error.

Rohith 20 Reputation points

2024-02-28T12:12:39.3733333+00:00

I tried multiple times with new resource group. getting same error each time.

TP 78,976 Reputation points

2024-02-28T12:15:40.6966667+00:00

which Azure region are you deploying to, and which SKU? I'll test and see if I can successfully create one

Rohith 20 Reputation points

2024-02-28T12:21:19.99+00:00

Region: East US SKU :
General Purpose, D8ads_v5, 8 vCores, 32 GiB RAM, 50 storage, Auto scale

TP 78,976 Reputation points

2024-02-28T12:54:27.4033333+00:00

I successfully deployed same SKU as you specified (with no HA, no Geo-redundancy) as well as default Standard_B1ms SKU, both to East US.

No issues with your SKU, however, when I created default instance using powershell command it did throw some errors (normally there are no errors). The database did successfully create, so unsure why these errors occurred, see below:

$dbmySqlEastus = New-AzMySqlFlexibleServer -Location eastus Creating Resource Group group8139964530... Creating MySQL server server1294678112 in group group8139964530... Your server server1294678112 is using sku Standard_B1ms (Paid Tier). Please refer to https://aka.ms/mysql-pricing for pricing details New-AzMySqlFlexibleServer_CreateExpanded: /usr/local/share/powershell/Modules/Az.MySql/1.1.1/custom/New-AzMySqlFlexibleServer.ps1:377 Line | 377 | $Server = Az.MySql.internal\New-AzMySqlFlexibleServer @PSBoun … | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | The requested resource of type 'Microsoft.DBforMySQL/flexibleServers' with name 'server1294678112' was not found. Creating database flexibleserverdb... InvalidOperation: /usr/local/share/powershell/Modules/Az.MySql/1.1.1/custom/New-AzMySqlFlexibleServer.ps1:392 Line | 392 | $Server.DatabaseName = $DEFAULT_DB_NAME | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | The property 'DatabaseName' cannot be found on this object. Verify that the property exists and can be set.

I recommend you create a new Technical support case so that a support engineer can investigate why your deployment is failing. You can provide them with Tracking IDs to help them.

TP 78,976 Reputation points

2024-02-28T13:05:04.6266667+00:00

@Rohith Looks like @Rahul Randive has the explanation below. Recommend you create new quota support request
Sign in to comment

Share via

How to fix error "The resource write operation failed to complete successfully, because it reached terminal provisioning state Failed" while creating Azure Mysql Flexible server

1 additional answer