Re: Recent 027_streaming_regress.pl hangs

Hello Andrew,

04.06.2024 13:00, Alexander Lakhin wrote:
> Also, 027_stream_regress still fails due to the same reason:
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=serinus&dt=2024-05-22%2021%3A55%3A03
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=flaviventris&dt=2024-05-22%2021%3A54%3A50
> (It's remarkable that these two animals failed at the same time.)
>

It looks like crake is failing now due to other reasons (not just
concurrency) — it produced 10+ failures of the
027_stream_regress test starting from July, 9.

The first such failure on REL_16_STABLE was [1], and that was the first run
with 'PG_TEST_EXTRA' => '... wal_consistency_checking'.

There is one known issue related to wal_consistency_checking [2], but I
see no "incorrect resource manager data checksum" in the failure log...

Moreover, the first such failure on REL_17_STABLE was [3], but that run
was performed without wal_consistency_checking, as far as I can see.

Can that failure be also related to the OS upgrade (I see that back in
June crake was running on Fedora 39, but now it's running on Fedora 40)?

So maybe we have two factors combined or there is another one?

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=crake&dt=2024-07-17%2014%3A56%3A09
[2] https://www.postgresql.org/message-id/055bb33c-bccc-bc1d-c2f8-8598534448ac@gmail.com
[3] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=crake&dt=2024-07-09%2021%3A37%3A04

Best regards,
Alexander