Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 in pg_toast_2619 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 in pg_toast_2619
Date
Msg-id 28829.1499096948@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 inpg_toast_2619  (sbadyals@gmail.com)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "K S, Sandhya (Nokia - IN/Bangalore)"
Date:
Subject: [BUGS] Re: [HACKERS] Postgres process invoking exit resulting in sh-QUITcore
Next
From: Pavel Stehule
Date:
Subject: Re: [BUGS] BUG #14729: Between operator is slow when same value usedfor low and high margin