From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Mikko Partio <mpartio@gmail.com>
Cc: Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound
Date: Thu, 20 May 2010 12:53:22 -0400
Message-ID: <1274373980-sup-3414@alvh.no-ip.org> (raw)
In-Reply-To: <AANLkTikOXlslvSGhfI5m96EkUMznK-sLLnhVcUuqAks7@mail.gmail.com>
References: <AANLkTikGI8SwkoNXUHyRFrwqbJufKlFS6UrzZEtp8Yt9@mail.gmail.com>
<20100519122108.GC7702@cns.vt.edu>
<AANLkTikOXlslvSGhfI5m96EkUMznK-sLLnhVcUuqAks7@mail.gmail.com>
Excerpts from Mikko Partio's message of jue may 20 00:39:00 -0400 2010:
> On Wed, May 19, 2010 at 3:21 PM, Ray Stell <stellr@cns.vt.edu> wrote:
> > http://archives.postgresql.org/pgsql-general/2007-06/msg01050.php
>
> Browsing through that thread I can see that I have similar symptoms:
>
> $ pg_controldata | grep Multi
> Latest checkpoint's NextMultiXactId: 1
> Latest checkpoint's NextMultiOffset: 0
I don't remember why I insisted talking about multixacts in that thread,
but seeing that both the poster in the 2007 thread and you have problems
with the pg_subtrans directory, not pg_multixact, these "symptoms"
actually mean nothing at all. pg_subtrans and pg_multixact are
unrelated.
I wonder if there's an off-by-one bug in SimpleLruTruncate, or perhaps
the "cutoffPage" value passed by the caller is bogus once every ten blue
moons ... hmm, it comes from GetOldestXmin ...
Being more explicit in that error message (logging the cutoffPage) would
help figuring out what's going on.
--
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: alvherre@alvh.no-ip.org, mpartio@gmail.com, stellr@cns.vt.edu
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound
In-Reply-To: <1274373980-sup-3414@alvh.no-ip.org>
* 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