Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>

To: Bowen Shi <zxwsbg12138@gmail.com>

Cc: Melanie Plageman <melanieplageman@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Matthias van de Meent <boekewurm+postgres@gmail.com>, Noah Misch <noah@leadboat.com>, Peter Geoghegan <pg@bowt.ie>, Alexander Lakhin <exclusion@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Date: 2024-05-16T16:38:10Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Ensure vacuum removes all visibly dead tuples older than OldestXmin
- 06bf404cd07b 16.4 landed
- 45ce054c02b8 14.13 landed
- dc6354c67017 15.8 landed
Combine freezing and pruning steps in VACUUM
- 6dbb490261a6 17.0 cited
Handle non-chain tuples outside of heap_prune_chain()
- 6f47f6883151 17.0 cited
Fix false reports in pg_visibility
- e85662df44ff 17.0 cited
Remove retry loop in heap_page_prune().
- 1ccc1e05ae8f 17.0 cited
vacuumlazy.c: document vistest and OldestXmin.
- 73f6ec3d3c8d 15.0 cited
Deduplicate choice of horizon for a relation procarray.c.
- d9d8aa9bb9aa 15.0 cited
Remove tupgone special case from vacuumlazy.c.
- 8523492d4e34 14.0 cited
Simplify state managed by VACUUM.
- b4af70cb2103 14.0 cited
Recycle nbtree pages deleted during same VACUUM.
- 9dd963ae2534 14.0 cited
snapshot scalability: Don't compute global horizons while building snapshots.
- dc7420c2c927 14.0 cited
Raise error when affecting tuple moved into different partition.
- f16241bef7cc 11.0 cited

Hi,

On 2024-05-16 15:31:20 +0800, Bowen Shi wrote:
> Yes, I have preserved the coredump file of vacuum and several other related
> processes. It has been at least 10 minutes stuck in the retry loop since I
> dumped this core file.

Could you print out *vacrel?

I'm wondering if there was index processing, due to the number of tuples. And
if so, what type of indexes. There'd need to be something that could lead to
new snapshots being acquired...

Greetings,

Andres Freund