Changeset 38884 for trunk/ippToPsps/jython/dvo.py

Timestamp:

Oct 18, 2015, 10:21:02 AM (11 years ago)

Author:

eugene

Message:

test queries to all 3 connections to keep them alive while dvopsps runs

File:

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

trunk/ippToPsps/jython/dvo.py

@@ -158 +158 @@
     def dvopspsRunWithPoll(self,cmd,myTable,waittime):
 
-        # timeout_sql = "set wait_timeout = 5"
-        # self.scratchDb.execute(timeout_sql)
-
-        ## sql = "set global wait_timeout = 4"
-        ## print "---- sql: " + sql
-        ## self.scratchDb.execute(sql)
+        # sql = "set global wait_timeout = 2"
+        # print "---- sql: " + sql
+        # self.scratchDb.execute(sql)
 
         (dvoStdoutFile, dvoStdoutName) = tempfile.mkstemp(prefix="dvopsps.stdout.", dir="/tmp")
@@ -197 +194 @@
                 tableName = rs.getString(1)
                 print "--- " + tableName
-                
+
                 continue
+
             dvopspsRunning = False
             if p.returncode < 0:
@@ -246 +244 @@
         cmd += " -D CATDIR " + self.skychunk.dvoLocation
 
-        self.dvopspsRunWithPoll(cmd, "dvoSkyTable", 2)
+        self.dvopspsRunWithPoll(cmd, "dvoSkyTable", 30)
 
         self.logger.infoPair("Adding index to", self.scratchDb.dvoSkyTable)