How can I kill a spark query that has been running for a long period of time in Fabric.

[Ali_Cruz]

I found a query in spark UI that has been running for 20 hours but I could not find the way to kill it the query is not showing any Running Job IDs and the previous job assosiated with the query has FAILED status. Here is the query that I saw in Spark UI

This is the job associated with the last Sub Execution IDs

Does any body experience a similar situation before? Is there a way to kill the query that is still running in Spark?

[Ali_Cruz]

Hi @nilendraFabric 

When I checked monitoring hub there was nothing currently running.

I assumed the query was left behind when the process was cancelled due to a time out issue, is there a way to re-start spark instance in Fabric?

[Ali_Cruz]

Hi @nilendraFabric 

I checked monitoring hub but there is nothing in progress

so i assume the query is something left behind when the job was cancelled because a time out, is there any way to re-start spark in fabric?

[Ali_Cruz]

Hi NilendraFabric

Yes I checked in monitoring hub, but there is nothing currently running I just saw the query running in spark UI, I assume that query was left behind when the job was terminanted due to a time out.

[nilendraFabric]

Hi @Ali_Cruz 

Did you checked in monitoring hub?

Navigate to the Monitoring hub in your Fabric workspace.
2. Locate the activity that’s been running for an extended period (e.g., your 20-hour query).
3. Click “Cancel” next to the activity and confirm the action.
4. Wait 2–3 minutes for the system to terminate the process.

No visible Job IDs? This indicates a zombie state. Focus on the Monitoring hub method above

[Ali_Cruz]

Hi @nilendraFabric 

When I checked monitoring hub there was nothing currently running.

I assumed the query was left behind when the process was cancelled due to a time out issue, is there a way to re-start spark instance in Fabric?