Invalid page header

From: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Invalid page header
Date: 2007-07-02 20:56:54
Message-ID: 46896696.4060308@pbnet.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

During some time I have had more problems with invalid data in different
parts of a PostgreSQL database.

Until now it has been pointers to non present clog files and an index
file, but now it's in a data file.
I'm getting this error when doing a backup:
invalid page header in block 5377 of relation "events"

Using pg_filedump I get the output below.
Is there any way to recover from that error except doing a restore of
the complete database ?

The errors I get tells me there must be some kind of software / hardware
failure on the server.
It's running Ubuntu 6.06LTS, in the beginning with LVM and XFS filesystem.
I expected that this combination could be the cause, so I took the
server out of service for a week
and tested everything with a burn-in testing tool from the hardware vendor.
I even ran a destructive test on the hard drives. No fault found.

I reinstalled the same Ubuntu version now using ext3 filesystem and no LVM
and now I'm in trouble again.

Any suggestions on what to do ?

Thanks
Poul

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility - Version 8.1.1
*
* File: 17455
* Options used: -y -f -R 5377 5377
*
* Dump created on: Mon Jul 2 22:37:15 2007
*******************************************************************

Block 5377 ********************************************************
<Header> -----
Block Offset: 0x02a02000 Offsets: Lower 0 (0x0000)
Block: Size 45568 Version 146 Upper 0 (0x0000)
LSN: logid 19268 recoff 0x00000000 Special 57392 (0xe030)
Items: 0 Free Space: 0
Length (including item array): 24

Error: Invalid header information.

0000: 444b0000 00000000 01000000 00000000 DK..............
0010: 30e092b2 aa2a0000 0....*..

<Data> ------
Empty block - no items listed

<Special Section> -----
Error: Invalid special section encountered.
Error: Special section points off page. Unable to dump contents.

*** End of Requested Range Encountered. Last Block Read: 5377 ***

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2007-07-02 20:57:16 Re: recovery_target_time ignored orrecoveryalwaysrecovers to end of WAL
Previous Message Tom Lane 2007-07-02 20:55:10 Re: Insert speed new post