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.
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 |