Ticket #112 (closed defect: fixed)
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
Note: See
TracTickets for help on using
tickets.
