aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-10-29 19:39:42 +0000
committerChristopher Baines <mail@cbaines.net>2020-10-29 19:39:42 +0000
commitf2851f57502b15dee9c94daf3876b53a6be01849 (patch)
tree70dc9e07b48d8f9e236081493a3f823d5a437d49
parent6160f09410a330a03fe6a95b3252b6f5c4322931 (diff)
downloadbuild-coordinator-f2851f57502b15dee9c94daf3876b53a6be01849.tar
build-coordinator-f2851f57502b15dee9c94daf3876b53a6be01849.tar.gz
Only consider unprocessed builds for prioritisation
As there's no need to consider unprocessed builds in this part of the query.
-rw-r--r--guix-build-coordinator/datastore/sqlite.scm3
1 files changed, 2 insertions, 1 deletions
diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm
index dd7b592..69a8931 100644
--- a/guix-build-coordinator/datastore/sqlite.scm
+++ b/guix-build-coordinator/datastore/sqlite.scm
@@ -1246,7 +1246,8 @@ UNION
INNER JOIN derivation_outputs AS all_derivation_outputs
ON all_derivation_outputs.output = derivation_outputs.output
INNER JOIN builds
- ON builds.derivation_name = all_derivation_outputs.derivation_name
+ ON builds.processed = 0
+ AND builds.derivation_name = all_derivation_outputs.derivation_name
)
SELECT builds_with_derived_priority.uuid, MAX(derived_priority)
FROM builds_with_derived_priority