Deployment failure for postgresql deployment failed with InternalServerError.

Medical Realities 21

We're deploying our new backend database to the postgresql flexible server, and whilst the dev deployments are working, production keeps throwing an InternalServerError.

"error": {  
  "code": "DeploymentFailed",  
  "message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage details.",  
  "details": [  
    {  
      "code": "InternalServerError",  
      "message": "An unexpected error occured while processing the request. Tracking ID: '{id removed for support post}'"  
    }  
  ]  
},  
"validationLevel": "Template"

}

I can post more of the deployment json if required.

Tim Macintosh 1

   {  
       "status": "Failed",  
       "error": {  
           "code": "InternalServerError",  
           "message": "An unexpected error occured while processing the request. Tracking ID: '4bef56c1-dc4d-4c93-94c3-7318f3de2178'"  
       }  
   }

I'm not sure if this is related but I am getting this error when trying to deploy a PostgreSQL Flexible Server.

The Status says: Conflict

GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-11-06T23:41:56.617+00:00

@Tim Macintosh Looks similar but let me check from my end.

Regards
Geetha
GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-11-07T00:01:01.307+00:00

@Tim Macintosh I just tried to deploy from the portal and it got successfully deployed
Can you share more details on what steps you are following to deploy and which region?

Regards
Geetha
Tim Macintosh 1 Reputation point

2022-11-07T00:14:18.453+00:00

This is the parameters of the deployment. Which I try to deploy via the Portal.

Tim Macintosh 1

I also tried to deploy via Powershell and encountered an InternalServerError.

   New-AzResourceGroupDeployment : 12:36:46 pm - The deployment 'postgres-flexible-server-template' failed with error(s). Showing 1 out of 1 error(s).  
   Status Message: An unexpected error occured while processing the request. Tracking ID: '0a0e6b5d-483d-4235-a9e8-d34bf890f46d' (Code:InternalServerError)  
   CorrelationId: d79b929c-0346-4396-a5b0-371d48eeb139  
   At C:\Users\tmacintosh\Documents\temp\AzurePostgresDeploymentTemplate\azure_postgres_deployment.ps1:14 char:1  
   + New-AzResourceGroupDeployment -ResourceGroupName $resourceGroupName `  
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~  
       + CategoryInfo          : NotSpecified: (:) [New-AzResourceGroupDeployment], Exception  
       + FullyQualifiedErrorId : Microsoft.Azure.Commands.ResourceManager.Cmdlets.Implementation.NewAzureResourceGroupDeploymentCmdlet

GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-11-09T16:15:36.497+00:00

@Tim Macintosh is your issue resolved?

Regards
Geetha
Tim Macintosh 1 Reputation point

2022-11-09T19:03:43.153+00:00

Hi Geetha,

I ended up successfully deploying the flexible server using the Azure CLI command line tools.

I think the issue I was having in the Portal was to do with specifying firewall rules.

Regards
Tim
GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-11-09T19:10:44.783+00:00

Thank @Tim Macintosh for confirming the issue is resolved.
Thank you for visiting the Microsoft QA forums! Have a great day!

Regards
Geetha

Accepted answer

GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-11-03T12:31:36.367+00:00

Hi, @Medical Realities Welcome to the Microsoft Q&A platform, and thanks for using Azure Services.
I understand that you are facing an issue while deploying Azure Postgres SQL.
Sorry for the inconvenience caused There is an outage going on for customers creating Azure PostgreSQL flexible server. Our Product Group is actively working on it.
Existing servers are not impacted. Only PITR and new server creations are impacted.
you can also track azure service outages using the link below.
Https://Status.azure.com

Regards
Geetha
Please sign in to rate this answer.

1 person found this answer helpful.
Medical Realities 21 Reputation points

2022-11-03T13:01:53.577+00:00

I see. Will we have any notification when this service is back online?

Medical Realities 21 Reputation points

2022-11-03T13:03:21.883+00:00

Additionally, how long has this outage been in place please?

GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-11-03T13:46:12.767+00:00

@Medical Realities Outage started yesterday Nov02 2022, I will check with the internal team on the notification, however, I will update here in the forum once the issue is resolved.

Regards
Geetha

GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-11-05T15:45:13.243+00:00

@Medical Realities issue is now fixed please retry your deployment and let us know.

Regards
Geetha
Sign in to comment

Deployment failure for postgresql deployment failed with InternalServerError.

0 additional answers