Thread: Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574

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.

On 10/16/2015 8:08 AM, kseton@noblesys.com wrote:
> ERROR:  invalid page header in block 579 of relation base/24067/12574

that error indicates you have data corruption on disk.      best fix is
restoring a good backup.    advisable to thoroughly check out your
storage system and hardware in general, to ensure its trustworthy



--
john r pierce, recycling bits in santa cruz