Ticket #112 (closed defect: fixed)

Opened 4 years ago

Last modified 3 years ago

cleanup op canceled upload jobs

Reported by: MC-arjen Owned by: robert
Priority: major Milestone: MediaMosa 2.1
Component: Core Version:
Keywords: Cc:
MoSCoW: Must Have Estimated time after impact analysis:
Related to project: none Tested: yes
Accepted: yes Estimated Hours:

Description

The jobhandler module has a cleanup script op uploadjobs

"UPDATE

{job} SET status = '%s', FINISHED= NOW(),
error_description = 'UPLOAD changed timeout expired (%ds)'
WHERE status = '%s' AND job_id IN
(SELECT job_id FROM {upload_job} WHERE NOW()-changed > %d)",
JOBSTATUS_FAILED, JOB_UPLOAD_TIMEOUT, JOBSTATUS_INPROGRESS, JOB_UPLOAD_TIMEOUT

But does not take into account that some jobs are deleted in de upload_job table. The result are dangling jobs in the jobs table which remain "INPROGRESS". It is possible that the cancelling of upload job does not correctly update the job table.

Change History

Changed 3 years ago by Frans

  • related_to set to none
  • milestone changed from MediaMosa X.X to MediaMosa 2.1

Still wanted?

Changed 3 years ago by Frans

  • moscow set to Must Have

Changed 3 years ago by Frans

.....including cleanup of transcoding jobs.

Changed 3 years ago by forgacs

  • owner set to forgacs
  • status changed from new to assigned

Changed 3 years ago by forgacs

  • owner changed from forgacs to arjen

Ready.

Changed 3 years ago by forgacs

  • owner changed from arjen to robert

Changed 3 years ago by forgacs

  • status changed from assigned to closed
  • resolution set to ready_for_review

Changed 3 years ago by robert

  • status changed from closed to reopened
  • resolution ready_for_review deleted

Changed 3 years ago by robert

  • status changed from reopened to closed
  • resolution set to fixed

Changed 3 years ago by Frans

  • tested set to yes
  • accepted changed from no to yes

Not easy to test. Will accept for now.

Note: See TracTickets for help on using tickets.