From 776fc9f600fd50fc2ff4076d135e7293bb035150 Mon Sep 17 00:00:00 2001
From: tlatorre <tlatorre@uchicago.edu>
Date: Tue, 13 Oct 2020 09:43:01 -0500
Subject: fix bug in submit-grid-jobs queue when running many jobs

---
 utils/submit-grid-jobs-queue | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/utils/submit-grid-jobs-queue b/utils/submit-grid-jobs-queue
index c99a00d..54af499 100755
--- a/utils/submit-grid-jobs-queue
+++ b/utils/submit-grid-jobs-queue
@@ -444,5 +444,6 @@ if __name__ == '__main__':
         except subprocess.CalledProcessError:
             raise
         else:
-            c.execute("UPDATE state SET state = 'RUNNING', nretry = COALESCE(nretry + 1,0) WHERE id IN (%s)" % (','.join(['?']*len(results))), [row['id'] for row in results])
+            for row in results:
+                c.execute("UPDATE state SET state = 'RUNNING', nretry = COALESCE(nretry + 1,0) WHERE id = ?", (row['id'],))
             conn.commit()
-- 
cgit