Azure database for MySQL restore function throwing errors

Category: azure database for mysql

Question

FrogMD on Wed, 27 Dec 2017 18:04:31


I am trying to create a sandbox environment to test out code without affecting the users who are visiting our production site. I figured that I needed to duplicate my MySQL database to allow for this functionality. However, when I tried to "restore" the database to a previous version (I tried anywhere for 12 hours ago up till 5 minutes ago), I receive notifications that the process has failed.

  1. How can I fix this error?
  2. Is there a better way to create a sandbox environment for testing WordPress plugins and code?


Steve Hwang

Replies

MohitGarg_MSFT on Wed, 27 Dec 2017 23:54:08


Thanks for reaching out. I am able to repro the issue reported above. I am trying to contact required team to check on the error and will let you know once I have more information regarding it.

Saloni Sonpal on Thu, 28 Dec 2017 00:13:50


Hi Steve,

If you could share certain details with me, that would help us debug the issue. From the screenshot, it's hard to see the:

  • server name
  • SKU and compute units
  • creation time
  • restore attempt time

If you could email it to me on saloni(dot)sonpal(at)microsoft(dot)com, the engineering team here can take a look.

Thanks,

Saloni

Hong Wang – MSFT on Fri, 29 Dec 2017 03:32:19


Hi frogmd

 

Hope you are getting well

For your case where you cannot restore your mysql server whose name is frogmd-wp.mysql.database.azure.com, actually this is one of our known bugs.

 

We found that the restored source server ‘frogmd-wp’ is not a newly created one, instead it is restored from other server. In such case, if you try to restore a new server from the ‘frogmd-wp’ server, it will hit our bug and fail.

 

We have done some mitigated steps for your server,  so the restore operation from ‘frogmd-wp’ with time point AFTER the 2017-12-28 11:06:02 UTC time.

 

If you still want to do the restore operation for ‘frogmd-wp’ BEFORE 2017-12-28 11:06:02 UTC time, please raise support case with the time point you want to restore, we will handle the restore for you.

 

Thanks

Hong