From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike Williams <mike.williams@comodo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory
Date: Sun, 28 Mar 2010 15:49:50 -0400
Message-ID: <4588.1269805790@sss.pgh.pa.us> (raw)
In-Reply-To: <3c7898fc579b37bfec2f5ff971df7532.squirrel@mail.brad.office.comodo.net>
References: <201003281841.41865.mike.williams@comodo.com>
<25082.1269800427@sss.pgh.pa.us>
<3c7898fc579b37bfec2f5ff971df7532.squirrel@mail.brad.office.comodo.net>
"Mike Williams" <mike.williams@comodo.com> writes:
> The "target block" stays the same for extended periods, but does change.
Fascinating. Don't know what it means, but it's fascinating.
> Where does the 1663 number come from?
> <datadir/base>/743352/743420 is a real file, but I don't have any file 1663.
1663 is the OID of the pg_default tablespace; that's never going to
change unless you move the table to a non-default tablespace.
> The server is Gentoo, and I don't have an identical server to use. This
> machines HA partner is staying at 8.3.5 until we're completely and
> entirely sure 8.3.10 works right.
I wasn't really suggesting that you need an *identical* machine. If
this is a software problem, as seems moderately likely at this point,
it should be possible to reproduce it on a different machine. Even more
to the point, it's going to be difficult to find the problem without
tracing through the fault case with a debugger --- which isn't something
you're going to want to do on a production server. Have you got a test
machine you can load the data onto? Preferably one you could give a PG
developer access to?
<aside>Using gentoo for production servers is generally viewed with
suspicion around here; gentoo is a fine distro but, um, not especially
focused on stability. Still, there's no obvious reason to blame this on
the distro.</aside>
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, mike.williams@comodo.com
Subject: Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory
In-Reply-To: <4588.1269805790@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