Re: BUG #5055: Invalid page header error

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: BUG #5055: Invalid page header error
Дата
Msg-id 4AB03622.5030708@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: BUG #5055: Invalid page header error  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-bugs
Craig Ringer wrote:
> PostgreSQL has to trust the hardware and the OS to do their jobs. If the
> OS is, unbeknownst to PostgreSQL, flipping the high bit in any byte

Might not even be the OS - it could be the stars (through cosmic rays).

http://www.eetimes.com/news/98/1012news/ibm.html
  '"This clearly indicates that because of cosmic rays,
   for every 256 Mbytes of memory, you'll get one soft
   error a month," said Tim Dell, senior design
   engineer for IBM Microelectronics. '

> The RAID controller might be "helpfully" "fixing" parity errors
> in a RAID 5 volume using garbage being returned by a failing disk
> during periodic RAID scrubbing.

If your raid controller doesn't have ECC memory, and if IBM's
right about those soft error stats, it might be doing more
harm than good.

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: BUG #5055: Invalid page header error
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5058: [jdbc] Silent failure with executeUpdate()