Cannot create Postgres Flexible Server Configuration [was: Postgres test is failing]

[mikhailshilkov]

The test started failing in master builds on June 3

deleting error: Code="InvalidParameterValue" Message="Invalid value given for parameter configurationValue. Specify a valid parameter value."

I'll disable the test to unblock the builds but we should investigate.

Update (@thomas11): I wasn't able to create a Configuration after several attempts. Our REST payload looks exactly like in the docs, though. Details in comment.

[thomas11]

The test is now failing with a different error:

   -  azure-native:dbforpostgresql:Configuration backslash_quote **deleting failed** error: Code="InternalServerError" Message="An unexpected error occured while processing the request. Tracking ID: 'f1645a3a-a6a4-4f9f-a580-42b0870eb3ab'"
      pulumi:pulumi:Stack postgres-p-it-runner-postgres-1e599fa5  error: update failed
      pulumi:pulumi:Stack postgres-p-it-runner-postgres-1e599fa5 **failed** 1 error
  Diagnostics:
    azure-native:dbforpostgresql:Configuration (backslash_quote):
      error: Code="InternalServerError" Message="An unexpected error occured while processing the request. Tracking ID: 'f1645a3a-a6a4-4f9f-a580-42b0870eb3ab'"

Users may also be affected, e.g., here's a community Slack thread.

[thomas11]

Debug logs show that the request to update the configuration is accepted (202) but then later returns {"code":"OperationFailed","message":"{0}"}}.

3615:    I0729 07:08:51.930664   96596 client.go:445] HTTP Request Begin GET https://management.azure.com/subscriptions/123/resourceGroups/rg61c1603c/providers/Microsoft.DBforPostgreSQL/flexibleServers/serverdf2d16b3/configurations/ssl?api-version=2022-12-01 ===================================================
3618:    I0729 07:08:53.512364   96596 client.go:464] HTTP Response Begin GET [https://management.azure.com/subscriptions/123/resourceGroups/rg61c1603c/providers/Microsoft.DBforPostgreSQL/flexibleServers/serverdf2d16b3/configurations/ssl?api-version=2022-12-01 ===================================================
3619:    HTTP/2.0 200 OK
3635:    {"properties":{"value":"on","description":"Enables SSL connections.","defaultValue":"off","dataType":"Boolean","allowedValues":"on,off","source":"user-override","isDynamicConfig":true,"isReadOnly":true,"isConfigPendingRestart":false,"documentationLink":"https://www.postgresql.org/docs/14/runtime-config-connection.html#GUC-SSL"},"id":"/subscriptions/123/resourceGroups/rg61c1603c/providers/Microsoft.DBforPostgreSQL/flexibleServers/serverdf2d16b3/configurations/ssl","name":"ssl","type":"Microsoft.DBforPostgreSQL/flexibleServers/configurations"}
3637:    I0729 07:08:53.512482   96596 client.go:441] HTTP Request Begin PUT https://management.azure.com/subscriptions/123/resourceGroups/rg61c1603c/providers/Microsoft.DBforPostgreSQL/flexibleServers/serverdf2d16b3/configurations/ssl?api-version=2022-12-01 ===================================================
3643:    {"properties":{"source":"user-override","value":"on"}}
3645:    I0729 07:08:54.317727   96596 client.go:464] HTTP Response Begin PUT [https://management.azure.com/subscriptions/123/resourceGroups/rg61c1603c/providers/Microsoft.DBforPostgreSQL/flexibleServers/serverdf2d16b3/configurations/ssl?api-version=2022-12-01 ===================================================
3646:    HTTP/2.0 202 Accepted
3665:    {"operation":"UpdateConfigurationManagementOperation","startTime":"2024-07-29T05:08:54.213Z"}
3667:    I0729 07:09:04.319083   96596 client.go:445] HTTP Request Begin GET https://management.azure.com/subscriptions/123/providers/Microsoft.DBforPostgreSQL/locations/westus/azureAsyncOperation/7a2f0bcb-eeb1-4d41-a2cd-79f4ef32ef1a?api-version=2022-12-01&t=638578265343069967&c=... ===================================================
3670:    I0729 07:09:05.141875   96596 client.go:464] HTTP Response Begin GET [https://management.azure.com/subscriptions/123/providers/Microsoft.DBforPostgreSQL/locations/westus/azureAsyncOperation/7a2f0bcb-eeb1-4d41-a2cd-79f4ef32ef1a?api-version=2022-12-01&t=638578265343069967&c=... ===================================================
3671:    HTTP/2.0 200 OK
3688:    {"name":"7a2f0bcb-eeb1-4d41-a2cd-79f4ef32ef1a","status":"Failed","startTime":"2024-07-29T05:08:54.213Z","error":{"code":"OperationFailed","message":"{0}"}}
3690:    I0729 07:09:05.142416   96596 client.go:445] HTTP Request Begin GET https://management.azure.com/subscriptions/123/resourceGroups/rg61c1603c/providers/Microsoft.DBforPostgreSQL/flexibleServers/serverdf2d16b3/configurations/ssl?api-version=2022-12-01 ===================================================
3693:    I0729 07:09:06.561691   96596 client.go:464] HTTP Response Begin GET [https://management.azure.com/subscriptions/123/resourceGroups/rg61c1603c/providers/Microsoft.DBforPostgreSQL/flexibleServers/serverdf2d16b3/configurations/ssl?api-version=2022-12-01 ===================================================
3694:    HTTP/2.0 200 OK
3710:    {"properties":{"value":"on","description":"Enables SSL connections.","defaultValue":"off","dataType":"Boolean","allowedValues":"on,off","source":"user-override","isDynamicConfig":true,"isReadOnly":true,"isConfigPendingRestart":false,"documentationLink":"https://www.postgresql.org/docs/14/runtime-config-connection.html#GUC-SSL"},"id":"/subscriptions/123/resourceGroups/rg61c1603c/providers/Microsoft.DBforPostgreSQL/flexibleServers/serverdf2d16b3/configurations/ssl","name":"ssl","type":"Microsoft.DBforPostgreSQL/flexibleServers/configurations"}

[pulumi-bot]

This issue has been addressed in PR #3467 and shipped in release v2.52.0.