Обсуждение: Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574
Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574
От
kseton@noblesys.com
Дата:
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