Postgres Pro
Downloads
Home   >   mailing lists

Error: missing chunk number for toast value - Mailing list pgsql-admin

From Kevin Kempter
Subject Error: missing chunk number for toast value
Date
Msg-id 201008171438.39111.cs_dba@consistentstate.com
Whole thread Raw
Responses Re: Error: missing chunk number for toast value  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
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?

pgsql-admin by date:

Previous
From: Edoardo Innocenti
Date:
Subject: Re: TopMemoryContext - Configuration Mistake?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Error: missing chunk number for toast value