Changeset 18395 for trunk/ippTools/share

Timestamp:

Jul 1, 2008, 4:04:24 PM (18 years ago)

Author:

jhoblitt

Message:

don't remove faults less than 10 minutes old

File:

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

trunk/ippTools/share/pztool_revert_fileset_faults.sql

@@ -2 +2 @@
 WHERE
     fault != 0
+    -- fault is older than 10 minutes
+    AND ABS(TIMESTAMPDIFF(SECOND, epoch, NOW())) > 60 * 10 
     -- fault was logged in the last 3 days
     AND ABS(TIMESTAMPDIFF(SECOND, epoch, NOW())) < 86400 * 3