Re: Detecting corrupted pages earlier

Поиск
Список
Период
Сортировка
От Kevin Brown
Тема Re: Detecting corrupted pages earlier
Дата
Msg-id 20030218094049.GP1833@filer
обсуждение исходный текст
Ответ на Re: Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> The cases I've been able to study look like the header and a lot of the
> following page data have been overwritten with garbage --- when it made
> any sense at all, it looked like the contents of non-Postgres files (eg,
> plain text), which is why I mentioned the possibility of disks writing
> data to the wrong sector.

That also sounds suspiciously like the behavior of certain filesystems
(Reiserfs, for one) after a crash when the filesystem prior to the
crash was highly active with writes.  Had the sites that reported this
experienced OS crashes or power interruptions?


-- 
Kevin Brown                          kevin@sysexperts.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: Detecting corrupted pages earlier
Следующее
От: Christoph Haller
Дата:
Сообщение: Re: Group by, count, order by and limit