From: Alvaro Herrera <alvherre@commandprompt.com>
To: Pablo Delgado Díaz-Pache <delgadop@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Autovacuum seems to block database: WARNING worker took too long to start
Date: Tue, 16 Nov 2010 16:09:34 -0300
Message-ID: <1289934330-sup-4464@alvh.no-ip.org> (raw)
In-Reply-To: <AANLkTimTzDmWfmfH8ox5_Hfcga-MYs0ueAXzu553DYE3@mail.gmail.com>
References: <AANLkTimt7_wbadtOkM9HqzeHmADmxb2TvuQD5yBUwkdZ@mail.gmail.com>
<6991.1289762128@sss.pgh.pa.us>
<AANLkTinsGLeRc26RT5Kb4_HEhow5e97p0ZBveg=p9xqS@mail.gmail.com>
<1289918622-sup-8461@alvh.no-ip.org>
<AANLkTimTzDmWfmfH8ox5_Hfcga-MYs0ueAXzu553DYE3@mail.gmail.com>
Excerpts from Pablo Delgado Díaz-Pache's message of mar nov 16 12:18:09 -0300 2010:
> Not sure what you mean.
>
> Once we start getting that error in the postgres log, there is no autovacuum
> entry. Only that error message once every minute (and as i wrote in my last
> email, the same message all the time).
Yeah. This means that the autovacuum launcher daemon is still running
and trying to schedule new jobs, but it's not able to for some reason.
When it tries to start a new one, it sees the old one still waiting to
start running; and then it logs this message.
To start a new job, what it does is send a signal to postmaster and wait
for it to create a child process. This is the part that's not working.
> The question is what is causing postgres to stop working. Autovacuum or
> another reason? If it's another reason ... what could it be?
I have no idea what's going on. I have never seen this problem. If you
see it happen again, please get a stacktrace from postmaster; and/or
strace it.
--
Á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-admin@postgresql.org
Cc: alvherre@commandprompt.com, delgadop@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Autovacuum seems to block database: WARNING worker took too long to start
In-Reply-To: <1289934330-sup-4464@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