pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ian Westmacott <ianw@intellivid.com>
To: Mauri Sahlberg <Mauri.Sahlberg@claymountain.com>
Cc: pgsql-admin@postgresql.org, peikko@claymountain.com, PoRRo <theporro@saunalahti.fi>
Subject: Re: Help desperately needed: reoccurring invalid page
Date: Thu, 28 Apr 2005 08:58:18 -0400
Message-ID: <1114693098.13031.16.camel@spectre.intellivid.com> (raw)
In-Reply-To: <42708252.7070003@claymountain.com>
References: <42708252.7070003@claymountain.com>

Mauri, I'm no expert but I can tell you what I know.  We
have experienced this same problem, and I asked a
similar question not too long ago.

-  This is probably due to some sort of I/O problem.  In
   our case, it occurs very frequently on reboots, and
   it appears to be related to dirty buffers not being
   flushed out when the partition is unmounted.  Look
   into a newer kernel, and/or newer/different
   filesystem (we have seen this in various flavors
   of the 2.4.6 kernel with XFS, JFS and EXT3).

-  If you have invalid page headers, you should take a
   look at the run-time parameter zero_damaged_pages.
   You can use this to fix up a table (losing the data
   on the bad pages).

-  We have not found a way around the missing log file
   problem.  This appears to end up locking some rows
   forever.

Others on this list may be able to tell you about tools
for examining/fixing corrupt tables and log files.

	--Ian





view thread (3+ messages)  latest in thread

Message-ID: <1114693098.13031.16.camel@spectre.intellivid.com>
Permalink:  ../1114693098.13031.16.camel@spectre.intellivid.com/
Also on:    postgresql.org/message-id/1114693098.13031.16.camel@spectre.intellivid.com

 · 

reply

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: ianw@intellivid.com, Mauri.Sahlberg@claymountain.com, theporro@saunalahti.fi
  Subject: Re: Help desperately needed: reoccurring invalid page
  In-Reply-To: <1114693098.13031.16.camel@spectre.intellivid.com>
  References: <42708252.7070003@claymountain.com> <1114693098.13031.16.camel@spectre.intellivid.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