| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>, "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 15:05:01 |
| Message-ID: | 54B7D71D.2010108@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Weaver | 2015-01-15 15:43:59 | "Ungroup" data for import into PostgreSQL |
| Previous Message | Tom Lane | 2015-01-15 14:46:08 | Re: can you have any idea about toast missing chunk issu resolution |