Changeset 35222

Timestamp:

Mar 3, 2013, 1:22:47 PM (13 years ago)

Author:

eugene

Message:

add an index to stackdetection; give an error message for failed attempts to kill the mysql connection

Location:

trunk/ippToPsps/jython

Files:

• mysql.py (modified) (1 diff)
• objectbatch.py (modified) (1 diff)
• stackbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/mysql.py

@@ -84 +84 @@
         connectionID = self.getLastConnectionID()
         if connectionID == self.connectionID:
+            print "not killing connection: ", connectionID
             self.logger.debug("NOT going to kill THIS connection ID")
             return
 
         sql = "KILL %d" % connectionID
-        self.execute(sql)
+
+        try:
+            self.execute(sql)
+        except:
+            print "failed to kill connection: ", connectionID
 
     '''

trunk/ippToPsps/jython/objectbatch.py

@@ -54 +54 @@
 
        try:
+           ## XX pass in the existing connection to scratchDb
            self.dvoObjects = DvoObjects(self.logger, self.config, self.skychunk, self.ippToPspsDb, self.scratchDb.dbName)
        except:

trunk/ippToPsps/jython/stackbatch.py

@@ -846 +846 @@
         #self.scratchDb.makeColumnUnique("StackDetection", "objID")
         self.scratchDb.createIndex("StackDetection", "ippDetectID")
+        self.scratchDb.createIndex("StackDetection", "stackDetectID")
         self.scratchDb.createIndex("StackApFlx", "ippDetectID")
         self.scratchDb.createIndex("StackModelFit", "ippDetectID")