[Git][qa/jenkins.debian.net][master] rdn stats: also group by source name for failed builds

[Holger Levsen (@holger)]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
b62db570 by Jochen Sprickerhof at 2025-09-07T14:26:37+02:00
rdn stats: also group by source name for failed builds

(cherry picked from commit 8cf4f9d9c822b945074ebab340e8dcf33c133982)
Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


1 changed file:

- bin/rebuilderd_stats.py


Changes:

=====================================
bin/rebuilderd_stats.py
=====================================
@@ -161,7 +161,7 @@ def main() -> None:
             " JOIN build_inputs i ON r.build_input_id = i.id"
             " JOIN source_packages s ON i.source_package_id = s.id"
             f" WHERE (a.status = 'BAD' OR r.status = 'FAIL') AND s.seen_in_last_sync = True AND s.release = '{args.release}'"
-            " GROUP BY a.name HAVING r.id = MAX(r.id) ORDER BY r.built_at"
+            " GROUP BY a.name, s.name HAVING r.id = MAX(r.id) ORDER BY r.built_at"
         )
         api = "../api/v1"
     else:



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/b62db570f4c15f819703ba14d3bb29251938ba54

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/b62db570f4c15f819703ba14d3bb29251938ba54
You're receiving this email because of your account on salsa.debian.org.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20250907/0a2a495a/attachment-0001.htm>