bin/build-master-status: explicitely insert date, so it is equal for all architectures

1 files changed, 10 insertions, 2 deletions

diff --git a/bin/build-master-status b/bin/build-master-status
index 455eb8f..c38d491 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -98,6 +98,10 @@ rm -f "${tmp_dir}/todos"
 
 # TODO: accellerate this query by using "GROUP BY"?
 if [ ! -s "${work_dir}/build-master-sanity" ]; then
+  now=$(
+    date '+%F %H:%M:%S' | \
+      base64 -w0
+  )
   # shellcheck disable=SC2016
   {
     printf 'SELECT `architectures`.`id`'
@@ -119,7 +123,8 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
         'locked_tasks_count' \
         'blocked_tasks_count' \
         'next_tasks_count' \
-        'architecture' | \
+        'architecture' \
+        'date' | \
         sed 's/,$//'
       printf ') VALUES ('
       # stable_packages_count
@@ -249,8 +254,11 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
       printf ' AND `build_assignments`.`architecture`=%s),' \
         "${arch_id}"
       # architecture
-      printf '%s' \
+      printf '%s,' \
         "${arch_id}"
+      # date
+      printf 'from_base64("%s")' \
+        "${now}"
       printf ');\n'
     done | \
     mysql_run_query 'unimportant'