Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_shdepend vacuum.

pg_shdepend vacuum.

From
Ranjeet Dhumal
Date:
Hi All ,

Am using postgres version 9.0.1 .
In daily postgres log am getting same kind of log for many time , is it
because of more table creation and deletion is going on and its trying to
vaccum pg_shdepend ?
But its getting canceled every time , why is it so ?

2013-02-05 00:00:09 CST [25319]: [3-1] user=,db= ERROR:  canceling
autovacuum task
2013-02-05 00:00:09 CST [25319]: [4-1] user=,db= CONTEXT:  automatic vacuum
of table "test_db.pg_catalog.pg_shdepend"


--
--Regards
  Ranjeet  R. Dhumal

Re: pg_shdepend vacuum.

From
Jeff Janes
Date:
On Thu, Feb 7, 2013 at 3:47 AM, Ranjeet Dhumal <jeetu.dhumal@gmail.com> wrote:
> Hi All ,
>
> Am using postgres version 9.0.1 .

You should upgrade to the latest minor release.  A lot of things have
been fixed since 9.0.1, including better logging of autovacuum cancels
(in 9.0.9) which will tell you what is causing the cancel.


> In daily postgres log am getting same kind of log for many time , is it
> because of more table creation and deletion is going on and its trying to
> vaccum pg_shdepend ?
> But its getting canceled every time , why is it so ?

How do you know it is canceled every time?  Unless you have cranked up
your logging, success will not be logged, only cancels.


Cheers,

Jeff

Re: pg_shdepend vacuum.

From
John Cantin
Date:
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.