Changeset 35429 for trunk/ippTools/share/warptool_pendingcleanupskyfile.sql

Timestamp:

Apr 24, 2013, 3:04:00 PM (13 years ago)

Author:

bills

Message:

include components in state error_cleaned in the list of files pending cleanup
This allows them to be cleaned later.

File:

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

trunk/ippTools/share/warptool_pendingcleanupskyfile.sql

@@ -10 +10 @@
     USING(warp_id)
 WHERE
-   ((warpRun.state = 'goto_cleaned'  AND (warpSkyfile.data_state = 'full'
-                                      OR  warpSkyfile.data_state = 'update')
-    AND warpSkyfile.quality = 0)
+   ((warpRun.state = 'goto_cleaned'  
+       AND (warpSkyfile.data_state = 'full'
+          OR  warpSkyfile.data_state = 'error_cleaned'
+          OR  warpSkyfile.data_state = 'update')
+       AND warpSkyfile.quality = 0)
     OR
     (warpRun.state = 'goto_scrubbed' AND warpSkyfile.data_state != 'scrubbed')