Re: Improving tracking/processing of buildfarm test failures

Hello hackers,

Please take a look at the November report on buildfarm failures:
# SELECT br, count(*) FROM failures WHERE dt >= '2024-11-01' AND
 dt < '2024-12-01' GROUP BY br;
REL_12_STABLE: 8
REL_13_STABLE: 8
REL_14_STABLE: 13
REL_15_STABLE: 10
REL_16_STABLE: 37
REL_17_STABLE: 29
master: 42
-- Total: 147
(Counting test failures only, excluding indent-check, Configure, Build
errors.)

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

# SELECT issue_link, count(*) FROM failures WHERE dt >= '2024-11-01' AND
 dt < '2024-12-01' GROUP BY issue_link ORDER BY 2 DESC LIMIT 6;
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=a34c33fd2 : 48
-- Fixed

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c4252c9ef : 15
-- Fixed

https://www.postgresql.org/message-id/E1tAZbM-001LGu-L8@gemulon.postgresql.org : 9
-- Fixed

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=73c9f91a1 : 9
-- Fixed

https://www.postgresql.org/message-id/88785ee8-d50b-ace1-a9f2-34810ee900b5@gmail.com : 7
-- Fixed

https://www.postgresql.org/message-id/a9a97e83-9ec8-5de5-bf69-80e9560f5345@gmail.com : 7

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

Short-lived failures:
107

Best regards,
Alexander