Forum Discussion

Nameless_LW's avatar
Nameless_LW
Frequent Visitor
1 year ago
Solved

Fabric Warehehouse stuck

I have a Fabric workspace with a Warehouse, a Lakehouse  and a pipeline.   The pipeline is loading a parquet file from Lakehouse to Warehouse, but it gets stuck and times out. At this pois the ware...
Need Help
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    Thanks Nameless_LW 

     

    I think if this happened before worth raising a support ticket, this might be a bug.

     

    please accept the solution if this is helpful 

Nameless_LW's avatar
Nameless_LW
Frequent Visitor
1 year ago

Hi nilendraFabric, thank you for a quick response.

 

I know that SQL Server (and Fabric) should do a Rollback when the session is killed. What I'm struggling to understand is what is it trying to rollback, when the query in question is a plain select...

 

Anyways, I've tried to run "KILL session_id WITH STATUSONLY;", but it's returning:

SPID xxx: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

The query has been in rollback-state for a couple hours now. Apparently the only way out is to contact Microsoft.

 

I've run to this issue before, but last time the session eventually stopped (propably in an hour or so). This time the issue seems to be more persistent.

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

Thanks Nameless_LW 

 

I think if this happened before worth raising a support ticket, this might be a bug.

 

please accept the solution if this is helpful