Index: trunk/ippToPsps/jython/dvo.py
===================================================================
--- trunk/ippToPsps/jython/dvo.py	(revision 33780)
+++ trunk/ippToPsps/jython/dvo.py	(revision 33781)
@@ -16,5 +16,4 @@
 from java.lang import *
 from java.sql import *
-
 
 '''
@@ -90,5 +89,4 @@
             return
 
-
     '''
     Loads the DVO Photcodes.dat FITS file
@@ -218,4 +216,5 @@
         self.regionsAlreadyIngested = []
         self.regionsIngestedButOutOfDate = []
+        self.tablesToCleanup = []
 
         # loop through all regions in DVO inside this bounding-box
@@ -256,4 +255,11 @@
                continue
 
+           # we have no record of ingesting this region, but does the table exist? 
+           # May hev been left behind after a crash, and therefore needs to be cleaned-up
+           for fileType in self.ingestFileTypes:
+               tableName = self.scratchDb.getDbFriendlyTableName(regionPath + "." + fileType)
+               if self.scratchDb.tableExists(tableName):
+                   tablesToCleanup.append(tableName)
+
            # check if we have out-of-date versions of any interested files, if so, add region to the purge list
            outOfDate = False
@@ -279,4 +285,10 @@
         self.sizeOfRegionsToPurge = self.getDiskSizeOfRegions(self.regionsToPurge)
         self.sizeOfRegionsToIngest = self.getDiskSizeOfRegions(self.regionsToIngest)
+
+        # any tables need cleaning up?
+        if len(tablesToCleanup) > 0:
+            self.logger.infoPair("Found tables to be cleaned up", "%d" % len(tablesToCleanup))
+            self.scratchDb.dropTables(tablesToCleanup)
+            
 
     '''