Re: Getting TOAST errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting TOAST errors
Date: 2011-09-19 14:31:28
Message-ID: 16487.1316442688@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tim Uckun <timuckun(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry Drexler 2011-09-19 14:37:58 Re: General guidance if there is an in dadabase solution or should stay as excel vba solution.
Previous Message Tatsuo Ishii 2011-09-19 14:17:50 Re: postgis and pgpool