ERROR: found xmin 10843132 from before relfrozenxid15785806 during vacuum on JSONB TOAST TABLE

From: Raj kumar <rajkumar820999(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: ERROR: found xmin 10843132 from before relfrozenxid15785806 during vacuum on JSONB TOAST TABLE
Date: 2020-11-09 14:53:09
Message-ID: CACxU--UJJqzLHjTDRPwMcV9WgbJ=g153kG4aUXVm+PYd_e=R_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I ran load of 150GB JSON data on a table for 3 days and terminated the
loading today.

When I ran manual Vacuum on the database, I found the below error on the
toast table corresponding to the table on which I Loaded the data.

VACUUM(ANALYZE, VERBOSE)

WARNING: relation "pg_toast_898416" page 17933209 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933210 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933211 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933212 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933213 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933214 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933215 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933216 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933217 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933218 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933219 is uninitialized ---
fixing

WARNING: relation "pg_toast_898416" page 17933220 is uninitialized ---
fixing

ERROR: found xmin 10843132 from before relfrozenxid 15785806

document=#

document=#

Later, I thought the issue could be due to Transaction-Wraparound and did
VACUUM(FREEZE, ANALYZE, VERBOSE). but that also throws same error

WARNING: page is not marked all-visible but visibility map bit is set in
relation "pg_toast_898416" page 13506521

WARNING: page is not marked all-visible but visibility map bit is set in
relation "pg_toast_898416" page 13506522

WARNING: page is not marked all-visible but visibility map bit is set in
relation "pg_toast_898416" page 13506523

WARNING: page is not marked all-visible but visibility map bit is set in
relation "pg_toast_898416" page 13506524

WARNING: page is not marked all-visible but visibility map bit is set in
relation "pg_toast_898416" page 13506525

WARNING: page is not marked all-visible but visibility map bit is set in
relation "pg_toast_898416" page 13506526

WARNING: page is not marked all-visible but visibility map bit is set in
relation "pg_toast_898416" page 1350652

ERROR: found xmin 10843132 from before relfrozenxid 15785806

document=#

document=# select relname,reltype,relpages,reltuples from pg_class where
pg_class.relfrozenxid=15785806;
relname | reltype | relpages | reltuples
-----------------+---------+----------+-----------
pg_toast_898416 | 898421 | 4945 | 29346
(1 row)

document=#

How do I get rid of this error? so that Vacuum gets complete?

Thanks,

Raj Kumar Narendiran.

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2020-11-09 16:41:15 Re: Postgres question
Previous Message Holger Jakobs 2020-11-09 08:24:11 Re: pgadmin 4 dashboard