Re: BUG #5055: Invalid page header error

From: John R Pierce <pierce(at)hogranch(dot)com>
To: PostgreSQL bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5055: Invalid page header error
Date: 2009-09-15 05:58:35
Message-ID: 4AAF2D0B.1080208@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Craig Ringer wrote:
> [for SATA disks]: does smartctl from the smartmontools package indicate
> anything interesting about the disk(s)? (Ignore the "health status",
> it's a foul lie, and rely on the error log plus the vendor attributes:
> reallocated sector count, pending sector, uncorrectable sector count,
> etc).
>

and, if you're doing RAID with desktop grade disks, its quite possible
for the drive to spontaneously decide a sector error requires a data
relocation but not have the 'good' data to relocate, and not return an
error code in time for the RAID controller or host md-raid to do
anything about it. this results in a very sneaky sort of data
corruption which goes undetected until some time later.

this is the primary reason to use the premium "ES" grade SATA drives
rather than the cheaper desktop stuff in a raid, they return sector
errors in a timely fashion rather than retrying for many minutes in the
background.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mark Kirkwood 2009-09-15 06:22:34 Re: BUG #5054: PDO -> Query returns "" from Boolean type field, if it has false value.
Previous Message Craig Ringer 2009-09-15 05:43:15 Re: BUG #5055: Invalid page header error