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

From: kseton(at)noblesys(dot)com
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574
Date: 2015-10-16 15:08:26
Message-ID: 01a001d10824$8200f240$8602d6c0$@noblesys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Meskes 2015-10-16 15:33:17 Re: BUG #13676: C typedef code generated by ecpg with wrong syntax
Previous Message Michael Paquier 2015-10-16 02:00:51 Re: PQexec() hangs on OOM