Re: Improving tracking/processing of buildfarm test failures

Hello hackers,

Please take a look at the June report on buildfarm failures:
# SELECT br, COUNT(*) FROM failures WHERE dt >= '2026-06-01' AND
  dt < '2026-07-01' GROUP BY br;
REL_14_STABLE: 17
REL_15_STABLE: 10
REL_16_STABLE: 18
REL_17_STABLE: 41
REL_18_STABLE: 41
master: 114
-- Total: 241
(Counting test failures only, excluding indent-check, Configure, Build
errors, also excluding failures from fruitcrow..)

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

# SELECT issue_link, COUNT(*) FROM failures WHERE dt >= '2026-06-01' AND
  dt < '2026-07-01' GROUP BY issue_link ORDER BY 2 DESC LIMIT 5;
https://www.postgresql.org/message-id/1151393.1781734980@sss.pgh.pa.us : 35
-- Fixed

https://www.postgresql.org/message-id/5ccbdbde-6467-4a10-bf4d-0be73a05ce8d@dunslane.net : 15
-- Fixed

https://www.postgresql.org/message-id/d92b18e8-00aa-4c32-95ff-7d807a427481%40vondra.me : 12

https://www.postgresql.org/message-id/E1wXskv-0026Ph-0q%40gemulon.postgresql.org : 9
-- Fixed

https://www.postgresql.org/message-id/CA+hUKGL0bikWSC2XW-zUgFWNVEpD_gEWXndi2PE5tWqmApkpZQ@mail.gmail.com : 8

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

Short-lived failures: 158

Best regards,
Alexander