Changeset 38882

Timestamp:

Oct 17, 2015, 10:27:11 PM (11 years ago)

Author:

eugene

Message:

check all db connections

File:

• trunk/ippToPsps/jython/dvo.py (modified) (3 diffs)

trunk/ippToPsps/jython/dvo.py

@@ -180 +180 @@
                 print "--- " + tableName + " : " + str(tableRows)
                 
+                sql = "show tables"
+                rs = self.gpc1Db.executeQuery(sql)
+                rs.first()
+                tableName = rs.getString(1)
+                print "--- " + tableName
+                
+                sql = "show tables"
+                rs = self.ippToPspsDb.executeQuery(sql)
+                rs.first()
+                tableName = rs.getString(1)
+                print "--- " + tableName
+                
                 continue
             dvopspsRunning = False
@@ -228 +240 @@
         cmd += " -D CATDIR " + self.skychunk.dvoLocation
 
-        self.dvopspsRunWithPoll(cmd,"dvoSkyTable",4)
+        self.dvopspsRunWithPoll(cmd, "dvoSkyTable", 30)
 
         self.logger.infoPair("Adding index to", self.scratchDb.dvoSkyTable)
@@ -738 +750 @@
         ## dvopsps can take a very long time. try 2 or 3 times to re-establish communication with the db before proceeding?
         ## NOTE: fixed with a poll?
-        self.dvopspsRunWithPoll(cmd,self.scratchDb.dvoDetectionTable,2)
+        self.dvopspsRunWithPoll(cmd, self.scratchDb.dvoDetectionTable, 300)
 
         self.ippToPspsDb.setIngestedBox(boxId, self.scratchDb.dbHost)