Changeset 18399

Timestamp:

Jul 1, 2008, 5:04:47 PM (18 years ago)

Author:

jhoblitt

Message:

attempt to fix pzDownloadExp locking issues

File:

• trunk/ippTools/src/pzgetimfiles.c (modified) (3 diffs)

trunk/ippTools/src/pzgetimfiles.c

@@ -191 +191 @@
     } 
 
-    // try not to insert duplicate pzPendingExp/pzPendingImfile entries
-
     // create a temp table
     {
@@ -303 +301 @@
     {
         char *query = 
-            "INSERT INTO pzDownloadExp" 
+            "INSERT IGNORE INTO pzDownloadExp" 
             "   SELECT"
             "       incoming.exp_name,"
@@ -311 +309 @@
             "       NULL"
             "   FROM incoming"
-            "   LEFT JOIN pzDownloadExp"
-            "       USING(exp_name, camera, telescope)"
-            "   WHERE"
-            "       pzDownloadExp.exp_name is NULL"
-            "       AND pzDownloadExp.camera is NULL"
-            "       AND pzDownloadExp.telescope is NULL"
             "   GROUP BY"
             "       incoming.exp_name,"