Обсуждение: pg_shdepend vacuum.
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
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
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.