pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedInvalid page header in block 211 of relation
2+ messages / 2 participants
[nested] [flat]
* Invalid page header in block 211 of relation
@ 2007-01-02 12:04 ashok@kalculate.com <ashok@kalculate.com>
0 siblings, 1 reply; 2+ messages in thread
From: ashok@kalculate.com @ 2007-01-02 12:04 UTC (permalink / raw)
To: pgsql-admin
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.
Thanks
Ashok
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Invalid page header in block 211 of relation
@ 2007-01-02 20:11 Scott Marlowe <smarlowe@g2switchworks.com>
parent: ashok@kalculate.com <ashok@kalculate.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2007-01-02 20:11 UTC (permalink / raw)
To: ashok@kalculate.com; +Cc: pgsql-admin
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-01-02 20:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-02 12:04 Invalid page header in block 211 of relation ashok@kalculate.com <ashok@kalculate.com>
2007-01-02 20:11 ` Scott Marlowe <smarlowe@g2switchworks.com>
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