Re: Improving tracking/processing of buildfarm test failures

Hello hackers,

Please take a look at the April report on buildfarm failures:

# SELECT br, count(*) FROM failures WHERE dt >= '2025-04-01' AND
  dt < '2025-05-01' GROUP BY br;
REL_13_STABLE: 1
REL_14_STABLE: 2
REL_15_STABLE: 5
REL_16_STABLE: 7
REL_17_STABLE: 8
master: 261
-- Total: 284
(Counting test failures only, excluding indent-check, Configure, Build
errors.)

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

  # SELECT issue_link, count(*) FROM failures WHERE dt >= '2025-04-01' AND
  dt < '2025-05-01' GROUP BY issue_link ORDER BY 2 DESC LIMIT 5;
https://www.postgresql.org/message-id/065c860a-1d29-4d2d-9b2b-90020b9395aa%40dunslane.net : 43
-- Fixed

https://www.postgresql.org/message-id/srnuqlttuimzmvoulhsrbgvj4vnul6b65osswvua7sfkqsvmuy%40yg7apybpxp34 : 41
-- Fixed

https://www.postgresql.org/message-id/20250420215339.e8.nmisch%40google.com : 32
-- Fixed

https://www.postgresql.org/message-id/D292EB44-806E-439A-82A4-491A1BA59E7A%40yesql.se : 30
-- Fixed

https://www.postgresql.org/message-id/3pd4322mogfmdd5nln3zphdwhtmq3rzdldqjwb2sfqzcgs22lf%40ok2gletdaoe6 : 30
-- Fixed

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

Short-lived failures: 238

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