From a117834a6497ca868caa3943dd7275ad532e9d5a Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 12 Feb 2018 22:02:43 +0100 Subject: bin/mysql-functions: remove handed out build-assignments which are not on the build-list --- bin/mysql-functions | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) 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} } -- cgit v1.2.3-54-g00ecf