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

Re: pgstat wait timeout

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgstat wait timeout
Date: 2011-12-28 13:05:41
Message-ID: 1325077369-sup-2321@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Excerpts from Steve Crawford's message of mar dic 27 22:51:06 -0300 2011:
> I have a system (9.0.4 on Ubuntu Server 10.04 LTS x86_64) that is 
> currently in test/dev mode. I'm currently seeing the following messages 
> occurring every few seconds:
> 
> ...
> Dec 27 17:43:22 foo postgres[23693]: [6-1] : WARNING:  pgstat wait timeout
> Dec 27 17:43:27 foo postgres[27324]: [71400-1] : WARNING:  pgstat wait 
> timeout
> Dec 27 17:43:33 foo postgres[23695]: [6-1] : WARNING:  pgstat wait timeout
> Dec 27 17:43:54 foo postgres[27324]: [71401-1] : WARNING:  pgstat wait 
> timeout

Hm, so can you strace the stats collector to see what it's doing?  Maybe
grab a backtrace with GDB from it before anything else.

My guess is 27324 is the autovac launcher and the others are autovac
workers just as they die.

-- 
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2011-12-28 13:38:54
Subject: Re: Review of VS 2010 support patches
Previous:From: Tatsuo IshiiDate: 2011-12-28 12:03:44
Subject: Re: spinlocks on HP-UX

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