Active Processes stuck

rocketman

I have three active processes that are still running (from 10th June 2023. I cannot kill them off from within the user admin interface. they just won't "Cancel" So maybe using MySQL workbench or similar, is there a way I can kill these without having to bring down the server. They are preventing me from publishing a new version
EDIT I have deleted the offending active processes from Execution context but AIM still comes back and says there are active processes still running

Supplementary question - why does this keep happening? A couple of months ago I found 250+ processes in "Execution context"

rocketman

UPDATE I restarted the server - but surely I shouldn’t have to do this? also Execution Context records needs a couple of more attributes in my opinion

1) Process started tinestamp
2) Business space that triggered it

PLUS a kill switch that works no matter what

hpl123

rocketman wrote
UPDATE I restarted the server - but surely I shouldn’t have to do this? also Execution Context records needs a couple of more attributes in my opinion

1) Process started tinestamp
2) Business space that triggered it

PLUS a kill switch that works no matter what

gernotlg

Is it fixed in v9 ?

Same thing... I have processes that are 100's of BS versions (minor) old that are still running from months and months ago..

Many server restarts later.

Cancel doesn't work.

What gives ?

BLOMASKY

When I am ready to restart the server, I always run the following sql script. "delete from Aware.dbo.EXECUTION_CONTEXTS"

Execution_Contexts always has 20-60 old thingies hanging around.

Bruce

rocketman

UPDATE,

I can kill processes in the following way. (I'm using workbench but these can be run from the command line client also

1) Show processlist

2) When the list comes up select the offending process - if you are multi hosting it will have the BSV name do KILL [process ID}

No need for a server restart