Changeset 38586 for trunk/ippTools/share/pstamptool_pendingdependent.sql

Timestamp:

Jul 14, 2015, 1:54:16 PM (11 years ago)

Author:

bills

Message:

Add a task to queue cleanup of images that have been updated for postage stamp requests.
It runs twice a day and discovers whether or not there are any unfinished postage stamp
dependents. If not queues all of the chip, warp, and diff runs in gpc1 database with label like ps_ud%
to be cleaned. If there are outstanding dependents it does not queue the updates since we don't
want to cause problems with the postage stamp jobs that are depending on them.
This should be much better than the formerly manual process which got done whenever Bill happened to think of it.

File:

• trunk/ippTools/share/pstamptool_pendingdependent.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_pendingdependent.sql

@@ -10 +10 @@
 LEFT JOIN Label ON pstampRequest.label = Label.label
 WHERE pstampDependent.state = 'new'
-    AND pstampDependent.fault = 0
     AND pstampJob.state = 'run'
     AND pstampRequest.state = 'run'