Re: Vacuum cancels autovacuum error message confusing? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vacuum cancels autovacuum error message confusing?
Date
Msg-id 10383.1271812389@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum cancels autovacuum error message confusing?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Move tablespace
Next
From: Fujii Masao
Date:
Subject: Re: [DOCS] Streaming replication document improvements