Re: Improving tracking/processing of buildfarm test failures - Mailing list pgsql-hackers

Hello hackers,

Please take a look at the May report on buildfarm failures:
# SELECT br, count(*) FROM failures WHERE dt >= '2025-05-01' AND
  dt < '2025-06-01' GROUP BY br;
REL_13_STABLE: 9
REL_14_STABLE: 11
REL_15_STABLE: 8
REL_16_STABLE: 13
REL_17_STABLE: 17
master: 25
-- Total: 83
(Counting test failures only, excluding indent-check, Configure, Build
errors.)

# SELECT COUNT(*) FROM (SELECT DISTINCT issue_link FROM failures WHERE
  dt >= '2025-05-01' AND dt < '2025-06-01');
14

# SELECT issue_link, count(*) FROM failures WHERE dt >= '2025-05-01' AND
  dt < '2025-06-01' GROUP BY issue_link ORDER BY 2 DESC LIMIT 3;
https://www.postgresql.org/message-id/614740.1747715486%40sss.pgh.pa.us : 16
-- Fixed

https://www.postgresql.org/message-id/sooxi5a47fr6kg7nk2we3t6jtnoyimmjlad6mu6fy4egnayyhm%40luirh3vxbehp : 9

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

# SELECT count(*) FROM failures WHERE dt >= '2025-05-01' AND
  dt < '2025-06-01' AND issue_link IS NULL; -- Unsorted/unhelpful failures
42

Short-lived failures: 17

Best regards,
Alexander Lakhin
Neon (https://neon.tech)