Skip to content

az mysql flexible-server list-skus does not list any SKU's for any region #31568

Closed

Description

@MelleNooijen

Describe the bug

Trying to look for SKU's to use for a MySQL Flexible Server does not return any SKU's, no matter the selected region. Deploying with SKU's from docs (i.e. Standard_B1ms) indicates the SKU is invalid.

❯ az mysql flexible-server list-skus -l westeurope

For prices please refer to https://aka.ms/mysql-pricing
[]
❯ az mysql flexible-server list-skus -l northeurope

For prices please refer to https://aka.ms/mysql-pricing
[]
❯ az mysql flexible-server list-skus -l westus

For prices please refer to https://aka.ms/mysql-pricing
[]

Related command

az mysql flexible-server list-skus -l (region)

Errors

N.A.

Issue script & Debug output

cli.knack.cli: Command arguments: ['mysql', 'flexible-server', 'list-skus', '-l', 'westeurope', '--debug']
cli.knack.cli: __init__ debug log:
Enable color in terminal.
[...]
cli.azure.cli.core.sdk.policies: Request URL: 'https://management.azure.com/subscriptions/***/providers/Microsoft.DBforMySQL/locations/westeurope/capabilities?api-version=2024-10-01-preview'
cli.azure.cli.core.sdk.policies: Request method: 'GET'
cli.azure.cli.core.sdk.policies: Request headers:
cli.azure.cli.core.sdk.policies:     'Accept': 'application/json'
cli.azure.cli.core.sdk.policies:     'x-ms-client-request-id': '***'
cli.azure.cli.core.sdk.policies:     'CommandName': 'mysql flexible-server list-skus'
cli.azure.cli.core.sdk.policies:     'ParameterSetName': '-l --debug'
cli.azure.cli.core.sdk.policies:     'User-Agent': 'AZURECLI/2.73.0 (HOMEBREW) azsdk-python-core/1.31.0 Python/3.12.10 (macOS-15.4.1-arm64-arm-64bit)'
cli.azure.cli.core.sdk.policies:     'Authorization': '*****'
cli.azure.cli.core.sdk.policies: Request body:
cli.azure.cli.core.sdk.policies: This request has no body
urllib3.connectionpool: Starting new HTTPS connection (1): management.azure.com:443
urllib3.connectionpool: https://management.azure.com:443 "GET /subscriptions/***/providers/Microsoft.DBforMySQL/locations/westeurope/capabilities?api-version=2024-10-01-preview HTTP/1.1" 200 12
cli.azure.cli.core.sdk.policies: Response status: 200
cli.azure.cli.core.sdk.policies: Response headers:
cli.azure.cli.core.sdk.policies:     'Cache-Control': 'no-cache'
cli.azure.cli.core.sdk.policies:     'Pragma': 'no-cache'
cli.azure.cli.core.sdk.policies:     'Content-Length': '12'
cli.azure.cli.core.sdk.policies:     'Content-Type': 'application/json; charset=utf-8'
cli.azure.cli.core.sdk.policies:     'Expires': '-1'
cli.azure.cli.core.sdk.policies:     'X-Content-Type-Options': 'nosniff'
cli.azure.cli.core.sdk.policies:     'x-ms-request-id': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-operation-identifier': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-ratelimit-remaining-subscription-reads': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-ratelimit-remaining-subscription-global-reads': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-correlation-request-id': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-routing-request-id': '***'
cli.azure.cli.core.sdk.policies:     'Strict-Transport-Security': 'max-age=31536000; includeSubDomains'
cli.azure.cli.core.sdk.policies:     'X-Cache': 'CONFIG_NOCACHE'
cli.azure.cli.core.sdk.policies:     'X-MSEdge-Ref': '***'
cli.azure.cli.core.sdk.policies:     'Date': 'Wed, 28 May 2025 11:57:59 GMT'
cli.azure.cli.core.sdk.policies: Response content:
cli.azure.cli.core.sdk.policies: {"value":[]}
cli.azure.cli.command_modules.mysql.custom: For prices please refer to https://aka.ms/mysql-pricing
cli.knack.cli: Event: CommandInvoker.OnTransformResult [<function _resource_group_transform at 0x103fdc0e0>, <function _x509_from_base64_to_hex_transform at 0x103fdc180>]
cli.knack.cli: Event: CommandInvoker.OnFilterResult []
[]
cli.knack.cli: Event: Cli.SuccessfulExecute []
cli.knack.cli: Event: Cli.PostExecute [<function AzCliLogging.deinit_cmd_metadata_logging at 0x103f83a60>]
az_command_data_logger: exit code: 0
cli.__main__: Command ran in 0.489 seconds (init: 0.061, invoke: 0.428)
telemetry.main: Begin splitting cli events and extra events, total events: 1
telemetry.client: Accumulated 0 events. Flush the clients.
telemetry.main: Finish splitting cli events and extra events, cli events: 1
telemetry.save: Save telemetry record of length 3996 in cache file under /Users/***/.azure/telemetry/20250528135800980
telemetry.main: Begin creating telemetry upload process.
telemetry.process: Creating upload process: "/opt/homebrew/Cellar/azure-cli/2.73.0/libexec/bin/python /opt/homebrew/Cellar/azure-cli/2.73.0/libexec/lib/python3.12/site-packages/azure/cli/telemetry/__init__.py /Users/***/.azure /Users/***/.azure/telemetry/20250528135800980"
telemetry.process: Return from creating process 25744
telemetry.main: Finish creating telemetry upload process.

