Azure / Azure/azure-cli

AZ CLI command fails to update secondary azure SQL database part of FailoverGroup/GeoReplication

Open
#17,970 2 comments 0 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad Service Attention SQL
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

> ### `az feedback` auto-generates most of the information requested below, as of CLI version 2.0.62

**Describe the bug**
Updating the SLO of the secondary server which is part of FailoverGroup/geo replication is not working with AZ CLI, however this works with SLO. Please note that updating the SLO of primary works , issue occurs only with secondary. Error received "The request body for the create or update database operation is invalid."

**To Reproduce**
Please run this command for a secondary database to reproduce the issue. az sql db update --ids ' ' --capacity ' ' --compute-model ' ' --edition ' '.

**Expected behavior**
CLI command should be able to update the secondary as well.

**Environment summary**
Try CLI from azure portal or PowerShell

**Additional context**
Latest API version (https://management.azure.com/subscriptions/1ec3a795-09b0-4d8c-b5cb-a13f6063cec9/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}?api-version=2020-11-01-preview) fails but this appear to with the API version '2020-02-02 preview'.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.