question

chaowenguo-9404 avatar image
0 Votes"
chaowenguo-9404 asked OuryBa-MSFT commented

(InternalServerError) An unexpected error occured while processing the request

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-mysql
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @chaowenguo-9404 Sorry to hear that you are facing an issue creating an Azure Mysql flexible through CLI.
I tried to repro the issue and facing the same error message which seems to be a bug. I am working internally with our product group to get this resolved. Thank you for bringing this into our attention.

Regards,
Oury

0 Votes 0 ·

Hi @chaowenguo-9404 Our product group still working on the issue. I will share an update on this once I got a result from PG.

Regards,
Oury

0 Votes 0 ·

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

Hi @chaowenguo-9404 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

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

No, still not working. Problem remains.

0 Votes 0 ·

@chaowenguo-9404 I am checking with our product group. I will get back to you shortly.

Regards,
Oury

0 Votes 0 ·

@chaowenguo-9404
I was able to create a Mysql flexible server using CLI on westus region. Could you please check again. Also verify in the Azure portal if the database name is showing.

130749-image.png

130756-image.png

Regards,
Oury


0 Votes 0 ·
image.png (31.5 KiB)
image.png (31.5 KiB)
image.png (46.0 KiB)
Show more comments