From: Scott Marlowe <smarlowe@g2switchworks.com>
To: ashok@kalculate.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Invalid page header in block 211 of relation
Date: Tue, 02 Jan 2007 14:11:32 -0600
Message-ID: <1167768692.29707.30.camel@state.g2switchworks.com> (raw)
In-Reply-To: <380-2200712212446327@M2W041.mail2web.com>
References: <380-2200712212446327@M2W041.mail2web.com>
On Tue, 2007-01-02 at 06:04, ashok@kalculate.com wrote:
> Hi List,
>
> I'm using postgresql 7.4 on FC4 linux.
> i have one table named "purchase". it is working fine since 10 months but
> suddenly from 3-4 days it creates problem.
> when i'm fire a simple "select * from purchase" query on psql prompt,it
> gives following error:
>
> Invalid page header in block 211 of relation "purchase".
>
> i cannot understand what is the problem, why it is giving this error.
> plz. help me.
This is a serious problem. Most of the time you see this it can be
blamed on broken hardware, although on rare occasions a pgsql bug might
be causing it.
There are several things you can do, and they kind of depend on the
answer to the question "How important are the data in your database?"
Can you take this machine out of production to test it? I'd recommend a
good memory tester and to check your drives for possible errors.
Has this machine crashed or had the power plug pulled lately? If so, it
might be a problem with IDE hard drives and fsyncing.
Lastly, got a backup?
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@g2switchworks.com, ashok@kalculate.com
Subject: Re: Invalid page header in block 211 of relation
In-Reply-To: <1167768692.29707.30.camel@state.g2switchworks.com>
References: <380-2200712212446327@M2W041.mail2web.com> <1167768692.29707.30.camel@state.g2switchworks.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