Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/bin/get-assignment
diff options
context:
space:
mode:
Diffstat (limited to 'bin/get-assignment')
-rwxr-xr-xbin/get-assignment11
1 files changed, 6 insertions, 5 deletions
diff --git a/bin/get-assignment b/bin/get-assignment
index 0ce35e9..b5dd33d 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -177,11 +177,7 @@ next_building=$(
printf ' AND `architecture_compatibilities`.`fully_compatible`'
printf ' JOIN `architectures`'
printf ' ON `architecture_compatibilities`.`runs_on`=`architectures`.`id`'
- printf ' WHERE NOT EXISTS ('
- printf ' SELECT 1'
- printf ' FROM `build_slaves`'
- printf ' WHERE `build_slaves`.`currently_building`=`build_assignments`.`id`'
- printf ') AND ('
+ printf ' WHERE ('
printf '`build_assignments`.`is_blocked` IS NULL'
if [ -n "${requested}" ]; then
printf ' OR'
@@ -198,6 +194,11 @@ next_building=$(
printf ' AND `architectures`.`name` = from_base64("%s");\n' \
"${arch}"
+ printf 'DELETE `considered_build_assignments`'
+ printf ' FROM `considered_build_assignments`'
+ mysql_join_build_assignments_build_slaves 'considered_build_assignments'
+ printf ';\n'
+
printf 'SELECT `considered_build_assignments`.`id` FROM'
printf ' `considered_build_assignments`'
printf ' JOIN `build_assignments`'