From 5ed904c0b9fae476e45621b2e21b61ea8391db2b Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 20 Mar 2018 13:23:21 +0100
Subject: bin/build-master-status-from-mysql: ignore duplicates of handed out
 assignments

---
 bin/build-master-status-from-mysql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/bin/build-master-status-from-mysql b/bin/build-master-status-from-mysql
index e4dd313..5f27d89 100755
--- a/bin/build-master-status-from-mysql
+++ b/bin/build-master-status-from-mysql
@@ -36,7 +36,7 @@ sort "${work_dir}/build-list" > \
 
 # shellcheck disable=SC2016
 {
-  printf 'SELECT '
+  printf 'SELECT DISTINCT '
   printf '`package_sources`.`%s`,' \
     'pkgbase' 'git_revision' 'mod_git_revision'
   printf '`upstream_repositories`.`name`'
@@ -248,7 +248,7 @@ find "${work_dir}/package-states" -mindepth 1 -maxdepth 1 \
 
 if [ -s "${webserver_directory}/mysql-sanity.html" ] && \
   [ ! -s "${work_dir}/build-master-sanity" ]; then
-  printf 'oh girls, my database is dirty again ...\n' | \
+  printf 'girls, my database is dirty again ...\n' | \
     irc_say
   echo 'build master is insane' > \
     "${work_dir}/build-master-sanity"
-- 
cgit v1.2.3-70-g09d2