Skip site navigation (1) Skip section navigation (2)

Timeout error on pgstat

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Timeout error on pgstat
Date: 2012-08-01 20:27:08
Message-ID: 00dc01cd7024$07854340$168fc9c0$@devshock.com (view raw or flat)
Thread:
Lists: pgsql-admin
I have a lot (maybe 1 every 10 seconds) of this error WARNING:  pgstat wait
timeout

 

Also this 

ERROR:  canceling autovacuum task

 

In the pg_stat_activity show an autovacuum process over a very used table
that runs about 1 hour and then this vacuum is cancelled (according to log)

 

I have Postgres 9.0.3 on a windows 2008 R2 running for about 1 year in same
conditions, but this error is occurring about 1 week ago.

 

Thanks!!

Responses

pgsql-admin by date

Next:From: Craig RingerDate: 2012-08-02 02:00:41
Subject: Re: Timeout error on pgstat
Previous:From: Tom LaneDate: 2012-08-01 20:18:27
Subject: Re: [pgsql] How bad is this full vacuum error?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group