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 warehouse is stuck, the pipeline never finishes. The Warehouse Query Activity -tab won't load (I've waited for an hour).

I can connect to the Warehouse with SSMS and run the query below (by Dave Pinal, https://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/😞

SELECT 
sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time,
req.blocking_session_id,
req.start_Time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

I can see that a query "SELECT * FROM [mySchema].[myTable] WHERE 1=2" is blocking other queries.

When I try to end that session (kill [session_id]), the session isn't stopped, instead it's status changes to "KILLED/ROLLBACK". I have no idea why SELECT needs a rollback, but maybe that's a question for another day.

I haven't run that sort of query manually or from the pipeline. In the pipeline's Copy Data -task, I've enabled "Auto create table" to the destination, maybe the query is automatically created from that?

What should I do ? The query is stuck and I can't run the pipeline because of that. I can't pause the Fabric capacity because we've got number of workspaces connected to that capacity.