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

Re: WARNING: pgstat waiting

From: Thom Brown <thom(at)linux(dot)com>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WARNING: pgstat waiting
Date: 2011-09-10 16:43:20
Message-ID: CAA-aLv51whjeqeLawpwEh5prVbjC24K+hJjE2jRWVP58fD+Ljw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 10 September 2011 17:40, Andy Colson <andy(at)squeakycode(dot)net> wrote:
> I'm playing with 9.2devel, and I can fill my logs with:
>
> WARNING:  pgstat waiting for 5001623 usec (494 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5011780 usec (495 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5021947 usec (496 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5032115 usec (497 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5042254 usec (498 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5052400 usec (499 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
>
> I see its from here:
>
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=79b2ee20c8a041a85dd230c4e787bef22edae57b
>
> So I was wondering if there is anything I can help with?  Not sure if you
> need a reproducible case, or something you'd like me to try?

I've had exactly the same sort of messages, pages of them.  But wasn't
quite sure what I needed to recreate it.

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgsql-hackers by date

Next:From: Andy ColsonDate: 2011-09-10 16:49:27
Subject: Re: WARNING: pgstat waiting
Previous:From: Andy ColsonDate: 2011-09-10 16:40:48
Subject: WARNING: pgstat waiting

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