pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andres Freund <andres@anarazel.de>
To: Bowen Shi <zxwsbg12138@gmail.com>
Cc: Melanie Plageman <melanieplageman@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>
Cc: Noah Misch <noah@leadboat.com>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: Alexander Lakhin <exclusion@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
Date: Wed, 15 May 2024 20:33:08 -0700
Message-ID: <20240516033308.tu3urchutxy754bp@awork3.anarazel.de> (raw)
In-Reply-To: <CAM_vCue-t1SsNYj=rz6CN1Seu+i7buCGFEvams4JTk5RjKf+kw@mail.gmail.com>
References: <CA+TgmoZk19atnje-pCoj2CVuPS5FnGZdVsbqJ0vNZOvcXhYmqA@mail.gmail.com>
	<CA+Tgmob1BtWcP6R5-toVHB5wqHasPTSR2TJkcDCutMzaUYBaHQ@mail.gmail.com>
	<CAAKRu_aq0oZS88NxN9gEW9Ff-HK6AegTZ0FdC8C4fOZdXbwx+A@mail.gmail.com>
	<CAM_vCuc3iWc_WdMmAWmixa2i_vNy43rWnSc+7732VRcJUBm+zA@mail.gmail.com>
	<CAAKRu_bzcKmb1G4wY2AezsDbZ5QZubmrjrKgkPdbu_L6k6uUdQ@mail.gmail.com>
	<CAM_vCuc=S=djaSyVUQDDJ7fmxQqVr4dB-iv2mdNMSWA=GRb6Dg@mail.gmail.com>
	<CAAKRu_bioPMfwpA2zgK=eNq402YsvTCrxfQ_o0PvCBejFsTu=A@mail.gmail.com>
	<CAM_vCufYfYxHdFD=1zNjcAzg-cehcUqpWkyQP-s8paPUvVEzqA@mail.gmail.com>
	<CAAKRu_YzDyVD4aRgKjpeQRx8b6FRjCNJh=N-0+0NZ5Qv55QFdQ@mail.gmail.com>
	<CAM_vCue-t1SsNYj=rz6CN1Seu+i7buCGFEvams4JTk5RjKf+kw@mail.gmail.com>

Hi,

On 2024-05-16 10:21:59 +0800, Bowen Shi wrote:
> Yes,  I found the vacuum process hanging in a retry loop on PG16. I think
> it was the problem discussed in this thread. Here is some information:

Very interesting.


Do you have the page contents that triggered the issue?


> vacrel: OldestXmin = 1106, relfrozenxid = 927
> vacrel->vistest: maybe_needed = 1079, definitely_need = 1106

Do you have any other variables? E.g. RecentXmin,
ComputeXidHorizonsResultLastXmin?

Greetings,

Andres Freund





view thread (62+ messages)  latest in thread

Message-ID: <20240516033308.tu3urchutxy754bp@awork3.anarazel.de>
Permalink:  ../20240516033308.tu3urchutxy754bp@awork3.anarazel.de/
Also on:    postgresql.org/message-id/20240516033308.tu3urchutxy754bp@awork3.anarazel.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: andres@anarazel.de, zxwsbg12138@gmail.com, melanieplageman@gmail.com, robertmhaas@gmail.com, boekewurm+postgres@gmail.com, noah@leadboat.com, pg@bowt.ie, exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
  In-Reply-To: <20240516033308.tu3urchutxy754bp@awork3.anarazel.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox