X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fclean_suites.py;h=4fe2c5fdf12cf9822061f06b8e38a79cff75155a;hb=52eb03dccab0a9898bca4d36a0a96ebe377fb977;hp=58b85d102c9392ae241b637a9d817053a895d18a;hpb=c7633c24aa41ab4e1758dda74d83ebf3f2d629d6;p=dak.git

diff --git a/dak/clean_suites.py b/dak/clean_suites.py
index 58b85d10..4fe2c5fd 100755
--- a/dak/clean_suites.py
+++ b/dak/clean_suites.py
@@ -364,7 +364,8 @@ def clean_fingerprints(now_date, session):
 SELECT f.id, f.fingerprint FROM fingerprint f
   WHERE f.keyring IS NULL
     AND NOT EXISTS (SELECT 1 FROM binaries b WHERE b.sig_fpr = f.id)
-    AND NOT EXISTS (SELECT 1 FROM source s WHERE s.sig_fpr = f.id)""")
+    AND NOT EXISTS (SELECT 1 FROM source s WHERE s.sig_fpr = f.id)
+    AND NOT EXISTS (SELECT 1 FROM acl_per_source aps WHERE aps.created_by_id = f.id)""")
 
     count = 0