From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ian Burrell <imb@rentrak.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Invalid page header
Date: Thu, 22 Jul 2004 18:30:20 -0400
Message-ID: <13274.1090535420@sss.pgh.pa.us> (raw)
In-Reply-To: <41003B61.8070007@rentrak.com>
References: <40FFF98C.3000309@rentrak.com>
<11036.1090520647@sss.pgh.pa.us>
<41003B61.8070007@rentrak.com>
Ian Burrell <imb@rentrak.com> writes:
> Tom Lane wrote:
>> It would probably be worth your while to look at the damaged page with
>> pg_filedump before you zap it. The symptoms of hardware misfeasance and
>> software errors are enough different that you can often tell which
>> theory to believe by examining the bits.
> I used pg_filedump on a backup of the database files. The block looks
> like it is mostly zero bytes with a few x02 bytes thrown to just be
> confusing.
My interpretation of that would be a hardware glitch. A software
problem would be more likely to look like copying the wrong data
into the block, or possibly zeroing out the block when it shouldn't
--- but the sprinkling of x02's rules out a misaimed memset().
Time to break out the RAM and disk test programs ...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, imb@rentrak.com
Subject: Re: Invalid page header
In-Reply-To: <13274.1090535420@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox