Re: Missing Toast Chunk

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Missing Toast Chunk
Дата
Msg-id AANLkTinktrhiCgkzPRMTpSyLLoqsfqXFavOecjSG71xj@mail.gmail.com
обсуждение исходный текст
Ответ на Missing Toast Chunk  (Sam Nelson <samn@consistentstate.com>)
Ответы Re: Missing Toast Chunk  (Sam Nelson <samn@consistentstate.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Missing Toast Chunk
Следующее
От: Miguel Vaz
Дата:
Сообщение: searchable book database