Re: xid_wraparound tests intermittent failure.

On 2024-07-22 Mo 10:11 PM, Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>> On 2024-07-22 Mo 12:46 PM, Tom Lane wrote:
>>> Masahiko Sawada<sawada(dot)mshk(at)gmail(dot)com> writes:
>>>> Looking at dodo's failures, it seems that while it passes
>>>> module-xid_wraparound-check, all failures happened only during
>>>> testmodules-install-check-C. Can we check the server logs written
>>>> during xid_wraparound test in testmodules-install-check-C?
>>> Oooh, that is indeed an interesting observation. There are enough
>>> examples now that it's hard to dismiss it as chance, but why would
>>> the two runs be different?
>> It's not deterministic.
> Perhaps. I tried "make check" on mamba's host and got exactly the
> same failures as with "make installcheck", which counts in favor of
> dodo's results being just luck. Still, dodo has now shown 11 failures
> in "make installcheck" and zero in "make check", so it's getting hard
> to credit that there's no difference.
>
>

Yeah, I agree that's perplexing. That step doesn't run with "make -j
nn", so it's a bit hard to see why it should get different results from
one run rather than the other.  The only thing that's different is that
there's another postgres instance running. Maybe that's just enough to
slow the test down? After all, this is an RPi.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com