Skip site navigation (1) Skip section navigation (2)

Re: Vacuum cancels autovacuum error message confusing?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Vacuum cancels autovacuum error message confusing?
Date: 2010-04-21 01:13:09
Message-ID: 10383.1271812389@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> vacuum...ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "bench.public.pgbench_accounts"
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "bench.public.pgbench_accounts"
> done.

> What happened above is that the build of the new pgbench database
> triggered an autovacuum, and then pgbench called a manual vacuum,
> cancelling the autovacuum.

> However, the error message which autovacuum gives does not indicate that
> it was superceded by a manual vacuum, which could confuse users and make
> them think there's some kind of actual vacuum failure.  Is it worth
> fixing the error message?

What's to fix?  The autovacuum was in fact canceled.  What would you
propose doing differently?

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2010-04-21 01:40:09
Subject: Re: [HACKERS] Streaming replication document improvements
Previous:From: Tom LaneDate: 2010-04-21 01:03:53
Subject: Re: Move tablespace

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group