1 files changed, 6 insertions, 4 deletions
diff --git a/bin/return-assignment b/bin/return-assignment
index 9e64ff0..bcdb717 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -99,7 +99,6 @@ if [ "$5" = 'ERROR' ]; then
         'log_file' 'VARCHAR(512)' | \
         sed 's/,$//'
       printf ');\n'
-      printf 'INSERT INTO `failures` (`date`,`reason`,`log_file`) VALUES'
       fail_reason_identifiers=$(
         {
           printf 'SELECT `fail_reasons`.`id`,replace(to_base64(`fail_reasons`.`identifier`),"\\n","")'
@@ -131,8 +130,10 @@ if [ "$5" = 'ERROR' ]; then
             fi
           done
       done | \
-        sed 's/,$//'
-      printf ';\n'
+        sed '
+          1 s/^/INSERT INTO `failures` (`date`,`reason`,`log_file`) VALUES /
+          s/,$/;\n/
+        '
       printf 'INSERT INTO `failed_builds` (`build_slave`,`build_assignment`,`date`,`reason`,`log_file`)'
       printf ' SELECT '
       printf '`build_slaves`.`%s`,' \
@@ -536,7 +537,8 @@ trigger_mirror_refreshs
         base64 -w0
     )"
   printf ' `binary_packages`.`has_issues`=0,'
-  printf ' `binary_packages`.`is_tested`=0'
+  printf ' `binary_packages`.`is_tested`=0,'
+  printf ' `binary_packages`.`last_moved`=NOW()'
   printf ' WHERE `build_slaves`.`name`=from_base64("%s")' \
     "$(
       printf '%s' "${slave}" | \