[Git][qa/jenkins.debian.net][master] rdn stats: fix for multiple architectures in DB

[Holger Levsen (@holger)]

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


Commits:
d9878dca by Jochen Sprickerhof at 2026-09-18T17:06:14+02:00
rdn stats: fix for multiple architectures in DB

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

- - - - -


1 changed file:

- bin/rebuilderd_stats.py


Changes:

=====================================
bin/rebuilderd_stats.py
=====================================
@@ -167,8 +167,8 @@ def main() -> None:
             " JOIN build_logs l ON r.build_log_id = l.id"
             " 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}'"
-            " AND r.id IN (SELECT r.id FROM rebuilds r JOIN build_inputs i ON r.build_input_id = i.id GROUP BY i.source_package_id HAVING r.id = MAX(r.id))"
+            f" WHERE (a.status = 'BAD' OR r.status = 'FAIL') AND s.seen_in_last_sync = True AND s.release = '{args.release}' and i.architecture = '{args.arch}'"
+            f" AND r.id IN (SELECT r.id FROM rebuilds r JOIN build_inputs i ON r.build_input_id = i.id where i.architecture = '{args.arch}' GROUP BY i.source_package_id HAVING r.id = MAX(r.id))"
             " ORDER BY r.built_at"
         )
         api = "../api/v1"



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

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/d9878dca66b7c1a60856eac1ad4f7dbfe83288aa
You're receiving this email because of your account on salsa.debian.org. Manage all notifications: https://salsa.debian.org/-/profile/notifications | Help: https://salsa.debian.org/help


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20260918/500e0e09/attachment.htm>