Re: invalid page header

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: invalid page header
Date: 2006-03-22 14:12:27
Message-ID: 15528.1143036747@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> writes:
> "Jo De Haes" <jo(dot)de_nospam_haes(at)indicator(dot)be> wrote
>> CETERROR: XX001: invalid page header in block 22182 of relation
> "dunn_main"

> I suppose there is no system error happens during the period (like lost
> power). Can you attach the gdb at "b bufmgr.c:257" and print the content of
> "(PageHeader) bufBlock"?

Probably easier (especially if he's not using a debug-enabled build):
dump out the page from the disk file using pg_filedump, or even just
"dd | od -x".

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Brown 2006-03-22 14:13:37 Re: Enforcing serial uniqueness?
Previous Message Jim C. Nasby 2006-03-22 14:07:18 Re: xml output