Thread: [BUGS] BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 inpg_toast_2619

The following bug has been logged on the website:

Bug reference:      14731
Logged by:          Sahil Badyal
Email address:      sbadyals@gmail.com
PostgreSQL version: 9.3.15
Operating system:   CenOS 6.7
Description:
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

My postgres version is :

PostgreSQL 9.3.15 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-17), 64-bit
(1 row)

Please help as soon as possible


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

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