Update MySQL Server Create - The resource operation completed with terminal provisioning state 'Failed'.

Question

Trying to restore a backup from Azure Database for MySQL flexible server always fail with this generic error, anyone has a clue ?
Operation name Update MySQL Server Create
Time stamp Fri Nov 18 2022 07:19:08 GMT+0000 (Western European Standard Time)
Event initiated by joao.lopes@Stuff .com
Error code ResourceOperationFailure
Message The resource operation completed with terminal provisioning state 'Failed'.

{
"authorization": {
"action": "Microsoft.DBforMySQL/flexibleServers/write",
"scope": "/subscriptions/9587f94f-9917-4a27-bcb9-560610af1730/resourcegroups/gngdata/providers/Microsoft.DBforMySQL/flexibleServers/gngbackup"
},
"caller": "joao.lopes@Stuff .com",
"channels": "Operation",
"claims": {
"aud": "https://management.core.windows.net/",
"iss": "https://sts.windows.net/41bcb72d-c1e9-42e2-b451-eaded8635d70/",
"iat": "1668754177",
"nbf": "1668754177",
"exp": "1668759554",
"http://schemas.microsoft.com/claims/authnclassreference": "1",
"aio": "AUQAu/8TAAAAgzgHaemJmCChyQPfoxbfK0vEd4o8pCZvqkN8kyNkje/ROABfpJtFc8R9NFOBcG09EVKENB/brXdjBhLFL86JmA==",
"altsecid": "1:live.com:0003BFFD85DF8109",
"http://schemas.microsoft.com/claims/authnmethodsreferences": "pwd",
"appid": "c44b4083-3bb0-49c1-b47d-974e53cbdf3c",
"appidacr": "2",
"http://schemas.xmlsoap.org/ws/2005/05/identity/claims/emailaddress": "joao.lopes@Stuff .com",
"http://schemas.xmlsoap.org/ws/2005/05/identity/claims/surname": "Lopes",
"http://schemas.xmlsoap.org/ws/2005/05/identity/claims/givenname": "João",
"groups": "350b8f82-aa05-478a-94a2-8bcb109700c8",
"http://schemas.microsoft.com/identity/claims/identityprovider": "live.com",
"ipaddr": "148.71.96.90",
"name": "joao.lopes",
"http://schemas.microsoft.com/identity/claims/objectidentifier": "c0cb2b3a-96d3-4211-9487-600c6efa67b9",
"puid": "10032001FF99481D",
"rh": "0.ATsALbe8QenB4kK0Uere2GNdcEZIf3kAutdPukPawfj2MBM7AEo.",
"http://schemas.microsoft.com/identity/claims/scope": "user_impersonation",
"http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier": "-iCRBHKbh-Nh8t9me66-rj0T2cmv1KdvlD0c5QKkFrw",
"http://schemas.microsoft.com/identity/claims/tenantid": "41bcb72d-c1e9-42e2-b451-eaded8635d70",
"http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name": "live.com#joao.lopes@Stuff .com",
"uti": "86jxOZTRAkuL68R2u8dEAA",
"ver": "1.0",
"xms_tcdt": "1318047689"
},
"correlationId": "c45f3cd1-497c-4370-80bb-0eb5514eaf66",
"description": "",
"eventDataId": "c1596eb3-caba-4454-898a-06da53a4e61b",
"eventName": {
"value": "EndRequest",
"localizedValue": "End request"
},
"category": {
"value": "Administrative",
"localizedValue": "Administrative"
},
"eventTimestamp": "2022-11-18T07:19:08.9596851Z",
"id": "/subscriptions/9587f94f-9917-4a27-bcb9-560610af1730/resourcegroups/gngdata/providers/Microsoft.DBforMySQL/flexibleServers/gngbackup/events/c1596eb3-caba-4454-898a-06da53a4e61b/ticks/638043527489596851",
"level": "Error",
"operationId": "e0fb34d9-46e8-48fb-8c8b-a88d594447dd",
"operationName": {
"value": "Microsoft.DBforMySQL/flexibleServers/write",
"localizedValue": "Create/Update MySQL Server"
},
"resourceGroupName": "gngdata",
"resourceProviderName": {
"value": "Microsoft.DBforMySQL",
"localizedValue": "Microsoft.DBforMySQL"
},
"resourceType": {
"value": "Microsoft.DBforMySQL/flexibleServers",
"localizedValue": "Microsoft.DBforMySQL/flexibleServers"
},
"resourceId": "/subscriptions/9587f94f-9917-4a27-bcb9-560610af1730/resourcegroups/gngdata/providers/Microsoft.DBforMySQL/flexibleServers/gngbackup",
"status": {
"value": "Failed",
"localizedValue": "Failed"
},
"subStatus": {
"value": "",
"localizedValue": ""
},
"submissionTimestamp": "2022-11-18T07:20:59.1144641Z",
"subscriptionId": "9587f94f-9917-4a27-bcb9-560610af1730",
"tenantId": "41bcb72d-c1e9-42e2-b451-eaded8635d70",
"properties": {
"statusMessage": "{\"status\":\"Failed\",\"error\":{\"code\":\"ResourceOperationFailure\",\"message\":\"The resource operation completed with terminal provisioning state 'Failed'.\",\"details\":[{\"code\":\"InternalServerError\",\"message\":\"An unexpected error occured while processing the request. Tracking ID: 'cfe1c67b-324e-48aa-be96-caf3c4d4df78'\"}]}}",
"eventCategory": "Administrative",
"entity": "/subscriptions/9587f94f-9917-4a27-bcb9-560610af1730/resourcegroups/gngdata/providers/Microsoft.DBforMySQL/flexibleServers/gngbackup",
"message": "Microsoft.DBforMySQL/flexibleServers/write",
"hierarchy": "41bcb72d-c1e9-42e2-b451-eaded8635d70/9587f94f-9917-4a27-bcb9-560610af1730"
},
"relatedEvents": []
}

Answer 1

Hi @João Lopes ,

Welcome to Microsoft Q&A platform.

Thanks for reaching out and apology for the inconvenience caused due to this issue
As I understand from the error, The resource operation completed with terminal provisioning state 'Failed'

This might be caused as there was another operation that was performed during that time which results in conflict error. Could you please check and let us know.

Also, please tell if this operation is performed through portal or CLI.

Answer 2

I am also experience the same error, deploy Azure MySQL 8.0 Flexible Server

{
  "code": "DeploymentFailed",
  "target": "/subscriptions/xxx/resourceGroups/rg_sea_xxx/providers/Microsoft.Resources/deployments/MySqlFlexibleServer_xxx",
  "message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.",
  "details": [
    {
      "code": "ResourceDeploymentFailure",
      "target": "/subscriptions/xxx/resourceGroups/rg_sea_xxx/providers/Microsoft.DBforMySQL/flexibleServers/db-xxx-mysql-80-prod",
      "message": "The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'."
    }
  ]
}

Answer 3

I had same error, for me what helped was reviewing the storage size. I had set fixed storage in octopus via variable that was lower then minimum allowed for given sku tier and name. If you check that from azure portal and try to modify that it will complain and need to adjust. After this deployment was successful.