[BUG] Non-existant coordinatorServerEdition in DBforPostgreSQL examnples about azure-rest-api-specs HOT 6 OPEN

Ah, thank you. So there is a difference between our payload and the example, 1 vs 2 coordinatorVCores. Not easy to spot.

Thank you.

from azure-rest-api-specs.

@senatol Please help have a look, thank you.

from azure-rest-api-specs.

Hello @thomas11!

The Azure CLI commands for working with the “Azure Cosmos DB for PostgreSQL” service, as you referred to, are az cosmosdb postgres .... The command you mentioned, az postgres server list-skus --location westus, belongs to the “Azure Database for PostgreSQL” service. Azure Cosmos DB for PostgreSQL service does not have a “list-skus” command.

For the example payloads, thank you for reporting the issue. I was able to reproduce the error with ClusterCreateBurstablev1.json example. I will make sure to include the fix in the next deployment with ETA ~1 month. In the meantime, you may use Azure Portal to create Burstable cluster with 1 vCores.

For the second example, the payload seems correct and worked for me. Could you please try again with ClusterCreateBurstablev2.json example and let me know?

from azure-rest-api-specs.

Hello again @thomas11,

Could you please share the request payload for which you've received the following error?

There is no valid SKU with given coordinator server edition ("BurstableMemoryOptimized") and vCores (1).

The reason I'm asking is the error I received while testing the ClusterCreateBurstablev1.json example payload is the following, which is different than yours:

There is no valid SKU with given worker server edition ("MemoryOptimized") and vCores (1).

But I was not able to reproduce your error with coordinator server edition and I'd like to understand your steps.

from azure-rest-api-specs.

Hi @senatol!

This is the exact payload we were sending:

    {
        "location": "westus",
        "properties": {
            "administratorLoginPassword": "Fooooooo11",
            "citusVersion": "11.3",
            "coordinatorEnablePublicIpAccess": true,
            "coordinatorServerEdition": "BurstableMemoryOptimized",
            "coordinatorStorageQuotaInMb": 524288,
            "coordinatorVCores": 2,
            "enableHa": false,
            "enableShardsOnCoordinator": true,
            "nodeCount": 0,
            "postgresqlVersion": "15",
            "preferredPrimaryZone": "2"
        }
    }

As a PUT request to /subscriptions/REDACTED/resourceGroups/REDACTED/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/laci-test-cluster?api-version=2022-11-08.

I think it matches Azure's example exactly.

from azure-rest-api-specs.

Hello @thomas11 ,

The payload you provided has "coordinatorVCores": 2 with "coordinatorServerEdition": "BurstableMemoryOptimized" which doesn't point to any SKU for Azure Cosmos DB for PostgreSQL.

1. For BurstableMemoryOptimized, supported coordinatorVCores is 1
2. For BurstableGeneralPurpose, supported coordinatorVCores is 2

Please note that when you try the option 1 I've pointed, unfortunately you'll receive the following error which I've currently fixed but waiting to be deployed:

There is no valid SKU with given worker server edition ("MemoryOptimized") and vCores (1).

Until then you may use Azure Portal to create the option 1, coordinatorServerEdition: BurstableMemoryOptimized with coordinatorVCores: 1.

from azure-rest-api-specs.