Re: [BUGS] BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 in pg_toast_2619

sbadyals@gmail.com writes:
>  am facing this issue when trying to FULL VACUUM my database.

> vacuum FULL VERBOSE ANALYZE ;
> INFO: vacuuming "pg_catalog.pg_statistic"
> ERROR: missing chunk number 0 for toast value 9342315 in pg_toast_2619

> Tried reindexing, vacuuming the following tables:
> pg_toast.pg_toast_2619
> pg_statistic

Fortunately, pg_statistic is all reconstructable data.  Just TRUNCATE it
and then do ANALYZE to rebuild it.

If you have a reproducible way to get into this state, we'd be quite
interested, of course.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs