Re: Improving tracking/processing of buildfarm test failures

Hello hackers,

Please take a look at the December report on buildfarm failures:
# SELECT br, COUNT(*) FROM failures WHERE dt >= '2025-12-01' AND
  dt < '2026-01-01' GROUP BY br;

REL_14_STABLE: 23
REL_15_STABLE: 13
REL_16_STABLE: 7
REL_17_STABLE: 11
REL_18_STABLE: 19
master: 186
-- Total: 259


# SELECT COUNT(*) FROM (SELECT DISTINCT issue_link FROM failures WHERE
  dt >= '2025-12-01' AND dt < '2026-01-01');
24


# SELECT issue_link, COUNT(*) FROM failures WHERE dt >= '2025-12-01' AND
  dt < '2026-01-01' GROUP BY issue_link ORDER BY 2 DESC LIMIT 6;

https://www.postgresql.org/message-id/2259481.1765831157%40sss.pgh.pa.us: 57
-- Fixed

https://www.postgresql.org/message-id/2899652.1765167313@sss.pgh.pa.us: 46
-- Fixed

https://www.postgresql.org/message-id/CAPpHfdtCGG5XcWqi%3DabNj_Fmv-CtunFLWgA-_6es-nuADm9LCQ%40mail.gmail.com: 31
-- Fixed

https://www.postgresql.org/message-id/2874644f-6431-41f4-abe2-99e5ab052606%40gmail.com: 29
-- Hurd

https://www.postgresql.org/message-id/baf1ae02-83bd-4f5d-872a-1d04f11a9073%40vondra.me: 22
-- Fixed


https://www.postgresql.org/message-id/4ccf62c4-48ed-47cb-badc-9ae436d91b39%40app.fastmail.com#6434c9ffe3c955bfbefb5a3748bc7d2f:

12


# SELECT COUNT(*) FROM failures WHERE dt >= '2025-12-01' AND
  dt < '2026-01-01' AND issue_link IS NULL; -- Unsorted/unhelpful failures
11


Short-lived failures:
174

Best regards,
Alexander