Re: Is txid_status() actually safe? / What is 011_crash_recovery.pl testing?

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is txid_status() actually safe? / What is 011_crash_recovery.pl testing?
Date: 2021-05-05 14:37:52
Message-ID: CAMsr+YH0yFadUtPHE8OLJ8B=FVjqsaknhiPCtfxYPnrs2TE1SQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 10 Feb 2021 at 04:28, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Mon, Feb 8, 2021 at 4:52 PM Andres Freund <andres(at)anarazel(dot)de> wrote:
> > The 011_crash_recovery.pl test test starts a transaction, creates a
> > table, fetches the transaction's xid. Then shuts down the server in
> > immediate mode. It then asserts that after crash recovery the previously
> > assigned xid is shown as aborted, and that new xids are assigned after
> > the xid.
> >
> > But as far as I can tell there's no guarantee that that is the case.
>
> I think you are right.
>
>
Andres, I missed this mail initially. I'll look into it shortly.

--
Craig Ringer http://www.2ndQuadrant.com/
2ndQuadrant - PostgreSQL Solutions for the Enterprise

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2021-05-05 15:04:11 pg_receivewal makes a bad daemon
Previous Message Robert Haas 2021-05-05 14:27:46 Re: MaxOffsetNumber for Table AMs