Search Postgresql Archives

Re: Missing Toast Chunk

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Aug 19, 2010 at 11:26 AM, Sam Nelson <samn@xxxxxxxxxxxxxxxxxxx> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux