(InternalServerError) An unexpected error occured while processing the request

chaowen guo 16 Reputation points
2021-08-19T09:22:16.117+00:00

I try to use azure cli to create mysql flexible server

I use the following commands:

az group create -n mysql -l westus
az mysql flexible-server create -n mysqlsql -g mysql -l westus -u mysqlsqlmy -p my1sql+my -d mysql --public-access all --tier Burstable --sku-name Standard_B1ms --storage-size 32 --version 8.0.21

then I get (InternalServerError) An unexpected error occured while processing the request

the full output is:
Command group 'mysql flexible-server' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Checking the existence of the resource group 'mysql'...
Resource group 'mysql' exists ? : True
IOPS is 396 which is either your input or free(maximum) IOPS supported for your storage size and SKU.
Creating MySQL Server 'mysqlsql' in group 'mysql'...
Your server 'mysqlsql' is using sku 'Standard_B1ms' (Paid Tier). Please refer to https://aka.ms/mysql-pricing for pricing details
Configuring server firewall rule to accept connections from '0.0.0.0' to '255.255.255.255'...
Creating MySQL database 'mysql'...
(InternalServerError) An unexpected error occured while processing the request. Tracking ID: 'bc44fc6f-f193-4efc-9448-f9b798b0b4e3'

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

1 answer

Sort by: Most helpful
  1. Oury Ba-MSFT 19,421 Reputation points Microsoft Employee
    2021-08-30T17:33:24.413+00:00

    Hi @chaowen guo Thank you for being patient while working on this issue. Our PG team has discovered that the create server operation was interrupted by drop server operation, you created mysql flexible server at 2021-08-19 09:09:11 and drop server at 2021-08-19 09:11:58, the create server operation failed because the server's dropped with error message : "The operation on the resource could not be completed because it was interrupted by another operation on the same resource."

    Please try to recreate the db and let us know if you are still facing the same issue.

    Regards,
    Oury


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.