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.