[DBforPostgreSQL] Updating backup retention days for PostgreSQL flexible server failed

[sinbai]

First we get backup retention days for postgresql flexible server:
Get https://management.azure.com/subscriptions/.../resourceGroups/testPostgreSql/providers/Microsoft.DBforPostgreSQL/flexibleServers/acctest-fs-0302?api-version=2022-12-01

Response Body:

{
    "sku": {
        "name": "Standard_D2s_v3",
        "tier": "GeneralPurpose"
    },
    "systemData": {
        "createdAt": "2023-03-02T02:13:39.8238554Z"
    },
    "properties": {
        "authConfig": {
            "activeDirectoryAuth": "Disabled",
            "passwordAuth": "Enabled"
        },
        "dataEncryption": {
            "type": "SystemManaged"
        },
        "fullyQualifiedDomainName": "acctest-fs-0302.postgres.database.azure.com",
        "version": "13",
        "minorVersion": "9",
        "administratorLogin": "adminTerraform",
        "state": "Ready",
        "availabilityZone": "1",
        "storage": {
            "storageSizeGB": 32
        },
        "backup": {
            "backupRetentionDays": 7,
            "geoRedundantBackup": "Disabled",
            "earliestRestoreDate": "2023-03-02T02:19:18.3300808+00:00"
        },
        "network": {
            "publicNetworkAccess": "Disabled",
            "delegatedSubnetResourceId": "/subscriptions/.../resourceGroups/testPostgreSql//providers/Microsoft.Network/virtualNetworks/acctest-vn-0302/subnets/acctest-sn-0302",
            "privateDnsZoneArmResourceId": "/subscriptions/.../resourceGroups/testPostgreSql//providers/Microsoft.Network/privateDnsZones/acc0302.postgres.database.azure.com"
        },
        "highAvailability": {
            "mode": "ZoneRedundant",
            "state": "Healthy",
            "standbyAvailabilityZone": "2"
        },
        "maintenanceWindow": {
            "customWindow": "Enabled",
            "dayOfWeek": 0,
            "startHour": 8,
            "startMinute": 0
        },
        "replicationRole": "Primary",
        "replicaCapacity": 5
    },
    "location": "East US",
    "tags": {
        "ENV": "Stage"
    },
    "id": "/subscriptions/.../resourceGroups/testPostgreSql//providers/Microsoft.DBforPostgreSQL/flexibleServers/acctest-fs-0302",
    "name": "acctest-fs-0302",
    "type": "Microsoft.DBforPostgreSQL/flexibleServers"
}

Then we update the backupRetentionDays and tags, everything works fine.
Patch https://management.azure.com/subscriptions/.../resourceGroups/testPostgreSql/providers/Microsoft.DBforPostgreSQL/flexibleServers/acctest-fs-0302?api-version=2022-12-01

Request Body:

{
   "properties":{
        "backup": {
            "backupRetentionDays": 12
        }
   },
   "tags":{
      "ENV":"Stage01"
   }
}

But when we update the backupRetentionDays, tags and storageSizeGB together, only backupRetentionDays and tags update successfully, the backupRetentionDays does not.

Patch https://management.azure.com/subscriptions/.../resourceGroups/testPostgreSql/providers/Microsoft.DBforPostgreSQL/flexibleServers/acctest-fs-0302?api-version=2022-12-01

Request Body:

{
   "properties":{
        "storage": {
            "storageSizeGB": 64
        },
        "backup": {
            "backupRetentionDays": 11
        }
   },
   "tags":{
      "ENV":"Stage02"
   }
}

I assume that this is an API bug, correct? If not, is it possible to provide public document for this change, since it was working fine not too long ago(January 2023).

[navba-MSFT]

@sinbai Apologies for the late reply. Thanks for reaching out to us and reporting this issue. We are looking into this issue and we will provide an update.

[navba-MSFT]

@sinbai I was able to send a single update request by invoking this REST API to update the storageSizeGB, backupRetentionDays and tags.

Sending you the screenshot if that helps.

Update Request:

Got a 202 success response.

Then invoked the Servers - Get REST API which Gets information about a server.

Got the properties which I had set previously.

If you are trying to update the storageSizeGB to a smaller value then Note that storage cannot be scaled down once the server is created.

[sinbai]

@navba-MSFT thanks for your quick reply. Because this is a problem found in one of our automated test cases, it may not be easy to reproduce it manually. This is part of the log (terraform.log) of my running test case. Hope it is useful to you. The details are as follows:

• Line962: create a postgresql flexible server with backupRetentionDays set to 7
• Line2344: update backupRetentionDays to 10
• Line2676: update completed:
• {"name":"f443864e-e62f-483b-aa77-411f720d2378","status":"Succeeded","startTime":"2023-03-07T07:26:52.133Z"}
• Line2890: get the postgresql flexible server
• Line2914: response = > backupRetentionDays = 7

[navba-MSFT]

@sinbai Thanks for your reply. A quick question:

But when we update the backupRetentionDays, tags and storageSizeGB together, only backupRetentionDays and tags update successfully, the backupRetentionDays does not.

• Did you mean to say only storageSizeGB and tags update successfully ?

• Did you open the Azure portal and confirm if the backupRetentionDays settings are updated fine ?

• After updating the backupRetentionDays setting, how soon did you invoke the Servers - Get REST API to check if the updated values are saved correctly ?

Since I am able to invoke this API and set the configurationscorrectly, I dont think the issue is with the API.