Changeset 34710

Timestamp:

Nov 27, 2012, 11:38:50 AM (14 years ago)

Author:

bills

Message:

only revert dependents if there is a job running for a request that is running

File:

• tags/ipp-20121026/ippTools/share/pstamptool_revertdependent.sql (modified) (1 diff)

tags/ipp-20121026/ippTools/share/pstamptool_revertdependent.sql

@@ -4 +4 @@
 SET pstampDependent.fault = 0
 -- fault count hook %s
-WHERE pstampDependent.state = 'new'
+WHERE pstampRequest.state ='run'
+    AND pstampJob.state ='run'
+    AND pstampDependent.state = 'new'
     AND (pstampDependent.fault > 0)