[Git][qa/jenkins.debian.net][master] rdn stats: add next_retry

[Holger Levsen (@holger)]

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


Commits:
08fed15f by Jochen Sprickerhof at 2026-09-09T12:40:30+02:00
rdn stats: add next_retry

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

- - - - -


1 changed file:

- bin/rebuilderd_stats.py


Changes:

=====================================
bin/rebuilderd_stats.py
=====================================
@@ -156,7 +156,7 @@ def main() -> None:
 
     if cu.execute("SELECT COUNT(name) FROM sqlite_schema WHERE name = 'rebuild_artifacts'").fetchall()[0][0] == 1:
         sql = (
-            "SELECT a.name, s.name, s.version, r.id, l.build_log, d.diffoscope_log, a.id"
+            "SELECT a.name, s.name, s.version, r.id, l.build_log, d.diffoscope_log, a.id, i.next_retry"
             " FROM rebuild_artifacts a"
             " LEFT JOIN diffoscope_logs d ON a.diffoscope_log_id = d.id"
             " RIGHT JOIN rebuilds r ON a.rebuild_id = r.id"
@@ -170,13 +170,13 @@ def main() -> None:
         api = "../api/v1"
     else:
         sql = (
-            "SELECT p.name, s.name, s.version, p.build_id, b.build_log, b.diffoscope, NULL"
+            "SELECT p.name, s.name, s.version, p.build_id, b.build_log, b.diffoscope, NULL, NULL"
             " FROM packages p JOIN pkgbases s ON s.id = p.pkgbase_id LEFT JOIN builds b ON b.id = p.build_id"
             " WHERE p.status = 'BAD' ORDER BY p.build_id"
         )
         api = "api/v0"
 
-    for name, src_name, src_version, build_id, build_log, diffoscope, diffoscope_id in cu.execute(sql):
+    for name, src_name, src_version, build_id, build_log, diffoscope, diffoscope_id, next_retry in cu.execute(sql):
         total += 1
 
         if not name:
@@ -185,7 +185,7 @@ def main() -> None:
         if build_id in cache:
             cache_new[build_id] = cache[build_id]
             message, difflen = cache[build_id]
-            messages_packages[message].append({"name": name, "src": src_name, "version": src_version, "id": build_id, "diff": difflen, "diff_id": diffoscope_id})
+            messages_packages[message].append({"name": name, "src": src_name, "version": src_version, "id": build_id, "diff": difflen, "diff_id": diffoscope_id, "next_retry": next_retry})
             continue
 
         build_log = unzstd.stream_reader(build_log).read().decode("utf8", "replace")
@@ -198,7 +198,7 @@ def main() -> None:
             if error_match_fn(build_log, diffoscope):
                 difflen = len(diffoscope.splitlines())
                 cache_new[build_id] = (message, difflen)
-                messages_packages[message].append({"name": name, "src": src_name, "version": src_version, "id": build_id, "diff": difflen, "diff_id": diffoscope_id})
+                messages_packages[message].append({"name": name, "src": src_name, "version": src_version, "id": build_id, "diff": difflen, "diff_id": diffoscope_id, "next_retry": next_retry})
                 break
 
     messages_packages = {k: v for k, v in messages_packages.items() if v}  # Remove empty categories
@@ -297,6 +297,8 @@ def output(outfile, arch, db_size, total, messages_packages, size_sort, api, rel
                     print(f'<a href="../{api}/builds/{pkg["id"]}/diffoscope">💠</a>', end='', file=outfile)
             print(f'<a href="https://tracker.debian.org/pkg/{pkg["src"]}">🍥</a>', end='', file=outfile)
             print(f'<a href="https://tests.reproducible-builds.org/debian/rb-pkg/{ci_release}/{ci_arch}/{pkg["src"]}.html">🔬</a>', end='', file=outfile)
+            if next_retry := pkg["next_retry"]:
+                print(f'<span title="Next retry: {next_retry}">⏱</span>', end='', file=outfile)
             if rn_bug := rn_bugs.get(pkg["src"]):
                 if comments := rn_bug.get("comments"):
                     comments = escape(comments).replace("\n", "
")



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

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/08fed15fd2d187d8319bbe63c2e1042f68c4377b
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/20260909/e97c59a3/attachment-0001.htm>