My Fabric Data Warehouse is stuck

[stevehogg]

For the past 24 hours none of the sessions have completed and when I kill a session it remains in a status of 'running' and the command 'KILLED/ROLLBACK'. I'm lost, don't know what to try next. As of this minute my Data Warehouse is not responding although I can run the DMV views. Any suggestions?

[stevehogg · Accepted solution]

And, this morning, it's magically resolved. The problem began Sat morning at 8am and this morning, Tuesday (3 days later), it is resolved. Nothing was done on my part it's just resolved. Last night I saw 2100 open sessions in a status of 'running'. This morning, I see 2 open sessions and the warehouse is responding normally again.

[Anonymous]

Hi @stevehogg ,

You can follow the steps below to troubleshoot your problem:

1. Check the status of the repository and make sure it is not suspended. Do not immediately retry the failed command. Instead, wait 5 to 10 minutes, establish a new connection, and then retry the command. Sometimes the Azure system quickly shifts hardware resources to better load balance various workloads.

For more  information about troubleshoot the Warehouse:

Troubleshoot the Warehouse - Microsoft Fabric | Microsoft Learn

2. Try clearing the browser cache.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[stevehogg]

Thanks for the reply. This problem appears to be something which affected the warehouse globally, not just from my browser. Other warehouses on our capacity were working just fine, it was just this one. This morning it is all cleared up and working normally again. Approximately 3 day outage. No solution, it's just resolved. Thanks again.

[Anonymous]

Hi @stevehogg ,

So it sounds like what you were experiencing before seemed to be an issue, anyway glad to hear that you have resolved the issue!

Best Regards,

Ada Wang