Internal server error while creating postgres flexible server

Question

Internal server error while creating postgres flexible server

Uday Kiran Reddy 11

With below terraform template, when I try to create postgres flexible server, getting error as:

 Error: waiting for creation of the Postgresql Flexible Server "testaksk8s-del-postgres-del" (Resource Group "testaksk8s-del-postgres"): Code="InternalServerError" Message="An unexpected error occured while processing the request. Tracking ID: '4a1b5b2f-3d37-4fd3-9d36-7572b53e8287'"
│
│   with azurerm_postgresql_flexible_server.example,
│   on 12-postgres.tf line 15, in resource "azurerm_postgresql_flexible_server" "example":
│   15: resource "azurerm_postgresql_flexible_server" "example" {

The templates link: https://github.com/uday-globuslive/test-postgres-templates

Same issue with azure cli also:

C:\Users\user1>az postgres flexible-server create --admin-password "erwin@2020" --admin-user postgres --backup-retention 7 --high-availability Disabled --location eastus2 --name testaksk8s-del-postgres-del --private-dns-zone /subscriptions/f733ab10-e6a2-406d-9c23-cafe4ec0e71e/resourceGroups/testaksk8s-del-postgres/providers/Microsoft.Network/privateDnsZones/deve.private.postgres.database.azure.com --resource-group "testaksk8s-del-postgres" --sku-name Standard_D2s_v3 --storage-size 128 --subnet "/subscriptions/f733ab10-e6a2-406d-9c23-cafe4ec0e71e/resourceGroups/testaksk8s-del/providers/Microsoft.Network/virtualNetworks/testaksk8s/subnets/testaksk8s-subnet2" --version 13 --zone 1
Checking the existence of the resource group 'testaksk8s-del-postgres'...
Resource group 'testaksk8s-del-postgres' exists ? : True
You have supplied a Subnet ID. Verifying its existence...
Using existing Vnet "testaksk8s" in resource group "testaksk8s-del"
Using existing Subnet "testaksk8s-subnet2" in resource group "testaksk8s-del"
Using the existing private dns zone deve.private.postgres.database.azure.com in resource group "testaksk8s-del-postgres"
Creating PostgreSQL Server 'testaksk8s-del-postgres-del' in group 'testaksk8s-del-postgres'...
Your server 'testaksk8s-del-postgres-del' is using sku 'Standard_D2s_v3' (Paid Tier). Please refer to https://aka.ms/postgres-pricing for pricing details
(InternalServerError) An unexpected error occured while processing the request. Tracking ID: '7c903c34-671c-4570-83b0-639ef964d0b1'
Code: InternalServerError
Message: An unexpected error occured while processing the request. Tracking ID: '7c903c34-671c-4570-83b0-639ef964d0b1'

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-25T16:48:50.023+00:00

Hi @Uday Kiran Reddy Thanks for posting your question in the Microsoft forum
I looked into your code and noticed that you are using "English_United States.1252" as a collation. but we have some differences between azure postgresql single server and flex server, in flex server, we should use em_US.uff8 while in single server we can use English_United States.1252
so I suggest you change the collation to em_US.uff8 and test if you can get it fixed.

Regards
Geetha
Uday Kiran Reddy 11 Reputation points

2022-01-25T17:07:58.753+00:00

Getting the same error even if I remove the database resource and keep only flexible server part.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-25T20:09:50.487+00:00

Hi, @Uday Kiran Reddy I am checking with the internal team will get back to you with more details.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-26T23:02:23.7+00:00

Hi, @Uday Kiran Reddy I am still waiting for a response from the internal team, will update you once I get the response.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-27T19:06:55.487+00:00

Hi, @Uday Kiran Reddy To better assist on this issue and deeper investigation i would recommend opening a support ticket if you have one else i can can create a one-time-free support ticket for you to work on this issue.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-28T14:00:03.39+00:00

Hi, @Uday Kiran Reddy We haven't heard back from you. Just wanted to check if you are still facing the issue? In case you already found a solution, would you please share it here with the community? Otherwise, let us know if you want to use the free support ticket and we will continue to engage with you on the issue.

Regards
Geetha
Uday Kiran Reddy 11 Reputation points

2022-01-30T11:18:32.75+00:00

i have a different account where we raised a service ticket, enterprise one, there also no proper resolution
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-30T15:27:37.29+00:00

Hi @Uday Kiran Reddy Sorry to hear that your issue is still not resolved, can you please share your service case id so I can check with the internal team.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-02-01T14:33:09.137+00:00

Hi, @Uday Kiran Reddy we dint hear back from you can you please share the service case id.

Regards
Geetha
Miriam Marx 0 Reputation points

2023-02-07T09:53:22.21+00:00

Hi @GeethaThatipatri-MSFT ,
I'm facing the same issue with terraform and azureCli. Is there any update on the topic or can I get such a free support ticket? We would really need this issue to be fixed, otherwise we cannot deploy new instances of our software via IaC.
Best regards
Miriam
Miriam Marx 0 Reputation points

2023-02-07T09:55:58.31+00:00

It started happening last week for our project and I even tried using default terraform configs, but everything fails.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-02-08T17:11:56.8966667+00:00

@Miriam Marx Can you please create a new post with all the details and error screenshots if any?

Regards

Geetha
Alok Kundu - tmnz 5 Reputation points

2023-03-03T21:39:15.98+00:00

Is there an update, I am getting the same error with mysql flexible server.

Flexible Server Name: "managed-mysql"): polling after Create: Code="InternalServerError" Message="An unexpected error occured while processing the request. Tracking ID: 'a058b165-9489-473e-9633-87c24694de5e'"
Chandrala 0 Reputation points

