BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 in pg_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