Re: Missing Toast Chunk - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Missing Toast Chunk
Date
Msg-id AANLkTinktrhiCgkzPRMTpSyLLoqsfqXFavOecjSG71xj@mail.gmail.com
Whole thread Raw
In response to Missing Toast Chunk  (Sam Nelson <samn@consistentstate.com>)
Responses Re: Missing Toast Chunk
List pgsql-general
On Thu, Aug 19, 2010 at 11:26 AM, Sam Nelson <samn@consistentstate.com> wrote:
> Good morning, list.
> We've got a bit of a problem on a customer's production box.  We got a
> "missing chunk number 0 for toast value N" (N being a number) this week on

SNIP

> So the question is, what could be causing this?  It's not so terrible a deal
> that we found that error in their database once, but this happened again
> right after we fixed it.  Could it be ruby?  The customer's application(s)?
>  Some weirdness with Amazon EC2 and/or debian?  A bug in postgres, itself?

It's almost certainly not ruby's fault.  Have they done anything
strange like kill the instance and restart it without letting the db
shut down?  I'd tend to suspect Amazon's fsyncing is amiss and they
did something that triggered it.

--
To understand recursion, one must first understand recursion.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Missing Toast Chunk
Next
From: Miguel Vaz
Date:
Subject: searchable book database