pgstat wait timeout

From: Robert Schnabel <schnabelr(at)missouri(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pgstat wait timeout
Date: 2009-07-08 15:13:45
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

I've been having an issue for about 5 months now and after upgrading to
8.4 did not fix it I figured I'd try this list. I tried the perform
list a while back but no bites.

My system: Windows XP64 SP2, dual Opteron 2218, 12G ram, PostgreSQL
8.4. I am the only person using the postgres server and I only have one
db. Yesterday I dumped from 8.3.7, installed 8.4 and restored my db to
8.4. Everything works fine except the problem that I've had since about
January. I didn't have this problem until I upgraded to 8.3.6 (I
think). It did the same thing with 8.3.7. Here is what's happening...

From a fresh server restart I have one process that will run one
processor 100% essentially forever. (I've let it go for about a week
just to see if it would ever stop and it didn't). Attached is a text
dump from ProcessExplorer. I have highlighted the relevant lines with
****. Also attached is the current postgresql log after a server
restart. You can see from the log that about every 70 seconds there is
an entry "WARNING: pgstat wait timeout". This will go on forever.
From the ProcessExplorer file, the offending process is 2384. From
within ProcessExplorer, if I suspend 2384 the log entries do not cease.
>From within ProcessExplorer, if I attach the debugger it will
immediately terminate the process and then restart with a new process
id. For the last 5 months since I noticed the problem I have resorted
to using ProcessExplorer to suspend the process, thus freeing up a CPU,
and just let the log files get cluttered. I assume this is a bug?? Any
help would be greatly appreciated.


Attachment Content-Type Size
postgresql-2009-07-08_093646.log text/plain 961 bytes
PE_postgres.txt text/plain 9.6 KB


Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2009-07-08 15:37:25 Re: Unknown winsock error 10061
Previous Message Dave Page 2009-07-08 15:02:21 Re: Unknown winsock error 10061