From: Alvaro Herrera <alvherre@commandprompt.com>
To: Joe Conway <mail@joeconway.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Return of the Solaris vacuum polling problem -- anyone remember this?
Date: Mon, 16 Aug 2010 16:58:31 -0400
Message-ID: <1281992147-sup-9595@alvh.no-ip.org> (raw)
In-Reply-To: <4C69A3D7.8020609@joeconway.com>
References: <4C69827A.409@agliodbs.com>
<4C698CAD.2020001@joeconway.com>
<4C698D88.6030201@agliodbs.com>
<4C69A3D7.8020609@joeconway.com>
Excerpts from Joe Conway's message of lun ago 16 16:47:19 -0400 2010:
> On 08/16/2010 12:12 PM, Josh Berkus wrote:
> >
> >> I've also recently heard a report of vacuum hanging on 8.3.x on Solaris
> >> Sparc. Any chance you can get a backtrace from a build with debug symbols?
> >
> > The problem is that we haven't been able to reproduce the bug in
> > testing. Like I said, it only seems to happen occasionally ... like
> > maybe once in 10 or 20 (or more?) autovacuums. We've never been seen it
> > with a manual vacuum at all.
> >
> > And we can't rebuild the production servers.
>
> Hmmm, well I don't know how to reproduce it on demand either -- I'll try
> to get a backtrace from the wild if possible. I'll keep you posted...
FWIW there's also a report of it hanging in FreeBSD, but sadly when the
process is inspected under truss, it dies because of its "parent PID"
attribute changing underneath and thus triggering the safety feature
that makes it die if the parent postmaster disappears.
I suspect that the problem may lie in the "cost_delay rebalance" code in
autovacuum.
--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
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-hackers@postgresql.org
Cc: alvherre@commandprompt.com, mail@joeconway.com, josh@agliodbs.com
Subject: Re: Return of the Solaris vacuum polling problem -- anyone remember this?
In-Reply-To: <1281992147-sup-9595@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