Re: "invalid page header in block 597621 of relation..."error

On 23/11/05 9:36 pm, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Adam Witney <awitney(at)sgul(dot)ac(dot)uk> writes:
>> Thanks for the help.... Here is the output:
>
>> adam(at)bugsdb:/opt$ dd bs=8k skip=73333 count=1 if=134401991.4 | od -x
>> 0000000 0000 0000 0000 0000 0000 0000 0000 0000
>> *
>> 0010000 1d9e 201c 0fa0 0000 0010 0000 0000 000b
>> 0010020 0ca6 19fb 1797 0ab4 000a 0000 0000 0001
>> 0010040 01af 0000 000a 0000 0000 0001 0ca7 0000
>> 0010060 0012 0000 0000 0010 0002 1190 068f 0c9a
>> ...
>
>> Unfortunately I have no idea what any of that means!
>
> The second half of the page looks reasonable, but the first half
> is all zeroes :-(. (dd uses "*" to mean "same as above".)
>
> It's unlikely that this is Postgres' fault; I can't think of any
> plausible pathology within PG that would so carefully zero out just
> half of a page. What seems more likely is that the block size on the
> underlying filesystem is 4K, and that either a kernel bug or a disk
> drive error has caused the system to drop the contents of one block.
> If I had to bet with no additional info, I'd bet on kernel bug. What's
> the platform exactly, and what filesystem are you using?

Linux bugsdb 2.4.26 #1 SMP Wed May 5 12:08:48 BST 2004 i686 unknown

/dev/md2 on /pg_data type xfs (rw,noatime)

/dev/md2 is a software RAID5 device. Also

PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC 2.95.4

This table is only ever COPY'd to from data files, no updates or deletes, if
I could find out which data file this bit comes from I could just reupload
that file... Is it possible to tell what the data actually is from the data
I sent?

Thanks again

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.