Background Process Stuck


#1

Hello,

I marked all the Contractors and deleted them 5 hours ago and Yeti is still processing the task. Please find the attachment of the background tasks.
https://drive.google.com/open?id=1U7y-7rZ6gKpb8FrLqaGJOm9oQwEHGi1G


#2

The background process is still stuck since yesterday.


#3

Looks like your contractors have dependent objects - accounts/gateways/dialpeers …


#4

i have deleted the dialpeers, Cleaned it and uploaded new Dialpeers for a Different Contractor but still the background process is running ?
is there any way i can kill the job ?


#5

The Delayed Job is using 100% of the CPU, How do i kill and stop the process ?


#6

Looks like your delayed job process still importing some data in background. You can kill it using kill command, but also you should manually remove task from delayed_jobs table


#7

Can you please share the command ? i tried killing it with the PID but it did not work, also i need to delete the task from database ?


#8

how do i force stop the delays jobs ? it is still running since past 2 days.


#9

any luck ?


#10

could you show current content of background tasks table?


#11

here is the current content.

https://drive.google.com/open?id=1T7fHLrIwqC9DZR_Lt7AwtDgX86tDWcBI


#12

Looks like a bug. I will try to reproduce this situation. You can try to remove this task by SQL:

delete from sys.delayed_jobs where id in(255,258);

and restart delayed job processes.


#13

the sql command removed the Background Task, Thanks.