From: Ian Burrell <imb@rentrak.com>
To: pgsql-admin@postgresql.org
Subject: Invalid page header
Date: Thu, 22 Jul 2004 10:29:48 -0700
Message-ID: <40FFF98C.3000309@rentrak.com> (raw)
I get the following error message when doing a select on a table:
ERROR: invalid page header in block 295 of relation "reported_titles"
I found some messages that said this means a block of this table is
corrupt. I found some suspicious lines in the server log just before:
ERROR: could not access status of transaction 3651584
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0003": No
such file or directory
How do I fix this corruption? I have dumped as much of the databases as
I can including about half of this table. Only this table is corrupt.
What could cause the corruption? We are using custom C code. Could
bugs in this be causing it? Or is hardware problems more likely?
- Ian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: imb@rentrak.com
Subject: Re: Invalid page header
In-Reply-To: <40FFF98C.3000309@rentrak.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox