I can't restore mysql flexible server

崔 演友 21 Reputation points
2022-10-12T08:06:49.233+00:00

I'm testing whether it is possible to create mysql flexible server in East Japan and restore it to West Japan for BCP
I created mysql flexible server in East Japan.
and I try to restore mysql flexible server from east japan to west japan.
I referred to the fallowing page
https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-portal#geo-restore-to-latest-restore-point

but I got the following error. please let me know what's wrong
{"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: '28ec8fd7-1bdf-4630-b97a-df58b5ea9b77'"}]}

Correlation ID : fa56987f-e849-48e4-a539-31a9c5930adf

249577-asd01.png

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

Accepted answer
  1. ShaktiSingh-MSFT 14,481 Reputation points Microsoft Employee
    2022-10-13T07:38:19.487+00:00

    Hi @崔 演友 ,

    Thanks for your patience.

    For Internal Server Error it could be the capacity constraint which is of temporary nature.

    ERROR: [{'code':'InternalServerError','message':'An unexpected error occured while processing the request. Tracking ID: '9b9bfce3-f590-49af-90e1-a777596e5373''}]}

    Replace Timestamp, Subscription ID, Correlation ID or ServiceRequestID (Tracking ID from the Error message) and get the ASYNCID from the below queries
    (HttpOutgoingRequests and HttpIncomingRequests needs to be accessed from ARMProd)

    /Get ASYNC ID from the below - Replace Timestamp, Subscription ID, Correlation ID and get the asyncId from the below query.  
    HttpOutgoingRequests  
    | where (TIMESTAMP >= datetime(2021-07-07T20:45:58Z) and TIMESTAMP < datetime(2021-07-07T21:10:58Z))  
    | where subscriptionId =~ "customersubscriptionid"  
    | where serviceRequestId =~ '9b9bfce3-f590-49af-90e1-a777596e5373' //Tracking ID from Customer  
    //| where correlationId =~ "ab1ac73d-ed79-4650-8bb3-ffa29dbbaf45"  
    | where operationName contains "AZUREASYNCOPERATION"  
    | extend location = extract('locations/([a-z|A-Z|0-9|]+)', 1, targetUri, typeof(string))  
    | extend asyncId = extract('azureAsyncOperation/([a-z|A-Z|0-9|-]+)', 1, targetUri, typeof(string))  
    | where isnotempty( asyncId) //and location contains "AddRegionHere"  
    | project TIMESTAMP, correlationId, asyncId,TaskName, location, subscriptionId, operationName, targetUri, durationInMilliseconds,httpStatusCode,clientRequestId, exceptionMessage, errorCode, errorMessage  
    

    249988-image.png

    You can get the same information from below query also.

    //Get ASYNC ID from the below - Replace Timestamp, Subscription ID, Correlation ID and get the asyncId from the below query.  
    HttpIncomingRequests  
    | where (TIMESTAMP >= datetime(2021-07-07T20:45:58Z) and TIMESTAMP < datetime(2021-07-07T21:10:58Z))  
    | where subscriptionId =~ "customersubscriptionid"  
    | where serviceRequestId =~ '9b9bfce3-f590-49af-90e1-a777596e5373' //Tracking ID from Customer  
    //| where correlationId =~ "ab1ac73d-ed79-4650-8bb3-ffa29dbbaf45"  
    | where operationName contains "AZUREASYNCOPERATION"  
    | extend location = extract('locations/([a-z|A-Z|0-9|]+)', 1, targetUri, typeof(string))  
    | extend asyncId = extract('azureAsyncOperation/([a-z|A-Z|0-9|-]+)', 1, targetUri, typeof(string))  
    | where isnotempty( asyncId) //and location contains "AddRegionHere"  
    | project TIMESTAMP, correlationId, asyncId, location,TaskName, subscriptionId, operationName, targetUri, durationInMilliseconds,httpStatusCode,clientRequestId, exceptionMessage, errorCode, errorMessage  
    

    249976-image.png

    Provide the ASYNC ID from the step 1 in the below query in request_id column to find the operation parameters to get the details about the operation

    //Get the Operational Parameters for the server creation  
    MonOrcasBreadthRp  
    | where TIMESTAMP > ago(7d)  
    | where request_id =~ "838f778d-602e-4614-8066-f75487480f7c"  
    | where operation_parameters !=''  
    | project TIMESTAMP, operation_parameters  
    

    Using the query below you can find the exception messages. This query is helpful when investigating Capacity constraint issues.

    /Get the Error messages  
    MonOrcasBreadthRpExceptions  
    | where (TIMESTAMP >= datetime(2021-07-07T20:45:58Z) and TIMESTAMP < datetime(2021-07-07T21:10:58Z))  
    | where request_id =~ "f3b85aaf-8c21-4e8e-93d1-a5a251f7614a"      
    //| where message !contains "Finite State Machine [OrcasResourceSpecificationCreateOperation] with key" and message !contains "doesn\'t exist in the backing store"  
    | project TIMESTAMP, event, exception_type, message, stack_trace, level  
    

    It could be the region is constrained due to capacity temporarily.

    Hope this helps, please let us in case of further queries.

    0 comments No comments

0 additional answers

Sort by: Most helpful