From: Tom Lane <tgl@sss.pgh.pa.us>
To: Darren Reed <darrenr+postgres@fastmail.net>
Cc: Shoaib Mir <shoaibmir@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to reindex when unable to open relation?
Date: Tue, 26 Feb 2008 02:09:21 -0500
Message-ID: <26317.1204009761@sss.pgh.pa.us> (raw)
In-Reply-To: <47C3B8EC.902@fastmail.net>
References: <47C3AE1F.2010804@fastmail.net>
<bf54be870802252233o5d7aa387o2c1eac2fcd2ae9fe@mail.gmail.com>
<26104.1204008849@sss.pgh.pa.us>
<47C3B8EC.902@fastmail.net>
Darren Reed <darrenr+postgres@fastmail.net> writes:
> Tom Lane wrote:
>> ...
>> There's no info here to suggest exactly what went wrong; Darren, do you
>> want to fess up to any hardware problems, tripped-over power cords, or
>> such? What PG version is this anyway?
> This is 8.2.6... and I'm starting to believe the hardware is just borked,
> with all of the other troubles I've had.
Well, there are no known data-loss bugs in 8.2.6, with of course the
operative word being "known" ...
> In an earlier bringup of the database, I received an error intended for
> Linux kernels on a BSD box about a page not being zero...
Yeah, I know exactly which message you mean; it was a defense against a
bug that was present for a relatively short time in a few Linux kernel
versions, and could only be exposed on multi-CPU hardware even so.
If you're seeing that and other problems on a BSD kernel then I agree
that hardware issues seem like a likely explanation. Have you tried
running memtest86 and any other hardware diagnostics you can lay your
hands on?
regards, tom lane
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, darrenr+postgres@fastmail.net, shoaibmir@gmail.com
Subject: Re: How to reindex when unable to open relation?
In-Reply-To: <26317.1204009761@sss.pgh.pa.us>
* 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