Re: can you have any idea about toast missing chunk issu resolution

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: can you have any idea about toast missing chunk issu resolution
Date: 2015-01-15 14:46:08
Message-ID: 3657.1421333168@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> writes:
> ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619

What PG version is that exactly?

If you're not running the latest minor release in your branch, updating
would be advisable; there have been fixes in the past for bugs with
symptoms like this.

If you still see the issue after updating, an ANALYZE on the problem
table would probably help.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-01-15 15:05:01 Re: can you have any idea about toast missing chunk issu resolution
Previous Message Andy Colson 2015-01-15 14:45:12 Re: Indexing large table of coordinates with GiST