Project

General

Profile

Bug #14476

Jobs are not going to "Located" state when they have 0 output files

Added by Marc Mengel almost 4 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
11/10/2016
Due date:
% Done:

100%

Estimated time:
First Occurred:
Scope:
Internal
Experiment:
-
Stakeholders:
Duration:

Description

Need to run:
update jobs set status = 'Located' where status = 'Completed' and (select count(file_name) from job_files where job_files.job_id = jobs.job_id and job_files.file_type = 'output') = 0;

periodically to fix this blind spot.

History

#1 Updated by Marc Mengel almost 4 years ago

  • % Done changed from 0 to 80

e6c1c7d61e5 -- query update redone in sqlalchemy Lightly tested.

#2 Updated by Marc Mengel almost 4 years ago

  • Status changed from Assigned to Closed

#3 Updated by Marc Mengel almost 4 years ago

  • % Done changed from 80 to 100

Also available in: Atom PDF