search

Azure / azure-sdk-for-net

This repository is for active development of the Azure SDK for .NET. For consumers of the SDK we recommend visiting our public developer docs at https://learn.microsoft.com/dotnet/azure/ or our versioned developer docs at https://azure.github.io/azure-sdk-for-net.
MIT License
5.36k stars 4.79k forks source link

[BUG] Azure database status is 'Online' when its 'Paused' #46513

Open stashut opened 5 days ago

stashut commented 5 days ago

Library name and version

Azure.ResourceManager.Sql

Describe the bug

The core problem appears to be related to Azure Status handling. I have a database 'TestDB' set with an auto-pause delay for testing different statuses. In the SQL Databases section, the status is shown as 'Paused'

testDB

However, when querying the same database in Azure Resource Graph Explorer, the status is returned as 'Online', which is also the status reflected in my application. This discrepancy indicates some inconsistencies in how the status is being reported.

ql

after a while (like 6-8 hours) status polled as paused P.S I created same issue before but pointed on the wrong library

Expected behavior

Database status reflecting correctly with auto-pause delay

Actual behavior

Database status does not reflect correctly with auto-pause delay, Azure Resource Graph Explorer returns status as 'Online' for a few hours when on database UI its 'Paused'

Reproduction Steps

1.Create sql DB

  1. Set auto-pause delay for 1 hour
  2. wait for status to be 'Paused' on UI
  3. Go to Azure Resource Graph Explorer and query for DB
  4. Find properties of DB
  5. Status is 'Online' instead of 'Paused'

Environment

No response

github-actions[bot] commented 5 days ago

Thank you for your feedback. Tagging and routing to the team member best able to assist.