Re: [BUGS] pgstat wait timeout

2009-12-17 Thread Alexey Luchko
Hi! On 16-12-2009 17:45, Magnus Hagander wrote: > http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows Thanks, it helps! Yesterday evening Windows on the server were restarted. Today the messages still appear, but not so regularly as before. There wa

Re: [BUGS] pgstat wait timeout (by Robert Schnabel)

2009-12-16 Thread Alexey Luchko
On 16-12-2009 17:45, Magnus Hagander wrote: If that is so, the OP should follow: http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows specifically the part about symbols. Which it certainly looks like :) How can I find the stats collector's process?

Re: [BUGS] pgstat wait timeout (by Robert Schnabel)

2009-12-16 Thread Alexey Luchko
On 16-12-2009 16:28, Alvaro Herrera wrote: Alexey Luchko wrote: 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 "

Re: [BUGS] pgstat wait timeout (by Robert Schnabel)

2009-12-16 Thread Alexey Luchko
Hi! 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 proce