From cb5d76d1fca8d951b77002edfae7993b5c375015 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 19 Jan 2018 15:15:36 +0100
Subject: bin/return-assignment: mark broken packages in the database

---
 bin/return-assignment | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'bin')

diff --git a/bin/return-assignment b/bin/return-assignment
index fceff50..ebaa73a 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -76,6 +76,20 @@ if [ "$5" = 'ERROR' ]; then
   # shellcheck disable=SC2154
   echo "${slave}" >> \
     "${work_dir}/package-states/$1.$2.$3.$4.broken"
+  ${mysql_command} -e "$(
+    # shellcheck disable=SC2016
+    printf 'UPDATE `build_assignments`'
+    # shellcheck disable=SC2016
+    printf ' JOIN `build_slaves` ON `build_slaves`.`currently_building`=`build_assignments`.`id`'
+    # shellcheck disable=SC2016
+    printf ' SET `build_assignments`.`is_broken`=1, `build_slaves`.`currently_building`=NULL'
+    # shellcheck disable=SC2016
+    printf ' WHERE `build_slaves`.`name`=from_base64("%s");\n' \
+      "$(
+        printf '%s' "${slave}" | \
+          base64 -w0
+      )"
+  )"
 
   # shellcheck disable=SC2154
   sed -i '
-- 
cgit v1.2.3-70-g09d2