Xmax precedes relation freeze threshold errors

From: Sergey Aleynikov <sergey(dot)aleynikov(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Xmax precedes relation freeze threshold errors
Date: 2022-06-14 12:27:20
Message-ID: CAKNj8S31JjOmRjP77QNCY9Zr8_098V_UJJHn9zMoyMQShHfoMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We're on Postgresql version 14.1. After running pg_amcheck on one of
our databases, we see lots of the same errors for a lot of tables.
Here's an example run for a single table:

/usr/lib/postgresql/14/bin/pg_amcheck -h /var/run/pgsql15/ -d poker -t
public.user_tournament --heapallindexed
heap table “poker.public.user_tournament”, block 30356, offset 125:
xmax 634989520 precedes relation freeze threshold 12:634871433
heap table “poker.public.user_tournament”, block 30356, offset 145:
xmin 634989520 precedes relation freeze threshold 12:634871433
heap table “poker.public.user_tournament”, block 30601, offset 106:
xmax 634989520 precedes relation freeze threshold 12:634871433
heap table “poker.public.user_tournament”, block 30601, offset 111:
xmin 634989520 precedes relation freeze threshold 12:634871433
heap table “poker.public.user_tournament”, block 30645, offset 2:
xmax 634989520 precedes relation freeze threshold 12:634871433
heap table “poker.public.user_tournament”, block 30645, offset 3:
xmin 634989520 precedes relation freeze threshold 12:634871433
heap table “poker.public.user_tournament”, block 31416, offset 8:
xmax 634989520 precedes relation freeze threshold 12:634871433
heap table “poker.public.user_tournament”, block 31416, offset 9:
xmin 634989520 precedes relation freeze threshold 12:634871433

VACUUM FREEZE on this table completes successfully, but pg_amcheck
errors still remain. What are the implications behind this error? Does
this mean some kind of a silent data corruption? Or are they harmless?
Are there any ways to fix them/prevent them appearing in the future?

Best regards,
Sergey Aleynikov

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Roberto Mireles 2022-06-14 13:53:57 Warm standby server slow to apply WAL (log-shipping)
Previous Message Nikhil Shetty 2022-06-14 11:58:17 Re: Recovery conflict due to buffer pins