Re: can you have any idea about toast missing chunk issu resolution - Mailing list pgsql-general

From Adrian Klaver
Subject Re: can you have any idea about toast missing chunk issu resolution
Date
Msg-id 54B7D71D.2010108@aklaver.com
Whole thread Raw
In response to can you have any idea about toast missing chunk issu resolution  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
List pgsql-general
On 01/15/2015 04:30 AM, M Tarkeshwar Rao wrote:
> Hi all,
>
> We are getting following error message on doing any action on the table
> like(Select or open from pgadmin).
>
> Please suggest.
>
> ERROR:  missing chunk number 0 for toast value 54787 in pg_toast_2619
>
> ********** Error **********
>
> ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
>
> SQL state: XX000
>


We've been down this path before:

http://www.postgresql.org/message-id/1C16813DAFF3E44B939586605D40E9F011737C1B@ESESSMB107.ericsson.se

and it was never resolved for lack of information. So:

1) Per Tom, what version of Postgres?

2) What OS and version?

3) General hardware specifications.

>
> Regards
>
> Tarkeshwar
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: can you have any idea about toast missing chunk issu resolution
Next
From: "George Weaver"
Date:
Subject: "Ungroup" data for import into PostgreSQL