Re: WARNING: pgstat wait timeout

Il 21/01/2010 03:33, Jaime Casanova ha scritto:
> On Wed, Jan 20, 2010 at 9:32 PM, Jaime Casanova
> <jcasanov@systemguards.com.ec>  wrote:
>> On Wed, Jan 20, 2010 at 6:20 PM, Sergey E. Koposov<math@sai.msu.ru>  wrote:
>>> Hello hackers,
>>>
>>> I've recently hit the message "WARNING:  pgstat wait timeout" with PG 8.4.2.
>>
>> i see the same yesterday when initdb a freshly compiled 8.5dev +
>> lock_timeout patch
>> i thought maybe it was related to that patch and was thinking in
>> recompile without the patch but hadn't time, obviously i was wrong
>>
>
> ah! i forgot to say that it was on win32 + mingw, to confirme that
> patch works fin in that os

I've seen it a few days ago with 8.5alpha3 on NetBSD when I left the 
backend running for a few days. Backend was completely inactive but the 
massage was repeated 3-4 times. Googling didn't help and I didnt' know 
how to replicate it.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/