Geo-restore from Zone-Redundant HA MySQL Flexible Server to paired region (UK West) fails with HaNotSupportedForLocationNotSupportZRS #33813

Activity

1. NeilRedfern

   added

   bugThis issue requires a change to an existing behavior in the product in order to be resolved.This issue requires a change to an existing behavior in the product in order to be resolved.

   on Jul 30, 2026
2. yonzhan commented on Jul 30, 2026

   

   Yong Zhang (yonzhan)

   on Jul 30, 2026

   Collaborator

   More actions

   Thank you for opening this issue, we will look into it.
3. microsoft-github-policy-service

   added

   customer-reportedIssues that are reported by GitHub users external to the Azure organization.Issues that are reported by GitHub users external to the Azure organization.

   Auto-AssignAuto assign by botAuto assign by bot

   MySQL

   Service AttentionThis issue is responsible by Azure service team.This issue is responsible by Azure service team.

   act-codegen-extensibility-squad

   on Jul 30, 2026
4. Aditya Pujara (a0x1ab)

   assigned

   Copilot

   and

   Aditya Pujara (a0x1ab)

   on Jul 30, 2026
5. x-engineering-agent commented on Jul 30, 2026

   

   x-engineering-agentbot

   on Jul 30, 2026 – with X Engineering Agent

   Contributor

   More actions

   Bug Analysis

   az mysql flexible-server geo-restore from a source server configured with Zone-Redundant HA (ZRS) fails with HaNotSupportedForLocationNotSupportZRS when the target region (e.g. UK West) does not support Availability Zones / ZRS.

   Root cause: PR #33428 removed the ability to explicitly specify storage redundancy on geo-restore, and the command now always mirrors the source server's storage redundancy (ZRS) onto the target server. When the target region does not support ZRS, the backend rejects the request with HaNotSupportedForLocationNotSupportZRS, even though the user only wants geo-redundant backups without zone-redundant HA in the DR region.

   Suggested fix: Restore the ability to control storage/HA redundancy on geo-restore (e.g. reintroduce or expose a --zone/--storage-redundancy/HA-mode parameter, or fall back to non-ZRS HA when the target region lacks ZRS support) in src/azure-cli/azure/cli/command_modules/rdbms (MySQL flexible-server geo-restore path). Look at what PR #33428 changed to understand the previous behavior and reintroduce equivalent control without regressing that PR's original fix.

   Repro:

   az mysql flexible-server geo-restore \
     --location ukwest \
     --source-server <resource-id> \
     --name <server-name> \
     --resource-group <rg>
   

   Source server: UK South, Zone-Redundant HA + geo-redundant backups. Target: UK West (no ZRS support). Fails today; blocks documented DR procedures for regions without AZ support.

   Use this EXACT PR title: [MySQL] Fix #33813: az mysql flexible-server geo-restore: restore ZRS-not-supported error for geo-restore to non-ZRS regions

   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 #33813: `az mysql flexible-server geo-restore`: restore ZRS-not-supported error for geo-restore to non-ZRS regions
   

   Keep the backticks around the command and the Fix #33813: 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 #33813.
   • 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.

   ---

   Posted by agent-assist (autonomous bug-fix pipeline).
6. Copilot

   linked a pull request that will close this issue[MySQL] `az mysql flexible-server geo-restore`: do not force source storage redundancy on target #33814on Jul 30, 2026
7. Yabo Hu (VeryEarly)

   closed this as completedin #33814on Aug 21, 2026