Обсуждение: autovacuum is stopping automatically....

Поиск
Список
Период
Сортировка

autovacuum is stopping automatically....

От
"Charles.Hou"
Дата:
this is the pg_log...
after 2007-12-04 10:40:37 CST 15533 , it always autovacuum "template0"
not mydatabase...
why?
i didn't change any configuration...

2007-12-04 10:14:55 CST 23858 LOG:  autovacuum: processing database
"mydatabase"
2007-12-04 10:23:15 CST 31601 LOG:  autovacuum: processing database
"postgres"
2007-12-04 10:23:35 CST 31932 LOG:  autovacuum: processing database
"test"
2007-12-04 10:23:55 CST 32234 LOG:  autovacuum: processing database
"template1"
2007-12-04 10:24:15 CST 32477 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:24:35 CST 365 LOG:  autovacuum: processing database
"roller"
2007-12-04 10:24:55 CST 668 LOG:  autovacuum: processing database
"mydatabase"
2007-12-04 10:31:29 CST 6858 LOG:  autovacuum: processing database
"roller"
2007-12-04 10:32:42 CST 8074 LOG:  autovacuum: processing database
"test"
2007-12-04 10:40:37 CST 15533 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:41:02 CST 15957 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:41:27 CST 16277 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:41:52 CST 16710 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:42:16 CST 17095 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:42:41 CST 17455 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:43:06 CST 17848 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:43:31 CST 18257 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:43:55 CST 18648 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:44:20 CST 18966 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:44:45 CST 19356 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:45:10 CST 19767 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:45:34 CST 20140 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:45:58 CST 20527 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:46:22 CST 20905 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:46:46 CST 21316 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:47:10 CST 21634 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:47:35 CST 21996 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:48:00 CST 22399 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:48:24 CST 22748 LOG:  autovacuum: processing database
"template0"
2007-12-04 10:48:49 CST 23136 LOG:  autovacuum: processing database
"template0"

Re: autovacuum is stopping automatically....

От
Alvaro Herrera
Дата:
Charles.Hou wrote:
> this is the pg_log...
> after 2007-12-04 10:40:37 CST 15533 , it always autovacuum "template0"
> not mydatabase...

Is there an ERROR in the log?  My guess is that template0 is in danger
of Xid wraparound and autovacuum wants to process it, but it can't for
some reason.

My second guess is that you are still running a version below 8.1.6, or
were for a nontrivial amount of time.  Said versions contain a bug that
can make a future vacuum on template0 error out every time.


--
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Es filósofo el que disfruta con los enigmas" (G. Coli)

Re: autovacuum is stopping automatically....

От
"Charles.Hou"
Дата:
On 12月6日, 下午10�r14分, alvhe...@alvh.no-ip.org (Alvaro Herrera) wrote:
> Charles.Hou wrote:
> > this is the pg_log...
> > after 2007-12-04 10:40:37 CST 15533 , it always autovacuum "template0"
> > not mydatabase...
>
> Is there an ERROR in the log?  My guess is that template0 is in danger
> of Xid wraparound and autovacuum wants to process it, but it can't for
> some reason.
>
> My second guess is that you are still running a version below 8.1.6, or
> were for a nontrivial amount of time.  Said versions contain a bug that
> can make a future vacuum on template0 error out every time.
>
> --
> Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
> "Es filósofo el que disfruta con los enigmas" (G. Coli)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majord...@postgresql.org so that your
>        message can get through to the mailing list cleanly

SELECT datname, age(datfrozenxid) FROM pg_database
i got 1670750918 in template0, and 1108786817 in mydatabase.
is't normal?