mysql flexible server deployment (via portal) either hangs or fails

alex 106

The first attempt spent 17 hours in the "Accepted" state before being cancelled.

The third attempt failed with this:

{
  "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: '130fa5e9-f4c2-4e34-8f16-7e3b42291d81'"
    }
  ]
}

alex 106 Reputation points

2021-02-17T21:34:05.747+00:00

Azaure cli also failed. Can someone from Azure please look into this?

Thanks

69225-az-cli-mysql.log
Anurag Sharma 17,606 Reputation points

2021-02-18T06:14:02.983+00:00

Hi @alex , welcome to Microsoft QnA forum. Sorry for the trouble you have been facing.

Could you please tell us which region are you creating the resource in?

1 answer

Anurag Sharma 17,606 Reputation points

2021-02-18T06:47:35.847+00:00
Hi @alex , I faced similar issue when tried creating it through Azure Portal in East US region but worked fine with North Europe region. Also was able to do it with Azure CLI. Below is the command I used.

az mysql flexible-server create --location northeurope --resource-group xxxxxx --name xxxxxxx --admin-user xxxxxx \ --admin-password xxxxxx --sku-name Standard_D2ds_v4 --tier GeneralPurpose --public-access 0.0.0.0 \ --storage-size 32 --tags "key=value" --version 5.7

Can you please try this once and see if it works in other regions?

For the Azure Portal issue related to few regions I have escalated it to product group and will update here as soon as I get a reply back.
Please sign in to rate this answer.
alex 106 Reputation points

2021-02-18T15:56:47.907+00:00

Our region is eastus. As a test I can try another region assuming I don't have to recreate everything there, but ultimately it needs to work in eastus.

Could you please confirm that you can currently repro this for eastus and that it's being looked at. Any progress or ETA you could post would be helpful.

Anurag Sharma 17,606 Reputation points

2021-02-18T16:36:34.14+00:00

Hi @alex , thanks for replying back.

Yes I am able to repro it in East US region and escalated it to the product group and received a response back. They mentioned it is primarily related to capacity issue in this region which team is trying to resolve at the earliest on high priority and hopefully it shall be done within a week. Would it be possible to use another region for time being, meanwhile team is fixing the same in East US.

I will keep on checking the same with them and will be communicating at the earliest once this is fixed.

Apologies for the inconvenience.

alex 106 Reputation points

2021-02-19T15:45:38.337+00:00

When creation fails or is cancelled (after it hangs) it does not release the server name. Another attempt produces:

cli.azure.cli.core.azclierror: Specified server name is already used.

alex 106 Reputation points

2021-02-22T16:15:28.353+00:00

Could you please check on the status of this?

Anurag Sharma 17,606 Reputation points

2021-02-22T16:48:27.557+00:00

Hi @alex , I tried creating the Flexible server both from azure Portal as well as azure CLI in East US region and it worked.

Below is the azure CLI command I used:

az mysql flexible-server create --location eastus --resource-group xxxx --name xxxx --admin-user xxxx \ --admin-password xxxx --sku-name Standard_D2ds_v4 --tier GeneralPurpose --public-access 0.0.0.0 \ --storage-size 32 --tags "key=value" --version 5.7

Could you please give it a try and let us know?

Also if this works, please mark it as 'Accept Answer' as this could help others who might have faced same issue with East US region recently.

alex 106 Reputation points

2021-02-22T17:01:42.583+00:00

Did the product say they fixed it?

The following has been running for more than half an hour, so I would say it's hung, same as before. To be sure, I'll leave it running indefinitely. The async operation it's polling is 9bc0e7df-3c41-42c0-8464-26dedb2f6b02 Presumably somebody at azure should be able to look it up.

az mysql flexible-server create \ --subscription xxxxx \ --resource-group xxxxx \ --admin-user xxxxx \ --admin-password xxxxx \ --backup-retention 30 \ --high-availability Enabled \ --name xxxxx \ --sku-name Standard_D2ds_v4 \ --storage-size 100 \ --subnet xxxxx \ --tier GeneralPurpose \ --version 5.7 \ --vnet xxxxx \ --location eastus \ --debug

Anurag Sharma 17,606 Reputation points

2021-02-22T17:59:19.46+00:00

Hi @alex , I still have to receive a reply back from product team but the command provided by you worked. It took close to 20-25 mins but got succeeded. Creation of vnet and subnet take some time.

I would suggest if you could wait a little longer and see if it succeeds or fails. If not then we might need to reach out to support team.

Please let us know in any case.

alex 106 Reputation points

2021-02-22T18:25:13.383+00:00

It has been running for ~ 2 hours now, so hung. Again the operation id is 9bc0e7df-3c41-42c0-8464-26dedb2f6b02

Why can't product or whoever check on this operation and find out what it's doing and where it's hanging? The reason for giving these things a guid that's logged client-side is presumably to be able to do just that.

Anurag Sharma 17,606 Reputation points

2021-02-23T06:18:21.347+00:00

Hi @alex , sorry to hear that. I think the problem here is Flexible Server is still in preview as of now and we could see the compute issues sometimes on few regions. Once it goes to GA, these things don't occur. However I have escalated the same to product team with the operation id you provided.

Anurag Sharma 17,606 Reputation points

2021-02-24T07:01:34.753+00:00

Hi @alex , thanks for your patience. As per product team, its better if we raise the support ticket for this as others are able to create the service now. Please let us know if you need any help with that.

Anurag Sharma 17,606 Reputation points

2021-02-25T09:48:20.513+00:00

Hi @alex , just wanted to check if you were able to raise the support ticket.

alex 106 Reputation points

2021-02-25T15:54:23.763+00:00

Yes, have a ticket.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

mysql flexible server deployment (via portal) either hangs or fails

1 answer

Your answer