Forum Discussion

tfowles's avatar
tfowles
New Member
3 years ago

Unable to Stop Warehouse Queries

4 days ago, I executed a stored procedure in a Fabric warehouse. The query failed to run. I have since learned that there are limitations to Fabric. The stored procedure I executed had these limitations (querying system tables, using temp tables, etc.).

 

Once it was clear my queries would not succeed, I attempted to kill the session. Unfortunately, the session continued. There was a schema lock in place via another query (I believe caused by querying a system table). Eventually, I deleted the warehouse completely, as it wasn't necessary, and I wanted to push forward with the other tasks I had. The warehouse delete appeared to be successful within the Fabric UI.

 

Today, I attempted to run a different query in a different Fabric warehouse, but attached to the same capacity. The query was unable to complete. When looking at the executing requests, I found that original query present, still in the KILLED/ROLLBACK state. In the Fabric UI, the warehouse is indeed deleted, but in SSMS, I can still see the database. It appears that this query will not be killed, and I am not sure how I can actually stop this query. The last wait type for the query is EDC_EXEC.

 

Any thoughts on what I should look to do next? The warehouse itself is not needed - data loss is acceptable as this is a demo-only warehouse.

 

Thanks!

2 Replies

  • An update on this:

     

    I checked the running queries this morning. I found that, somehow, the queries were no longer running. I was able to delete the old warehouses successfully.

     

    Unfortunately, I'm not sure what caused the queries to stop running.

  • velu's avatar
    velu
    New Member

    Use the Query Activity feature in Power BI Service to cancel any running queries in the warehouse

    Thanks!