The error returned is not understandable when fail to create MySQL server

msJinLei commented 4 years ago

Description

The step to produce and error log

PS C:\Users\azureuser> New-AzMySqlServer -Name mydemoserver -ResourceGroupName labrg783 -Sku GP_Gen5_2 -GeoRedundantBackup Enabled -Location westus -AdministratorUsername myadmin -AdministratorLoginPassword $Password

New-AzMySqlServer_Create: C:\Program Files\PowerShell\Modules\Az.MySql\0.1.0\custom\New-AzMySqlServer.ps1:218 Line | 218 | Az.MySql.internal\New-AzMySqlServer @PSBoundParameters | ~~~~~~~~~~~~~~ | The requested resource of type 'MySQL.Server.PAL' with name 'mydemoserver' was not found.

�[91mNew-AzMySqlServer_Create: �[0mC:\Program Files\PowerShell\Modules\Az.MySql\0.1.0\custom\New-AzMySqlServer.ps1:218 �[96mLine | �[96m 218 | �[0m �[96mAz.MySql.internal\New-AzMySqlServer @PSBoundParameters�[0m �[96m | �[91m ~~~~~~~~~~~~~~ �[91m�[96m | �[91mThe requested resource of type 'MySQL.Server.PAL' with name 'mydemoserver' was not found. �[0m

Cost

dingmeng-xue commented 4 years ago

Can we reproduce this issue?

LucasYao93 commented 4 years ago

Reproduce

Step 1: Create a azure mysqldb named mydemoserver by azure portal in subscription A.
Step 2: Create a azure mysqldb also named mydemoserver by New-AzMySqlServer in other subscription B. The 'MySQL.Server.PAL' error return.
Step 3: Delete mydemoserver of subscription A. Create a azure mysqldb named mydemoserver in subscription B. Created successfully

Summary

I think that the azure mysql already existsin in azure caused error. the error message should be that the specified server name 'mydemoserver' is already used. Please use a different name and try again.

ghost commented 3 years ago

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @ambhatna, @savjani.

Issue Details

## Description The step to produce and error log PS C:\Users\azureuser> New-AzMySqlServer -Name mydemoserver -ResourceGroupName labrg783 -Sku GP_Gen5_2 -GeoRedundantBackup Enabled -Location westus -AdministratorUsername myadmin -AdministratorLoginPassword $Password New-AzMySqlServer_Create: C:\Program Files\PowerShell\Modules\Az.MySql\0.1.0\custom\New-AzMySqlServer.ps1:218 Line | 218 | Az.MySql.internal\New-AzMySqlServer @PSBoundParameters | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | The requested resource of type 'MySQL.Server.PAL' with name 'mydemoserver' was not found. �[91mNew-AzMySqlServer_Create: �[0mC:\Program Files\PowerShell\Modules\Az.MySql\0.1.0\custom\New-AzMySqlServer.ps1:218 �[96mLine | �[96m 218 | �[0m �[96mAz.MySql.internal\New-AzMySqlServer @PSBoundParameters�[0m �[96m | �[91m ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ �[91m�[96m | �[91mThe requested resource of type 'MySQL.Server.PAL' with name 'mydemoserver' was not found. �[0m ## Cost

Author:	msJinLei
Assignees:	-
Labels:	`MySQL`, `P0`, `Service Attention`
Milestone:	Backlog

Azure / azure-powershell