Error: missing chunk number for toast value

From: Kevin Kempter <cs_dba(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Error: missing chunk number for toast value
Date: 2010-08-17 20:38:39
Message-ID: 201008171438.39111.cs_dba@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All;

We're seeing this error in our 8.3.9 database:

# select * from comments;
ERROR: missing chunk number 0 for toast value 1274882 in pg_toast_49234

I tried this:

# reindex table pg_toast.pg_toast_49234;
REINDEX

but the error still persists.

Thoughts?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-08-17 20:54:06 Re: Error: missing chunk number for toast value
Previous Message Edoardo Innocenti 2010-08-17 15:10:22 Re: TopMemoryContext - Configuration Mistake?