Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574 - Mailing list pgsql-bugs

From kseton@noblesys.com
Subject Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574
Date
Msg-id 01a001d10824$8200f240$8602d6c0$@noblesys.com
Whole thread Raw
Responses Re: Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
Can you please help rectify the error below:



task_hst=# select * from systables;

ERROR:  invalid page header in block 579 of relation base/24067/12574

CONTEXT:  SQL statement "SELECT COUNT(*)

               FROM pg_indexes

WHERE tablename = myname

   AND schemaname = 'public'"

PL/pgSQL function "getidxcnt" line 5 at SQL statement



task_hst=# select * from pg_indexes;

ERROR:  invalid page header in block 637 of relation base/24067/12548



Similar errors also occur when using pg_dump on some database tables





CONFIDENTIAL NOTICE : If you have received this email in error,
please immediately notify the sender by email at the address
shown above. This email may contain confidential or legally
privileged information that is intended only for the use of the
individual or entity named in this email. If you are not the
intended recipient, you are hereby notified that any
disclosure, copying, distribution or reliance upon the contents
of this email is strictly prohibited. Please delete from your
files if you are not the intended recipient. Thank you for your
compliance.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: PQexec() hangs on OOM
Next
From: Michael Meskes
Date:
Subject: Re: BUG #13676: C typedef code generated by ecpg with wrong syntax