Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Adam Witney <awitney@xxxxxxxxxx> writes:
> bugasbase2=# SELECT count(*) from mba_data_base;
> ERROR:  invalid page header in block 597621 of relation "mba_data_base"

Sounds like a data corruption problem :-(.  Do you want to pull out that
page and see what's in it?  Something like

	dd bs=8k skip=73333 count=1 if=relationfile | od -x

where you need to use oid2name or something similar to determine which
file contains that relation, and then append ".4" because block 597621
would be in the fifth segment of the file.  (I got 73333 from
"select 597621 % 131072")

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux