From df9ca294a7fa249bade83928f811973c02d810c5 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 31 May 2018 11:18:00 +0200 Subject: lib/mysql-functions: deletion-list packages may have a checksum --- lib/mysql-functions | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/lib/mysql-functions b/lib/mysql-functions index 0aad61a..7a6ba03 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -742,7 +742,12 @@ mysql_sanity_check() { printf '`architectures`.`name`' printf ' FROM `binary_packages`' mysql_join_binary_packages_architectures - printf ' WHERE `binary_packages`.`sha512sum` IS NOT NULL' + printf ' WHERE NOT EXISTS (' + printf 'SELECT 1 FROM `binary_packages_in_repositories`' + mysql_join_binary_packages_in_repositories_repositories + printf ' WHERE NOT `repositories`.`is_on_master_mirror`' + printf ' AND `binary_packages_in_repositories`.`package`=`binary_packages`.`id`' + printf ')' } | \ mysql_run_query | \ sed ' -- cgit v1.2.3-70-g09d2