Getting "An unexpected error occured while processing the request." while creating flexible MySQL server via terraform

Max Brydak 5 Reputation points
2023-06-05T12:26:25.5266667+00:00

Hello

I'm trying to create azure flexible server for mysql via terraform, unfortunately I am encountering a really non-descriptive error as below.

│ Error: creating Flexible Server (Subscription: *redacted*
│ Resource Group Name: *redacted*
│ Flexible Server Name: *redacted*): polling after Create: Code="InternalServerError" Message="An unexpected error occured while processing the request. Tracking ID: '8dbea974-920a-4d9a-80ac-4ba4e49e43d2'"
│
│ with azurerm_mysql_flexible_server.main-flexible,
│ on mysql-server.tf line 46, in resource "azurerm_mysql_flexible_server" "main-flexible":
│ 46: resource "azurerm_mysql_flexible_server" "main-flexible" {
│
╵

What can be the cause of it? Is it some kind of issue with my Terraform code, or some internal Azure problems?

UPDATE:

I've tried provisioning bigger instances, unfortunately without any effect.

To keep it brief, here are tracking IDs for those errors.

4 V cores: f2413538-6efc-4517-8522-e2952c48e7b4

8 V cores: 8840d932-8dca-402d-988e-b229e8a651a9

I've tried creating a server from portal, and could provision 2 V core instance without issues, but unfortunately that does not resolve my issue, as having 100% IaC is a critical project requirement.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
759 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Rahul Randive 9,176 Reputation points Microsoft Employee
    2023-06-05T15:02:54.8033333+00:00

    Hi @Max Brydak

    Thanks for sharing the tracking ID.

    It appears that you are creating a server in the West Europe region and have selected 2 V cores with Server Version 8.0.

    Could you please try again with 4 or 8 V cores and see if it works?

    If it does work and you only require 2 V cores, you could consider scaling down the instance. 

    Also, you can try creating a server from the portal to see if any issue from platform side.

    Thank you!