TAC hung in 'requesting stop...' status ! - can't be recovered

One Star

TAC hung in 'requesting stop...' status ! - can't be recovered

Hi, Guys -
We met an urgent issue in our PROD service.
it is in TAC, one job showed as "Requesting stop..." status, and can't be recovered - it impact daily data loading.
i tried below solutions, still didn't work
1. i clicked kill in TAC - didn't work
2. i restarted all talend related service - didn't work
3. i cleaned all files in /command-line_workspace and restart commandline - didn't work

and i checked talend DB data: select * from executiontask
- found always the status='REQUESTING_STOP' and processingstate=1

question is :
how can i recover this job ?
why even restart server won't solve this ?
can i update the db data directly as a urgent solution ?

anyone have idea of this, please share your mind. Thanks very much!
One Star

Re: TAC hung in 'requesting stop...' status ! - can't be recovered

update the database column from requesting_stop to Deploy or Generate and processingstate to 0
One Star

Re: TAC hung in 'requesting stop...' status ! - can't be recovered

thanks for your reply, aesgs!
we are thinking to re-deploy it to avoid unexpected issues.