From 9d2d8fa66b5e6548754f978e1dea015609b50ca1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Franti=C5=A1ek=20Dvo=C5=99=C3=A1k?= Date: Thu, 5 Mar 2015 00:00:29 +0100 Subject: [PATCH] Set timestamps more precicely on the end of the long transactions. --- jobs.py | 2 ++ 1 file changed, 2 insertions(+) diff --git a/jobs.py b/jobs.py index 84d6a96..725c7ed 100755 --- a/jobs.py +++ b/jobs.py @@ -362,6 +362,8 @@ for id, job in jobs.iteritems(): for nodename, node in nodes.iteritems(): st.execute("INSERT INTO node (jobid, host, elapsed, map, reduce) VALUES (%s, %s, %s, %s, %s)", (id, nodename, node.elapsed, node.map, node.reduce)) if debug >= 2: print '[db] job %s nodes updated' % id + # better to update timestamp exlicitly on the end of the transaction + st.execute('UPDATE job SET changed=NOW() WHERE id=%s', id); if db: db.commit() -- 1.8.2.3