Multiple MySQL deployment failures with different errors

Question

Multiple (5-6) attempts to deploy at SQL server failed. Below is the summary of the last one. Nothing in the docs helped and everything in the deployment details was filled in and validated. Docs say to file a ticket on GitHub but I'm trying here first. This has been pretty time consuming so far. I hope someone can help. {"code":"DeploymentFailed","target":"/subscriptions/b0df765a-40e5-4215-ad97-223765c95588/resourceGroups/trial-resources/providers/Microsoft.Resources/deployments/Microsoft.Template-20240127203316","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/b0df765a-40e5-4215-ad97-223765c95588/resourceGroups/trial-resources/providers/Microsoft.DBforMySQL/flexibleServers/mysql-studio28-01","message":"The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'."}]}

Answer 1

Hi @bulkorders

Thanks for sharing subscription id. I can see two error in the backend log. 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 in that region.

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. Capacity needs to be granted to your subscription to create a server in those regions.

Please refer to the snippet below for guidance on opening a Quota case

2nd error, I can see is related to The standbyAvailabilityZone. If you are using any standbyAvailabilityZone, please try without AvailabilityZone.

Thank you!