pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Error:  missing chunk number for toast value
2+ messages / 2 participants
[nested] [flat]

* Error:  missing chunk number for toast value
@ 2010-08-17 20:38 Kevin Kempter <cs_dba@consistentstate.com>
  2010-08-17 20:54 ` Re: Error:  missing chunk number for toast value Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 1 reply; 2+ messages in thread

From: Kevin Kempter @ 2010-08-17 20:38 UTC (permalink / raw)
  To: 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?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Error:  missing chunk number for toast value
  2010-08-17 20:38 Error:  missing chunk number for toast value Kevin Kempter <cs_dba@consistentstate.com>
@ 2010-08-17 20:54 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 0 replies; 2+ messages in thread

From: Kevin Grittner @ 2010-08-17 20:54 UTC (permalink / raw)
  To: Kevin Kempter <cs_dba@consistentstate.com>; pgsql-admin

Kevin Kempter <cs_dba@consistentstate.com> wrote:
 
> # 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?
 
Your database is corrupted.  Any idea how that happened?  As with
any database corruption, I recommend you stop the server and make a
copy of the whole data directory and everything under it before any
recovery attempts.
 
You could zero in on the damage by selecting specific columns, and
ranges of rows.
 
A little more detail would be helpful.  For ideas, read this:
 
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
 
-Kevin



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2010-08-17 20:54 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-08-17 20:38 Error:  missing chunk number for toast value Kevin Kempter <cs_dba@consistentstate.com>
2010-08-17 20:54 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox