bin/mysql-functions: remove handed out build-assignments which are not on the build-list

1 files changed, 5 insertions, 1 deletions

diff --git a/bin/mysql-functions b/bin/mysql-functions
index 4b76d64..491b794 100755
--- a/bin/mysql-functions
+++ b/bin/mysql-functions
@@ -809,7 +809,11 @@ mysql_cleanup() {
       printf 'SELECT * FROM `build_assignments` '
       printf 'WHERE `build_assignments`.`package_source`=`package_sources`.`id`'
     printf ');\n'
- # TODO: remove handed out build-assignments which are not on the build-list
+    printf 'UPDATE `build_slaves`'
+    printf ' JOIN `binary_packages` ON `build_slaves`.`currently_building`=`binary_packages`.`build_assignment`'
+    printf ' JOIN `repositories` ON `repositories`.`id`=`binary_packages`.`repository`'
+    printf ' SET `currently_building`=NULL'
+    printf ' WHERE `repositories`.`name`!="build-list";\n'
   } | \
     ${mysql_command}
 }