pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Invalid 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