2023-04-03T06:54:12.2366667+00:00

Hi @GeethaThatipatri-MSFT , is there an update on this, I am also getting the same error while creating the potgresql flexible server using IaC.

error: Code="InternalServerError" Message="An unexpected error occured while processing the request. Tracking ID: '1b8eb450-dc7a-4bc7-8007-43d69d7ea22e'"
Cristian Popescu 0 Reputation points

2023-04-03T07:53:02.89+00:00

On my side it was the zone 1 not available on "West Europe". We wasted few days on this. The Azure API response is not handle correctly
Chandrala 0 Reputation points

2023-04-03T09:26:27.51+00:00

Hi @Cristian Popescu , can you please elaborate on what you mean by "zone 1 not available on West Europe" ?

Cristian Popescu 0

By specifying the zone the the flexi-server resource the creation of the resource resulted into 500 internal error. Eventually I let the API to auto select it for me and then I ignore the changes

This is how it worked for me:


resource "azurerm_postgresql_flexible_server" "default" {
  name                   = "test-server-001"
  resource_group_name    = var.resource_group_name
  location               = var.location
  version                = "13"
  administrator_login    = "adminTerraform"
  administrator_password = "password"
  storage_mb             = 32768
  sku_name               = "B_Standard_B1ms"
  backup_retention_days  = 7

  lifecycle {
    ignore_changes = [
      zone
    ]
  }
}

Chandrala 0 Reputation points

2023-04-03T10:18:55.03+00:00

Thank you for providing explanation @Cristian Popescu

2 answers

Your answer

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-25T16:48:50.023+00:00

Hi @Uday Kiran Reddy Thanks for posting your question in the Microsoft forum
I looked into your code and noticed that you are using "English_United States.1252" as a collation. but we have some differences between azure postgresql single server and flex server, in flex server, we should use em_US.uff8 while in single server we can use English_United States.1252
so I suggest you change the collation to em_US.uff8 and test if you can get it fixed.

Regards
Geetha
Uday Kiran Reddy 11 Reputation points

2022-01-25T17:07:58.753+00:00

Getting the same error even if I remove the database resource and keep only flexible server part.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-25T20:09:50.487+00:00

Hi, @Uday Kiran Reddy I am checking with the internal team will get back to you with more details.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-26T23:02:23.7+00:00

Hi, @Uday Kiran Reddy I am still waiting for a response from the internal team, will update you once I get the response.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-27T19:06:55.487+00:00

Hi, @Uday Kiran Reddy To better assist on this issue and deeper investigation i would recommend opening a support ticket if you have one else i can can create a one-time-free support ticket for you to work on this issue.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-28T14:00:03.39+00:00

