Changeset 33861

Timestamp:

May 14, 2012, 1:06:24 PM (14 years ago)

Author:

bills

Message:

In pstamptool -revertreq only delete jobs from pstampRequests in 'new' state
if the request has faulted. This was the cause of our disappearing job problem

File:

• tags/ipp-20120404/ippTools/share/pstamptool_revertreq_deletejobs.sql (modified) (1 diff, 1 prop)

tags/ipp-20120404/ippTools/share/pstamptool_revertreq_deletejobs.sql

@@ -3 +3 @@
 FROM pstampJob
     JOIN pstampRequest USING(req_id)
-WHERE pstampRequest.state = 'new'
+WHERE pstampRequest.state = 'new' 
+    AND pstampRequest.fault > 0