Re: Getting TOAST errors - Mailing list pgsql-general

From Tom Lane
Subject Re: Getting TOAST errors
Date
Msg-id 16487.1316442688@sss.pgh.pa.us
Whole thread Raw
In response to Getting TOAST errors  (Tim Uckun <timuckun@gmail.com>)
Responses Re: Getting TOAST errors
List pgsql-general
Tim Uckun <timuckun@gmail.com> writes:
> I am occasionally getting this kind of error when attempting a SELECT statement.
>  PGError: ERROR:  missing chunk number 0 for toast value 27143 in pg_toast_2619
> What does this mean? Is some sort of corruption creeping into the database?

Hard to tell.  We've seen enough reports like that to make it seem like
there may be some bug buried there, but no one has provided anything to
do any debugging work with.  Can you create a reproducible test case?

> Postgres 9.0 linux.

9.0.what?

            regards, tom lane

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: postgis and pgpool
Next
From: Henry Drexler
Date:
Subject: Re: General guidance if there is an in dadabase solution or should stay as excel vba solution.