How to delete failed tasks?

user123 · April 16, 2021, 6:35am

Infos:

Used Zammad version: 4.0
Used Zammad installation type: repo centos 7
Operating system: centos 7
Browser + version: Firefox 78.9.0esr

I am seeing failed tasks under Current Status on the Monitoring page:

It is not relevant why they failed in the past.

Expected behavior:

having a mean to remove this message from the monitoring, because I do not care anymore

Actual behavior:

constantly showing this kind of old messages

baseline · April 23, 2021, 10:17am

Hello,
we have the same problem.
I have found the problem and the Last task Finished Succesfully, but how to delete the failed Task?

olafbuitelaar · April 23, 2021, 10:57am

maybe this thread is of any help?

user123 · April 23, 2021, 11:13am

Thanks for the link, but as far as I see this is not helpfull:

# zammad run rails c
Loading production environment (Rails 5.2.4.5)
irb(main):001:0> Delayed::Job.count
=> 0
irb(main):002:0> Delayed::Job.first
=> nil
irb(main):003:0> Delayed::Job.last
=> nil

olafbuitelaar · April 23, 2021, 11:19am

maybe try it on the; DataPrivacyTask instead of Delayed?

olafbuitelaar · April 23, 2021, 11:23am

this appears to be the code, that is reporting the stuck tasks;

github.com

zammad/zammad/blob/e7b0486b5bb8178d2ecc63f0e3c279525851d3f0/app/controllers/monitoring_controller.rb#L167


    dry_run:     false,
    finished_at: nil,
  ).where('updated_at <= ?', 5.minutes.ago).limit(1).first


  next if job.blank?


  issues.push "Stuck import backend '#{backend}' detected. Last update: #{job.updated_at}"
end


# stuck data privacy tasks
DataPrivacyTask.where.not(state: 'completed').where('updated_at <= ?', 30.minutes.ago).find_each do |task|
  issues.push "Stuck data privacy task (ID #{task.id}) detected. Last update: #{task.updated_at}"
end


token = Setting.get('monitoring_token')


if issues.blank?
  result = {
    healthy: true,
    message: 'success',
    issues:  issues,

maybe you can adopt it to delete the tasks

user123 · June 11, 2021, 6:20am

Yes, that was helpfull, thanks. I could remove the failed task with this command:

DataPrivacyTask.find(40).destroy

The id was displayed on the monitoring page in the backend.

system · October 9, 2021, 6:20am

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.