Re: Recent pg_rewind test failures in buildfarm

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Alexander Lakhin <exclusion(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Recent pg_rewind test failures in buildfarm
Date: 2025-04-22 06:22:51
Message-ID: aAc1u27XYBTl+2bs@ip-10-97-1-34.eu-west-3.compute.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Mon, Apr 21, 2025 at 10:17:40AM +0900, Michael Paquier wrote:
> On Tue, Apr 15, 2025 at 05:50:32AM +0000, Bertrand Drouvot wrote:
> > Sorry, can't look at the details right now but it might be linked to
> > 039549d70f6 which is recent enough and in this area. Will give it a look once
> > I've time.
>
> Playing catch-up with various things this week, and I have been
> looking at this one.
>
> So, we are triggering this assertion in the shutdown sequence of the
> WAL sender because there is nothing to flush based on what the
> callbacks are reporting, still pending_since could have been set by a
> previous call of pgstat_report_stat(), which could come from a
> PostgresMain() path for example, depending on the frequency of such
> calls. The important point is that we don't lose WAL sender stats at
> shutdown,

Right.

> and well, we don't lose any data for the WAL sender based on
> what this assertion tells us, just that there is some friction with
> the new I/O and backend flush calls.

I do agree.

> pg_stat_io has been added in v16, but isn't that something that could
> be reached even today down to v15? For example, imagine the case of a
> background worker that does periodic stats reports with interactions
> on existing stats. pgstats stored in shmem has been added in v15.
>
> Thoughts?

Yeah, unless that might come from fc415edf8ca but I don't think that's the case.

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2025-04-22 07:00:00 Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding
Previous Message Ashutosh Bapat 2025-04-22 06:20:11 Re: bug: virtual generated column can be partition key