Re: pg15b4: FailedAssertion("TransactionIdIsValid(xmax)

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Zhang Mingli <zmlpostgres(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, Peter Geoghegan <pg(at)bowt(dot)ie>
Subject: Re: pg15b4: FailedAssertion("TransactionIdIsValid(xmax)
Date: 2022-09-12 21:29:22
Message-ID: 20220912212922.GJ31833@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Sep 12, 2022 at 11:53:14AM +0900, Michael Paquier wrote:
> On Mon, Sep 12, 2022 at 02:34:48PM +1200, Thomas Munro wrote:
> > On Mon, Sep 12, 2022 at 2:27 PM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> >> Yeah ... I just realized that I've already forgotten the relevant
> >> chronology.
> >>
> >> The io_concurrency bugfix wasn't included in 15b4, so (if I understood
> >> you correctly), that might explain these symptoms - right ?
> >
> > Yeah.
>
> Could you double-check if the issues you are seeing persist after
> syncing up with the latest point of REL_15_STABLE? For now, I have
> added an open item just to be on the safe side.

After another round of restore-from-backup, and sqlsmith-with-kill-9, it
looks to be okay. The issue was evidently another possible symptom of
the recovery prefetch bug, which is already fixed in REL_15_STABLE (but
not in pg15b4).

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan S. Katz 2022-09-12 21:31:36 Re: First draft of the PG 15 release notes
Previous Message Justin Pryzby 2022-09-12 21:09:07 Re: PostgreSQL 15 release announcement draft