Re: Improving tracking/processing of buildfarm test failures

Hello hackers,

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

REL_14_STABLE: 15
REL_15_STABLE: 8
REL_16_STABLE: 6
REL_17_STABLE: 10
REL_18_STABLE: 14
master: 103
-- Total: 156

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

# SELECT issue_link, COUNT(*) FROM failures WHERE dt >= '2026-01-01' AND
 dt < '2026-02-01' GROUP BY issue_link ORDER BY 2 DESC LIMIT 7;
https://www.postgresql.org/message-id/bceabf7c-c4a1-4f76-ab0e-b64186913bfe%40app.fastmail.com : 25
-- Fixed

https://www.postgresql.org/message-id/TY7PR01MB1455452AE9053DD2B77B74FEAF58CA%40TY7PR01MB14554.jpnprd01.prod.outlook.com
: 15
-- Fixed

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

https://www.postgresql.org/message-id/274e0a1a-d7d2-4bc8-8b56-dd09f285715e%40gmail.com : 8
-- Fixed

https://www.postgresql.org/message-id/9ffdb19a-7a89-424e-925a-dd981c37f0ba%40gmail.com : 5

https://www.postgresql.org/message-id/aPAl27_urHSODwRN%40paquier.xyz : 5

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

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

Short-lived failures: 76

Best regards,
Alexander