Re: template1 database is facing high datfrozenxid

On 02/12/2016 02:56 PM, AI Rumman wrote:
> Hi,
>
> I am running Postgresql 9.1 and I can see the datfrozenxid is going high
> and vacuum process is not bringing it down. And this has been happening
> on template1 database.
>
>     2016-02-12 16:51:50.400 CST [19445][@] : [13-1] WARNING:  oldest
>     xmin is far in the past
>     2016-02-12 16:51:50.400 CST [19445][@] : [14-1] HINT:  Close open
>     transactions soon to avoid wraparound problems.

The above seems to be the contributing factor.

Does:

select * from pg_stat_activity

show long running queries.

>     2016-02-12 16:51:50.400 CST [19445][@] : [15-1] LOG:  automatic
>     vacuum of table "template1.pg_catalog.pg_database": index scans: 0
>     pages: 0 removed, 1 remain
>     tuples: 0 removed, 9 remain
>     system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec
>     2016-02-12 16:51:50.411 CST [19435][@] : [82-1] WARNING:  oldest
>     xmin is far in the past
>     2016-02-12 16:51:50.411 CST [19435][@] : [83-1] HINT:  Close open
>     transactions soon to avoid wraparound problems.
>     2016-02-12 16:51:50.411 CST [19435][@] : [84-1] LOG:  automatic
>     vacuum of table "template1.pg_catalog.pg_largeobject": index scans: 0
>     pages: 0 removed, 0 remain
>     tuples: 0 removed, 0 remain
>     system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec
>
>
> I vacuum database manually but nothing is working out.
> Please help,
>
> Thanks.


--
Adrian Klaver
adrian.klaver@aklaver.com