Cannot create Azure MySQL server : 'The server 'xxxx' does not exist or in unexpected status'

Question

Cannot create Azure MySQL server : 'The server 'xxxx' does not exist or in unexpected status'

Ian Jirka 1

I created a MySql server via the portal, then removed it and deployed it via ARM template. When I attempt to create it now, it gives the message

{
"status": "Failed",
"error": {
"code": "ServerNotExist",
"message": "The server 'xxx' does not exist or in unexpected status."
}
}

It seems there is some leftover from the previous server. I've tried a half dozen times over 12 hours and get the same behavior. I can work around with another server name but it breaks my naming convention so would prefer not to. Any ideas?

0 comments

2 answers

Your answer

Answer 1

Ian Jirka 1

I was able to get it working - the issue was with a different property not being correctly configured (one of the vNet parameters, IIRC). It was trying to say 'The server configuration you gave me is broken'. Definitely could use use more precise error messages.

0 comments

Answer 2

Andreas Baumgarten 132.1K MVP Volunteer Moderator

Hi @Ian Jirka ,

please take a look in the Azure Portal -> All resources if there are any old relicts of the deleted Azure MySQL server (VM, disk(s), NIC, ... ).

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Ian Jirka 1 Reputation point

2022-01-11T18:51:03.38+00:00

Thanks Andreas. There are no remnants. This is a flexible server so I wouldn't expect it to have other resources but I did check anyway.

resource xxx 'Microsoft.DBforMySQL/flexibleServers@2021-05-01' = {
Chris Doherty 6 Reputation points

2022-01-16T03:22:59.107+00:00

I am having the exact same problem with deploying a Microsoft.DBforMySQL/flexibleServers using a Bicep template. No matter what options are set, no matter which API version I use, no matter which region I deploy to, I get the same error as the OP: Status Message: The server '(name)' does not exist or in unexpected status. (Code:ServerNotExist)

I change the server name and deployment name with each run to ensure no namespace collisions or stale resources. Creating a flexible server from the portal seems to work correctly; I have generated the Bicep template both by hand and by exporting and converting the hand-built portal resource template.

It very much looks like the ARM API for Microsoft.DBforMySQL/flexibleServers is simply broken. At the very least, the error message is. (Of course the server doesn't exist; I'm trying to create it).

(As an aside, the ARM template in the quickstart documentation for MySQL flexible server is also broken; the property fields don't match the API version specified and the deployment schema version is wrong).
Chris Doherty 6 Reputation points

2022-01-16T06:49:18.823+00:00

Hi, Ian. I've found the source of the problem.

The ARM template for a flexibleServer requires two undocumented fields: publicNetworkAccess and sku.capacity. They aren't in the docs and exporting an existing flexibleServer won't include them in the template. You can see the values and the format by manually creating a flexibleServer in the portal, walking through all the setup steps and before creating it, click on the "download a template" link next to the Create button. For some reason, this link generates more accurate and usable ARM templates than exporting an existing one. This is true for Azure resources generally; if you're having trouble authoring ARM templates, exporting them this way will reveal a number of undocumented fields and settings.
Le Tuan 6 Reputation points

2022-03-31T04:05:42.373+00:00

I got the same issues as you. I was trying to newly created Microsoft.DBforMySQL/flexibleServers with bicep, but got the error: ServerNotExist. After a while, I figured out that my bicep template include maintenanceWindow. After I remove it, I can finally create Microsoft.DBforMySQL/flexibleServers. My accepted bicep template:

resource mysqlServer 'Microsoft.DBforMySQL/flexibleServers@2021-05-01' = {
name: mysqlServerName
location: location
tags: {
Project: project
Environment: environment
}
sku: {
name: 'Standard_D2ds_v4'
tier: 'GeneralPurpose'
}
properties: {
administratorLogin: user
administratorLoginPassword: password
storage: {
storageSizeGB: 128
iops: 684
autoGrow: 'Enabled'
}
createMode: 'Default'
version: '8.0.21'
replicationRole: 'None'
network: {
delegatedSubnetResourceId: subnet.id
privateDnsZoneResourceId: privateMysqlDns.id
}
backup: {
backupRetentionDays: 7
geoRedundantBackup: 'Disabled'
}
highAvailability: {
mode: 'Disabled'
}
}
}
Martin Bonelli 1 Reputation point

2022-05-02T11:49:25.397+00:00

this solved it for me. I've deleted MaintenanceWindow and it worked! Thank you very much!

Share via

Cannot create Azure MySQL server : 'The server 'xxxx' does not exist or in unexpected status'

2 answers

Your answer