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
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