pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
vacuum fails with 'invalid page header' message
4+ messages / 2 participants
[nested] [flat]

* vacuum fails with 'invalid page header' message
@ 2007-01-05 21:29 Geoffrey <esoteric@3times25.net>
  2007-01-05 22:19 ` Re: vacuum fails with 'invalid page header' message Geoffrey <esoteric@3times25.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Geoffrey @ 2007-01-05 21:29 UTC (permalink / raw)
  To: pgsql-admin; pgsql-general@postgresql.org

We had a vacuum fail recently with the following error:

invalid page header in block 846 of relation "move_pkey"

Anyone have an idea what could cause this problem and what we need to do 
  to resolve it?

Running on Red Hat Enterprise 3, postgres 7.4.13

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: vacuum fails with 'invalid page header' message
  2007-01-05 21:29 vacuum fails with 'invalid page header' message Geoffrey <esoteric@3times25.net>
@ 2007-01-05 22:19 ` Geoffrey <esoteric@3times25.net>
  2007-01-05 22:21   ` Re: vacuum fails with 'invalid page header' message Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Geoffrey @ 2007-01-05 22:19 UTC (permalink / raw)
  To: pgsql-admin; pgsql-general@postgresql.org

Geoffrey wrote:
> We had a vacuum fail recently with the following error:
> 
> invalid page header in block 846 of relation "move_pkey"
> 
> Anyone have an idea what could cause this problem and what we need to do 
>  to resolve it?
> 
> Running on Red Hat Enterprise 3, postgres 7.4.13

Regarding the issue above, is it possible that re-indexing the database 
could resolve the problem, since the error is related to an index. 
move_pkey is an index on field recid.

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: vacuum fails with 'invalid page header' message
  2007-01-05 21:29 vacuum fails with 'invalid page header' message Geoffrey <esoteric@3times25.net>
  2007-01-05 22:19 ` Re: vacuum fails with 'invalid page header' message Geoffrey <esoteric@3times25.net>
@ 2007-01-05 22:21   ` Scott Marlowe <smarlowe@g2switchworks.com>
  2007-01-06 10:01     ` Re: vacuum fails with 'invalid page header' message Geoffrey <esoteric@3times25.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Scott Marlowe @ 2007-01-05 22:21 UTC (permalink / raw)
  To: Geoffrey <esoteric@3times25.net>; +Cc: pgsql-admin@postgresql.org, pgsql general <pgsql-general@postgresql.org>

On Fri, 2007-01-05 at 16:19, Geoffrey wrote:
> Geoffrey wrote:
> > We had a vacuum fail recently with the following error:
> > 
> > invalid page header in block 846 of relation "move_pkey"
> > 
> > Anyone have an idea what could cause this problem and what we need to do 
> >  to resolve it?
> > 
> > Running on Red Hat Enterprise 3, postgres 7.4.13
> 
> Regarding the issue above, is it possible that re-indexing the database 
> could resolve the problem, since the error is related to an index. 
> move_pkey is an index on field recid.

Yes, reindex might fix it.

But more than likely there's a problem with your hardware somewhere, and
it needs to be checked out carefully for problems.  i.e. bad hard drive,
memory, cpu, etc...



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: vacuum fails with 'invalid page header' message
  2007-01-05 21:29 vacuum fails with 'invalid page header' message Geoffrey <esoteric@3times25.net>
  2007-01-05 22:19 ` Re: vacuum fails with 'invalid page header' message Geoffrey <esoteric@3times25.net>
  2007-01-05 22:21   ` Re: vacuum fails with 'invalid page header' message Scott Marlowe <smarlowe@g2switchworks.com>
@ 2007-01-06 10:01     ` Geoffrey <esoteric@3times25.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Geoffrey @ 2007-01-06 10:01 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org, pgsql general <pgsql-general@postgresql.org>

Scott Marlowe wrote:
> On Fri, 2007-01-05 at 16:19, Geoffrey wrote:
>> Geoffrey wrote:
>>> We had a vacuum fail recently with the following error:
>>>
>>> invalid page header in block 846 of relation "move_pkey"
>>>
>>> Anyone have an idea what could cause this problem and what we need to do 
>>>  to resolve it?
>>>
>>> Running on Red Hat Enterprise 3, postgres 7.4.13
>> Regarding the issue above, is it possible that re-indexing the database 
>> could resolve the problem, since the error is related to an index. 
>> move_pkey is an index on field recid.
> 
> Yes, reindex might fix it.
> 
> But more than likely there's a problem with your hardware somewhere, and
> it needs to be checked out carefully for problems.  i.e. bad hard drive,
> memory, cpu, etc...

After reindexing the table, vacuum full completes successfully.  Would 
this be an indication the reindexing corrected the problem?

Anything else the could possibly cause this problem?  The sys admin is 
doubtful it's hardware related.  We don't see any errors in the system 
logs to indicate there's a problem.

Is it possible that our application could cause such corruption?

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-01-06 10:01 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-05 21:29 vacuum fails with 'invalid page header' message Geoffrey <esoteric@3times25.net>
2007-01-05 22:19 ` Geoffrey <esoteric@3times25.net>
2007-01-05 22:21   ` Scott Marlowe <smarlowe@g2switchworks.com>
2007-01-06 10:01     ` Geoffrey <esoteric@3times25.net>

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