New instability in stats regression test

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: New instability in stats regression test
Date: 2023-11-25 18:08:54
Message-ID: 3500949.1700935734@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In the past few days we've had two buildfarm failures[1][2] in the
stats regression test that look like

@@ -1582,7 +1582,7 @@
SELECT :io_stats_post_reset < :io_stats_pre_reset;
?column?
----------
- t
+ f
(1 row)

-- test BRIN index doesn't block HOT update

I'm a bit mystified by this. This test was introduced in Andres'
commit 10a082bf7 of 2023-02-11, and it seems to have been stable
since then. I trawled the buildfarm logs going back three months
and found no similar failures. So why's it failing now? The
most plausible theory seems to be that Michael's recent commits
adding pg_stat_reset_xxx features destabilized the test somehow ...
but I sure don't see how/why.

Failure [1] was on my own animal longfin, so I tried to reproduce
it on that animal's host, but no luck so far.

Thoughts?

regards, tom lane

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=longfin&dt=2023-11-21%2001%3A55%3A00
[2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=guaibasaurus&dt=2023-11-25%2016%3A20%3A04

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Davin Shearer 2023-11-25 19:21:37 Emitting JSON to file using COPY TO
Previous Message Alexander Korotkov 2023-11-25 17:47:57 Re: Table AM Interface Enhancements