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.

Answer 2

Hi @Bert Heesbeen ,

Thanks for reaching out to us.

Let me take this forward.

I can see you have 2 questions here

1. Support ticket link: Free support link to raise a request A) https://support.microsoft.com/en-gb/topic/customer-service-phone-numbers-c0389ade-5640-e588-8b0e-28de8afeb3f2
2. unable to use Az.MySql module in automation account: A) To use the az mysql command in an Automation Account, ensure you import the az module into the shared gallery of your Automation Account. If you encounter any challenges during the process, feel free to reach out—I'm happy to assist!
    

Please provide your valuable comments

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members.