Skip site navigation (1) Skip section navigation (2)

Re: Invalid page header

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ian Burrell <imb(at)rentrak(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Invalid page header
Date: 2004-07-22 22:30:20
Message-ID: 13274.1090535420@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Ian Burrell <imb(at)rentrak(dot)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

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2004-07-22 22:37:21
Subject: Re: [ADMIN] how to find transaction associated with a lock
Previous:From: Ian BurrellDate: 2004-07-22 22:10:41
Subject: Re: Invalid page header

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group