We've got the same issue with PostgreSQL 8.4.1 on 32 bit Windows 2003
Server RC2. Every minute the message "pgstat wait timeout" appears in Event
Viewer / Application Log.
We've tried to restart the service. It was looking like the service stopped
successfully, but two postgres.exe processes left running. One of them was
utilizing one core. It had no tcp connections in any state. It was
"C:/Program Files/PostgreSQL/8.4/bin/postgres.exe" "--forkcol" "1228"
sysinternals' procexp.exe showes the following stack for this process:
After it was killed the following appeared in the application log:
LOG: statistics collector process (PID 2680) exited with exit code 1
The service was started again and was working for aprox. 18 hours with no
errors. Then the message started appearing again.
The plan is to try PG 8.4.2.
Advices and questions are welcome ;)
sms stands for save my soul
pgsql-bugs by date
|Next:||From: Alvaro Herrera||Date: 2009-12-16 14:28:52|
|Subject: Re: pgstat wait timeout (by Robert Schnabel)|
|Previous:||From: Stefan Kaltenbrunner||Date: 2009-12-16 09:35:13|
|Subject: Re: BUG #5242: ODBC driver v8.4.1 crashed|