| From: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
|---|---|
| To: | Noah Misch <noah(at)leadboat(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Improving tracking/processing of buildfarm test failures |
| Date: | 2025-06-01 19:00:01 |
| Message-ID: | 4653028e-cc2e-4e10-8ca9-5c64365a9ffb@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
# 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-06-01 19:05:37 | Re: Confused coding in PLy_traceback() |
| Previous Message | Peter Geoghegan | 2025-06-01 18:22:38 | Re: RelationGetNumberOfBlocks called before vacuum_get_cutoffs |