Hello Sanjula De Alwis,
Welcome to the Microsoft Q&A and thank you for posting your questions here.
Problem
I understand that you encountered an error message, "The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'," during the provisioning of your Azure Database for MySQL server.
Solution
The error shows that there was an issue during the provisioning of your Azure Database for MySQL server. This can happen for various reasons, including resource limitations, configuration errors, or service availability issues.
To troubleshoot and resolve the issue these are simplified steps you can take:
- You will need to check your subscription that it has sufficient resources and quotas for the provisioning. Since you are using a subscription with free credits, there might be limitations on the number of resources or specific resource types you can provision. So, go to the Azure Portal, navigate to your subscription, and check the quotas and usage.
- Make sure that the resource group "students-rg" and the location (region) you selected are correct and supported for Azure Database for MySQL. Because some regions might have restrictions or might not support certain services.
- Ensure that all mandatory fields are correctly filled out for configuration parameters, especially common parameters such as server name, admin username, admin password, and pricing tier.
- Sometimes, Azure services may experience outages or issues in specific regions. Check the Azure Service Health dashboard to see if there are any ongoing issues that might be affecting your ability to create resources.
- Sometimes, transient issues can cause provisioning failures. Try deleting any partially created resources and retry creating the MySQL server.
- Navigate to the resource group's Activity Log in the Azure Portal to get detailed information about the failure. The logs might provide specific error codes or messages that can help identify the issue.
I strongly believe on of these will help you to troubleshoot the issue.
References
To read more about the provided steps, kindly use the links below.
- Create your first Azure Database for MySQL flexible server - Training
- Resolve capacity errors with Azure SQL resources - Azure SQL
- Resolve capacity errors - Azure Database for MySQL - Flexible Server
- Quickstart: Create a server - Azure CLI - Azure Database for MySQL
- Try for free (preview) - Azure SQL Database (Try this to recreate another)
- Quickstart: Create a flexible server by using the Azure CLI - Azure Database for MySQL - Flexible Server
Accept Answer
I hope this is helpful! Do not hesitate to let me know if you have any other questions.
** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful ** so that others in the community facing similar issues can easily find the solution.
Best Regards,
Sina Salam