Re: WARNING: pgstat wait timeout

2010/1/29 Greg Smith <greg@2ndquadrant.com>:
> I just found a few of these errors in a log file during some pgbench testing tonight.  Linux, recent CVS HEAD; given
therange of systems and versions this has been reported against now, this bug doesn't look like a platform or
version/buildspecific issue. 
>
> Unfortunately the instance I had up wasn't setup very well for logging, but I did notice that all of the ones I saw
hadnearby messages about autovacuum issues, which seems to match Tom's earlier suggestion at
http://archives.postgresql.org/pgsql-bugs/2009-07/msg00083.phpthat the source of the warning (but not necessarily the
underlyingproblem) for these is the autovacuum launcher complaining; here's two different sets: 
>
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "pgbench.public.pgbench_accounts"
> WARNING:  pgstat wait timeout
> WARNING:  pgstat wait timeout
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "pgbench.public.pgbench_accounts"
>
> WARNING:  pgstat wait timeout
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "pgbench.public.pgbench_accounts"
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "pgbench.public.pgbench_accounts"
>
> Because of what I'm (not) seeing in pg_stat_bgwriter, I'm suspicious that its underlying work or messages may be
involvedhere.  I'm not seeing the sort of totals I expect in that view after these large bouts of activity.  Now, my
usetonight has included the new pg_stat_reset_shared('bgwriter') to clear out those stats between runs, so perhaps
that'sinvolved too.  Guessing not only because of the reports going back to 8.4 that also have this error message. 
>
> Will keep an eye out for this one now that I know I might run into it, have already cranked up the logging and will
lookfor something reproducible to gather more info. 

I've seen this happen semi-frequently during initdb on win32 on an
Amazon EC2 image. I attributed it to the combination of windows and
overloaded virtualization, but it may just be that it shows up more
often there.

-- Magnus HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/