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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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