az sql db create returns error that contradicts itself

[Jtango18]

This is autogenerated. Please review and update as needed.

Describe the bug

Command Name
``

Errors:

To Reproduce:

Steps to reproduce the behavior. Note that argument values have been redacted, as they may contain sensitive information.

-Ensure you have database server created with name set to $serverName

• Execute the following:

az sql db create \
--resource-group $resourceGroupName \
--server $serverName \
--name myTestDatabase \
--edition GeneralPurpose \
--family Gen5 \
--capacity 1 \
--zone-redundant false

This returns an error showing an invalid SKU has been specified.

Could not find sku in tier 'GeneralPurpose' with family 'Gen5', capacity 1. Supported families & capacities for 'GeneralPurpose' are: [('Gen5', 1), ...

The very first Family/Capacity pair is identical to the one specified in the command.
Switching to Capacity 2, works as expected.
Suspect this is related to Serverless DB vs Provisioned Compute

Expected Behavior

Either:

• Creates the database
• Shows an error as to why specified data is invalid

Environment Summary

Linux-4.15.0-1066-azure-x86_64-with-debian-stretch-sid
Python 3.6.5
Shell: bash

azure-cli 2.0.80

Additional Context

[ghost]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub

[jeroenterheerdt]

@jaredmoo

[jaredmoo]

Yes, it's because of serverless. You'll see that below are smallest available capacities:

> az sql db list-editions -l westus -o table
ServiceObjective    Sku            Edition           Family    Capacity    Unit    Available
------------------  -------------  ----------------  --------  ----------  ------  ----------
GP_S_Gen5_1         GP_S_Gen5      GeneralPurpose    Gen5      1           VCores  True
GP_Gen5_2           GP_Gen5        GeneralPurpose    Gen5      2           VCores  True

Let me take a look at how we can fix this.

[jaredmoo]

I chatted with @weizeng-msft and he will fix this. Thank you for reporting this issue!

[OsaPL]

Still happening :(
Powershell Win10 x64

Getting available:

>az sql db list-editions -l centralus -o table
ServiceObjective    Sku            Edition           Family    Capacity    Unit    Available
------------------  -------------  ----------------  --------  ----------  ------  -----------
Basic               Basic          Basic                       5           DTU     True

Creating server:

>az sql server create --name $authNameServer `
                     --admin-password 1337_Pass `
                     --admin-user hackerman `
                     --resource-group $resourceGroup `
                     --location centralus

And finally the Db:

>az sql db create --name $authNameDb `
                 --resource-group $resourceGroup `
                 --server $authNameServer `
                 --compute-model Serverless `
                 --capacity 5 `
                 --edition Basic `
                 --family None

az : Could not find sku in tier 'Basic' with family 'None', capacity 5. Supported families & capacities for 'Basic' are: [(None, 5)]. Please specify one of these supported combinations of family and capacity.
At line:15 char:1
+ az sql db create --name $authNameDb `
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (Could not find ...y and capacity.:String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError

[NBroomfield]

+1 I'm getting the same issue, any update on this?

[RakeshMohanMSFT]

Duplicate issue of #13600