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 >= '2024-12-01' AND
  dt < '2025-01-01' GROUP BY br;
REL_13_STABLE: 6
REL_14_STABLE: 5
REL_15_STABLE: 4
REL_16_STABLE: 6
REL_17_STABLE: 13
master: 67
-- Total: 101
(Counting test failures only, excluding indent-check, Configure, Build
errors.)

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

# SELECT issue_link, count(*) FROM failures WHERE dt >= '2024-12-01' AND
  dt < '2025-01-01' GROUP BY issue_link ORDER BY 2 DESC LIMIT 6;
https://www.postgresql.org/message-id/CAEP4nAyC%2Bfz7K52MV4y08otEYtppJgfDBwdTW4aP7icRcBQnNw%40mail.gmail.com : 19
-- Fixed

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=71cb35290 : 13
-- Fixed

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=4171c44c9 : 11
-- Fixed

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=9fa1aaa65 : 7
-- Fixed

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=89988ac58 : 5
-- Fixed

https://www.postgresql.org/message-id/CAEP4nAyrnviyeRPb2OLB1o_F8pMw%3DE4OVhkjYeSA0Rdek%2BAYHg%40mail.gmail.com : 5
-- Fixed

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

Short-lived failures:
39

Best regards,
Alexander