summaryrefslogtreecommitdiff
path: root/server
diff options
context:
space:
mode:
authorAndrew Gaffney <agaffney@gentoo.org>2008-01-01 02:37:08 +0000
committerAndrew Gaffney <agaffney@gentoo.org>2008-01-01 02:37:08 +0000
commit7beafd3d7f98786a99bb7c80899f11db58c7ae0a (patch)
treeb5cef46796ac2cfaadbebb921ae1441e0f23e9ff /server
parentchomp the line read from client_key (diff)
downloadscire-7beafd3d7f98786a99bb7c80899f11db58c7ae0a.tar.gz
scire-7beafd3d7f98786a99bb7c80899f11db58c7ae0a.tar.bz2
scire-7beafd3d7f98786a99bb7c80899f11db58c7ae0a.zip
modify get_jobs query to make sure to get the latest job_history entry for the job
svn path=/branches/new-fu/; revision=304
Diffstat (limited to 'server')
-rwxr-xr-xserver/scireserver.pl2
1 files changed, 1 insertions, 1 deletions
diff --git a/server/scireserver.pl b/server/scireserver.pl
index 4de6362..fd2da34 100755
--- a/server/scireserver.pl
+++ b/server/scireserver.pl
@@ -208,7 +208,7 @@ sub get_jobs {
AND jobs.jobid = jobs_clients.jobid
AND (job_conditions.deploy_time < now())
AND (job_conditions.expiration_time > now())
- AND job_history.statusid = '?'
+ AND (SELECT statusid FROM job_history WHERE jobid=jobs.jobid ORDER BY eventtime DESC LIMIT 1)=?
ORDER BY jobs.priority,jobs.created
EndOfQuery