Search Postgresql Archives

Re: pg_shdepend vacuum.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux