Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
506 questions
Update MySQL Server Create - The resource operation completed with terminal provisioning state 'Failed'.
João Lopes
6
Reputation points
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": []
}
{count} vote
-
ShaktiSingh-MSFT 7,136 Reputation points Microsoft Employee2022-11-18T12:09:36.457+00:00 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.
-
ShaktiSingh-MSFT 7,136 Reputation points Microsoft Employee
2022-11-21T05:50:42.273+00:00 Hi @João Lopes ,
Just checking if the above suggestion helped. Let us know if you are still facing the issue.
-
Charles Chavez 1 Reputation point
2022-12-02T04:34:13.127+00:00 I am also seeing the same error here. I re-ran the deployment with just the mysql resource deployment:
Microsoft.DBforMySQL/flexibleServers - Conflict
{"code":"DeploymentFailed","message":"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage details.","details":[{"code":"InternalServerError","message":"An unexpected error occured while processing the request. Tracking ID: '7f492a36-6adf-4106-b2cb-3ab2c225ca0e'"}]}
Sign in to comment