Hi, @Uday Kiran Reddy We haven't heard back from you. Just wanted to check if you are still facing the issue? In case you already found a solution, would you please share it here with the community? Otherwise, let us know if you want to use the free support ticket and we will continue to engage with you on the issue.

Regards
Geetha
Uday Kiran Reddy 11 Reputation points

2022-01-30T11:18:32.75+00:00

i have a different account where we raised a service ticket, enterprise one, there also no proper resolution
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-01-30T15:27:37.29+00:00

Hi @Uday Kiran Reddy Sorry to hear that your issue is still not resolved, can you please share your service case id so I can check with the internal team.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-02-01T14:33:09.137+00:00

Hi, @Uday Kiran Reddy we dint hear back from you can you please share the service case id.

Regards
Geetha
Miriam Marx 0 Reputation points

2023-02-07T09:53:22.21+00:00

Hi @GeethaThatipatri-MSFT ,
I'm facing the same issue with terraform and azureCli. Is there any update on the topic or can I get such a free support ticket? We would really need this issue to be fixed, otherwise we cannot deploy new instances of our software via IaC.
Best regards
Miriam
Miriam Marx 0 Reputation points

2023-02-07T09:55:58.31+00:00

It started happening last week for our project and I even tried using default terraform configs, but everything fails.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-02-08T17:11:56.8966667+00:00

@Miriam Marx Can you please create a new post with all the details and error screenshots if any?

Regards

Geetha
Alok Kundu - tmnz 5 Reputation points

2023-03-03T21:39:15.98+00:00

Is there an update, I am getting the same error with mysql flexible server.

Flexible Server Name: "managed-mysql"): polling after Create: Code="InternalServerError" Message="An unexpected error occured while processing the request. Tracking ID: 'a058b165-9489-473e-9633-87c24694de5e'"
Chandrala 0 Reputation points

2023-04-03T06:54:12.2366667+00:00

Hi @GeethaThatipatri-MSFT , is there an update on this, I am also getting the same error while creating the potgresql flexible server using IaC.

error: Code="InternalServerError" Message="An unexpected error occured while processing the request. Tracking ID: '1b8eb450-dc7a-4bc7-8007-43d69d7ea22e'"
Cristian Popescu 0 Reputation points

2023-04-03T07:53:02.89+00:00

On my side it was the zone 1 not available on "West Europe". We wasted few days on this. The Azure API response is not handle correctly
Chandrala 0 Reputation points

2023-04-03T09:26:27.51+00:00

Hi @Cristian Popescu , can you please elaborate on what you mean by "zone 1 not available on West Europe" ?
Cristian Popescu 0 Reputation points

2023-04-03T09:40:28.7333333+00:00

By specifying the zone the the flexi-server resource the creation of the resource resulted into 500 internal error. Eventually I let the API to auto select it for me and then I ignore the changes

This is how it worked for me:

resource "azurerm_postgresql_flexible_server" "default" { name = "test-server-001" resource_group_name = var.resource_group_name location = var.location version = "13" administrator_login = "adminTerraform" administrator_password = "password" storage_mb = 32768 sku_name = "B_Standard_B1ms" backup_retention_days = 7 lifecycle { ignore_changes = [ zone ] } }
Chandrala 0 Reputation points

2023-04-03T10:18:55.03+00:00

Thank you for providing explanation @Cristian Popescu

Answer 1

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

Hi, @Uday Kiran Reddy to close this thread this was addressed here and the resolution is to update the code as mentioned below.
please let us know if you need any additional information, we are happy to help. if you find the above reply useful. If yes, do click on 'Mark as answer' This will help other community members facing similar queries to refer to this solution.

Regards
Geetha

Answer 2

Aaron Waidmann 1

Hi!
So, something you could be missing is that your flexible server is blocking your (or your pipelines) network traffic.
You are going to need one (or many) azurerm_postgresql_flexible_server_firewall_rule to allow traffic to your flexible server.

There seems to be an issue with the database resource returning an internal server error though.

Share via

Internal server error while creating postgres flexible server

2 answers

Your answer