Re: pg_shdepend vacuum. - Mailing list pgsql-general

From John Cantin
Subject Re: pg_shdepend vacuum.
Date
Msg-id 1385136891280-5779785.post@n5.nabble.com
Whole thread Raw
In response to Re: pg_shdepend vacuum.  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
I'm experiencing the same thing with 9.0.4 running on win server 2003.  Reams
of messages like this... (I've changed the database names in the following
log snipit)

2013-11-22 09:37:42 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:42 CST    CONTEXT:  automatic vacuum of table
"x1.pg_catalog.pg_shdepend"
2013-11-22 09:37:42 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:42 CST    CONTEXT:  automatic vacuum of table
"x2.pg_catalog.pg_shdepend"
2013-11-22 09:37:43 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:43 CST    CONTEXT:  automatic vacuum of table
"x3.pg_catalog.pg_shdepend"
2013-11-22 09:37:44 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:44 CST    CONTEXT:  automatic vacuum of table
"x4.pg_catalog.pg_shdepend"
2013-11-22 09:37:45 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:45 CST    CONTEXT:  automatic vacuum of table
"x5.pg_catalog.pg_shdepend"
2013-11-22 09:37:45 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:45 CST    CONTEXT:  automatic vacuum of table
"x6.pg_catalog.pg_shdepend"
2013-11-22 09:37:46 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:46 CST    CONTEXT:  automatic vacuum of table
"x7.pg_catalog.pg_shdepend"
2013-11-22 09:37:47 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:47 CST    CONTEXT:  automatic vacuum of table
"x8.pg_catalog.pg_shdepend"
2013-11-22 09:37:48 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:48 CST    CONTEXT:  automatic vacuum of table
"x9.pg_catalog.pg_shdepend"
2013-11-22 09:37:48 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:48 CST    CONTEXT:  automatic vacuum of table
"x10.pg_catalog.pg_shdepend"
2013-11-22 09:37:49 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:49 CST    CONTEXT:  automatic vacuum of table
"x11.pg_catalog.pg_shdepend"
2013-11-22 09:37:50 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:50 CST    CONTEXT:  automatic vacuum of table
"x12.pg_catalog.pg_shdepend"
2013-11-22 09:37:51 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:51 CST    CONTEXT:  automatic vacuum of table
"x13.pg_catalog.pg_shdepend"
2013-11-22 09:37:52 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:52 CST    CONTEXT:  automatic vacuum of table
"x15.pg_catalog.pg_shdepend"
2013-11-22 09:37:52 CST    ERROR:  canceling autovacuum task
2013-11-22 09:37:52 CST    CONTEXT:  automatic vacuum of table
"x14.pg_catalog.pg_shdepend"
2013-11-22 09:37:53 CST    ERROR:  canceling autovacuum task

The messages travel across ALL the databases that we have but only seem to
involve the pg_shdepend table.

They even involve the template databases, and databases that have virtually
no activity.

2013-11-22 09:38:03 CST    CONTEXT:  automatic vacuum of table
"template0.pg_catalog.pg_shdepend"

2013-11-22 08:25:14 CST    CONTEXT:  automatic analyze of table
"template1.pg_catalog.pg_shdepend"

The errors repeat approximately every minute.





--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-shdepend-vacuum-tp5744209p5779785.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting non_NULL right-side values on a non-matching join?
Next
From:
Date:
Subject: Puzzling table scan in a CTE