Home > mailing lists

Timeout error on pgstat - Mailing list pgsql-admin

From	Anibal David Acosta
Subject	Timeout error on pgstat
Date	August 1, 2012 20:27:26
Msg-id	00dc01cd7024$07854340$168fc9c0$@devshock.com Whole thread Raw
Responses	Re: Timeout error on pgstat (Craig Ringer <ringerc@ringerc.id.au>)
List	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!!

From: Tom Lane
Date: 01 August 2012, 20:18:45
Subject: Re: [pgsql] How bad is this full vacuum error?

From: Craig Ringer
Date: 02 August 2012, 02:01:07
Subject: Re: Timeout error on pgstat