Expected behavior

It lists SKU's as usual.

Environment Summary

azure-cli                         2.73.0

core                              2.73.0
telemetry                          1.1.0

Extensions:
account                            0.2.5
rdbms-connect                      1.0.7

Dependencies:
msal                              1.32.3
azure-mgmt-resource               23.3.0

Python location '/opt/homebrew/Cellar/azure-cli/2.73.0/libexec/bin/python'
Config directory '/Users/***/.azure'
Extensions directory '/Users/***/.azure/cliextensions'

Python (Darwin) 3.12.10 (main, Apr  8 2025, 11:35:47) [Clang 17.0.0 (clang-1700.0.13.3)]

Legal docs and information: aka.ms/AzureCliLegal


Your CLI is up-to-date.

Additional context

Tried both on macOS and Windows with different tenants and subscriptions with the same result.

Activity

  1. added
    bugThis issue requires a change to an existing behavior in the product in order to be resolved.
    on May 28, 2025
  2. yonzhan commented on May 28, 2025

    @yonzhan
    Collaborator

    Thank you for opening this issue, we will look into it.

  3. microsoft-github-policy-service commented on May 28, 2025

    @microsoft-github-policy-service
    Contributor

    Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc Amol Bhatnagar (@ambhatna), Parikshit Savjani (@savjani).

  4. honghr commented on Sep 9, 2025

    @honghr
    Contributor
    C:\Users\xxx>az mysql flexible-server list-skus -l westeurope
    For prices please refer to https://aka.ms/mysql-pricing
    [
      {
        "supportedFlexibleServerEditions": [
          {
            "name": "Burstable",
            "supportedServerVersions": [
              {
                "name": "5.7",
                "supportedSkus": [
                  {
                    "name": "Standard_B1ms",
                    "supportedIops": 640,
                    "supportedMemoryPerVCoreMb": 2048,
                    "vCores": 1
                  },
                  {
                    "name": "Standard_B1s",
                    "supportedIops": 400,
                    "supportedMemoryPerVCoreMb": 1024,
                    "vCores": 1
                  },
                  ....
    
  5. raphaelpoumarede commented on Dec 1, 2025

    @raphaelpoumarede

    I still don't see any available SKU in any region when running the command....
    here is my test script:

    #!/usr/bin/env bash
    
    regions=(
    australiacentral
    australiasoutheast
    canadaeast
    eastasia
    eastus2
    germanynorth
    germanywestcentral
    centralindia
    southindia
    japanwest
    koreasouth
    northcentralus
    norwayeast
    norwaywest
    swedencentral
    uaenorth
    ukwest
    westcentralus
    westus
    westus2
    westus3
    brazilsouth
    brazilsoutheast
    francecentral
    francesouth
    southafricanorth
    southafricawest
    southeastasia
    northeurope
    australiaeast
    japaneast
    koreacentral
    uksouth
    westeurope
    canadacentral
    centralus
    eastus
    switzerlandnorth
    switzerlandwest
    southcentralus
    polandcentral
    italynorth
    israelcentral
    uaecentral
    spaincentral
    mexicocentral
    jioindiawest
    jioindiacentral
    newzealandnorth
    indonesiacentral
    malaysiawest
    chilecentral
    austriaeast
    belgiumcentral
    australiacentral2
    qatarcentral
    )
    
    echo "Checking Azure MySQL Flexible Server SKU availability..."
    echo "=========================================================="
    echo
    
    for region in "${regions[@]}"; do
        echo "Region: $region"
        
        # Fetch SKUs
        skus=$(az mysql flexible-server list-skus -l "$region" --query "value[].name" -o tsv 2>/dev/null)
    
        if [ -z "$skus" ]; then
            echo "  ❌ No SKUs available (or region not supported / capacity issue)"
        else
            echo "  ✅ SKUs available:"
            echo "$skus" | sed 's/^/    - /'
        fi
    
        echo
    done

    and here is the result:

    Region: australiacentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: australiasoutheast
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: canadaeast
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: eastasia
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: eastus2
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: germanynorth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: germanywestcentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: centralindia
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: southindia
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: japanwest
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: koreasouth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: northcentralus
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: norwayeast
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: norwaywest
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: swedencentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: uaenorth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: ukwest
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: westcentralus
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: westus
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: westus2
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: westus3
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: brazilsouth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: brazilsoutheast
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: francecentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: francesouth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: southafricanorth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: southafricawest
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: southeastasia
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: northeurope
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: australiaeast
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: japaneast
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: koreacentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: uksouth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: westeurope
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: canadacentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: centralus
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: eastus
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: switzerlandnorth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: switzerlandwest
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: southcentralus
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: polandcentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: italynorth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: israelcentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: uaecentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: spaincentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: mexicocentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: jioindiawest
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: jioindiacentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: newzealandnorth
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: indonesiacentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: malaysiawest
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: chilecentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: austriaeast
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: belgiumcentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: australiacentral2
      ❌ No SKUs available (or region not supported / capacity issue)
    
    Region: qatarcentral
      ❌ No SKUs available (or region not supported / capacity issue)
    
    
  6. raphaelpoumarede commented on Dec 1, 2025

    @raphaelpoumarede

    it works with az cli 2.80 and using the --subscription. But in this case the -o table or -o tsv don't work...

  7. x-engineering-agent commented on Jul 17, 2026

    @x-engineering-agent
    Contributor

    X Engineering Agent Bug analysis: Root cause analysis

    az mysql flexible-server list-skus -l <region> returns an empty list ([]) for every region, even though the underlying ARM API
    (GET /subscriptions/***/providers/Microsoft.DBforMySQL/locations/<region>/capabilities?api-version=2024-10-01-preview) returns
    {"value":[]} for some regions/subscriptions, while a comment from another user shows the same command did return SKUs
    for other regions/subscriptions and with an older CLI version (2.80). This points to a regression tied to the API version
    used in the mysql command module — likely api-version=2024-10-01-preview returning empty supportedFlexibleServerEditions
    for capabilities that an older/newer api-version populates correctly, or a missing --subscription/scope handling regression
    noted by raphaelpoumarede ("it works ... using the --subscription").

    Please investigate:

    • The list-skus command implementation in src/azure-cli/azure/cli/command_modules/mysql/custom.py (or wherever the
      capabilities call is made for MySQL flexible server).
    • Whether the api-version used for the capabilities call needs to be updated/pinned to one that reliably returns
      supportedFlexibleServerEditions, matching the behavior reported by honghr where the same command returned full SKU data.
    • Confirm the --subscription scoping doesn't silently affect the resolved provider registration state used for this call.

    Repro:

    az mysql flexible-server list-skus -l westeurope
    az mysql flexible-server list-skus -l northeurope
    az mysql flexible-server list-skus -l westus
    

    Expected: a non-empty list of supported SKUs (as seen previously and by other users), matching the ARM capabilities API
    data for Microsoft.DBforMySQL.

    Use this EXACT PR title: [MySQL] Fix #31568: az mysql flexible-server list-skus: Fix empty SKU list returned by list-skus

    PR title & description format (required)

    This repo enforces a PR format (guide). Please author the PR exactly as follows or CI's Check the Format of Pull Request Title and Content will fail.

    Use this EXACT PR title (copy verbatim, do not reword):

    [MySQL] Fix #31568: `az mysql flexible-server list-skus`: Fix empty SKU list returned by list-skus
    

    Keep the backticks around the command and the Fix #31568: prefix. You may only adjust the wording after the command (the final summary) if the fix changes; the [MySQL] prefix, issue link, and backticked command must stay.

    Description — follow the PR template and fill in:

    • Link the issue — start the Description with a closing keyword so the PR auto-links and closes it: Fixes #31568.
    • Related command — the az ... command this affects.
    • Description (mandatory) — why the bug happens, what you changed, and the resulting behavior.
    • Testing Guide — example command(s) showing the fix works.
    • History Notes — leave the title to drive the history note, or add extra lines in the same format (component in brackets + the command in backticks), e.g. [MySQL] `az <command>`: <note>.
    • Keep the template checklist and tick the items you've satisfied.

    X Engineering Agent · Fixer · react 👍 / 👎 to train the agent

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

Auto-AssignAuto assign by botMySQLService AttentionThis issue is responsible by Azure service team.act-codegen-extensibility-squadbugThis issue requires a change to an existing behavior in the product in order to be resolved.customer-reportedIssues that are reported by GitHub users external to the Azure organization.

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions