Re: canceling autovacuum task woes

Excerpts from Robert Haas's message of mar jul 24 15:52:23 -0400 2012:
> On Tue, Jul 24, 2012 at 3:35 PM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:
> > Yep, it says:
> >
> > ERROR:  canceling autovacuum task
> > CONTEXT:  automatic vacuum of table "alvherre.public.foo"
> >
> > So at least that part seems pilot error more than anything else.
>
> Yeah, you're right.  So you do get the table name.  But you don't get
> the cause, which is what you really need to understand why it's
> happening.  Attached is a patch that adds some more detail.  Here's an
> example of what the output looks like:
>
> LOG:  sending cancel to blocking autovacuum PID 21595
> DETAIL:  Process 21618 waits for AccessExclusiveLock on relation 27863
> of database 16384
> STATEMENT:  drop table if exists pgbench_accounts
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic vacuum of table "rhaas.public.pgbench_accounts"

Looks great.  Are you considering backpatching this?


--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support