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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sbadyals(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 in pg_toast_2619
Date: 2017-07-03 15:49:08
Message-ID: 28829.1499096948@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

sbadyals(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2017-07-03 16:23:37 Re: BUG #14729: Between operator is slow when same value used for low and high margin
Previous Message K S, Sandhya (Nokia - IN/Bangalore) 2017-07-03 15:01:31 Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core