Re: A bug in recovery prefetcher, triggering asserts / FATAL: checkpoint request failed

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Tomas Vondra <tomas(at)vondra(dot)me>
Cc: surya poondla <suryapoondla4(at)gmail(dot)com>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, shihao zhong <zhong950419(at)gmail(dot)com>
Subject: Re: A bug in recovery prefetcher, triggering asserts / FATAL: checkpoint request failed
Date: 2026-11-19 23:07:55
Message-ID: CAHGQGwHQkzvPCd9_RdsBM_Y7iNkzDQAMm8CBgzkVAxcSp60Xow@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Nov 20, 2026 at 3:29 AM Tomas Vondra <tomas(at)vondra(dot)me> wrote:
> I ended up committing it too.

Thanks for working on this!

The new test fails on some buildfarm members, such as indri on v17 [1].
It sets maintenance_io_concurrency = 1, but v17 and earlier reject
nonzero values on platforms without posix_fadvise(), causing the standby
to fail to start.

In v18, this restriction was removed for AIO support, so the setting is
accepted, although recovery prefetching remains disabled on these platforms.

Should we skip the test when recovery prefetching is unavailable?

Regards,

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=indri&dt=2026-11-19%2021%3A49%3A19

--
Fujii Masao

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2026-11-19 23:11:21 Re: pg_restore fails on extracted tar archives with large objects
Previous Message Peter Geoghegan 2026-11-19 23:01:53 Re: index prefetching