Home > mailing lists

Re: BUG #17444: ERROR: found xmin 215633 from before relfrozenxid 1280585 - Mailing list pgsql-bugs

From	Andrey Borodin
Subject	Re: BUG #17444: ERROR: found xmin 215633 from before relfrozenxid 1280585
Date	March 24, 2022 12:05:24
Msg-id	E64456F5-A481-4E34-97BC-41FF757F2BA8@yandex-team.ru Whole thread Raw
In response to	BUG #17444: ERROR: found xmin 215633 from before relfrozenxid 1280585 (PG Bug reporting form <noreply@postgresql.org>)
List	pgsql-bugs

Tree view

Hi!

> 21 марта 2022 г., в 18:08, PG Bug reporting form <noreply@postgresql.org> написал(а):
>
>
> If i try vacum
> STATEMENT:  VACUUM (VERBOSE) public.projects_tables_values;
> ERROR:  found xmin 215633 from before relfrozenxid 1280585
> CONTEXT:  while scanning block 63286 offset 11 of relation
> "public.projects_tables_values"

This seems like a data corruption.
Do you have data_checksums enabled? Did you have and HW failures you your block storage device?

I'd recommend making a physical backup of a database and trying your luck with pg_surgery\pg_dirty_hands.

Best regards, Andrey Borodin.

pgsql-bugs by date:

From: Masahiko Sawada
Date: 23 March 2022, 11:48:43
Subject: Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end

From: Tomas Vondra
Date: 24 March 2022, 14:55:41
Subject: Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join

Re: BUG #17444: ERROR: found xmin 215633 from before relfrozenxid 1280585 - Mailing list pgsql-bugs

Previous

Next