Restore-AzMySqlFlexibleServer suddenly fails with an unexpected error

Question

Restoring a MySql Flexible server from PowerShell suddenly fails.

It has been working for more than a year and now gives an unexpected error.

What should I change?

PS /home/bert> $restorePointInTime = (Get-Date).AddMinutes(-1)

PS /home/bert> $serverToRestore = Get-AzMySqlFlexibleServer -Name bgi-db-test -ResourceGroupName bgiodata

PS /home/bert> Restore-AzMySqlFlexibleServer -InputObject $serverToRestore -Name bgi-db-test-restored -ResourceGroupName bgiodata -RestorePointInTime $restorePointInTime

New-AzMySqlFlexibleServer_CreateExpanded: /usr/local/share/powershell/Modules/Az.MySql/1.2.1/MySql.Autorest/custom/Restore-AzMySqlFlexibleServer_PointInTimeRestore.ps1:189

Line |

189 | Az.MySql.internal\New-AzMySqlFlexibleServer @PSBoundParam …

 |              ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 | An unexpected error occured while processing the request. Tracking ID: 'dee17bb1-4d63-4d58-bca0-f05b74a1aa0d'

PS /home/bert>

Answer 1

Hi @Bert Heesbeen

Thanks for the question and using MS Q&A platform.

The error you're experiencing when attempting to restore a MySQL Flexible Server in Azure appears to be caused by an unexpected issue with the Restore-AzMySqlFlexibleServer command. Given that this process has been successful for over a year and is now encountering problems, here are some troubleshooting steps you can follow to address the issue

Make sure that your PowerShell module is up to date. Sometimes, updates can fix bugs or compatibility issues.

You're using Az.MySql module version 1.2.1. It's worth ensuring that you're using the latest version of the Azure PowerShell modules, as updates might fix known issues with commands like Restore-AzMySqlFlexibleServer.

If the issue persists, you can create a support ticket via the Azure portal. To do this, go to Help + Support in the portal and submit your issue, along with the tracking ID, for further assistance from Azure support.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.