Changeset 15159

Timestamp:

Oct 1, 2007, 6:21:35 PM (19 years ago)

Author:

jhoblitt

Message:

attempt to work around transactional deadlock by setting the transaction mode

File:

• trunk/ippTools/src/pzgetimfiles.c (modified) (1 diff)

trunk/ippTools/src/pzgetimfiles.c

@@ -297 +297 @@
     }
 
+    if (!p_psDBRunQuery(config->dbh, "SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED")) {
+        // rollback
+        if (!psDBRollback(config->dbh)) {
+            psError(PS_ERR_UNKNOWN, false, "database error");
+        }
+        psError(PS_ERR_UNKNOWN, false, "database error");
+        return false;
+    }
+
     // copy imfiles (files) from the temp table into summitImfiles
     {