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

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

2009-12-16 Thread Alvaro Herrera
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 C:/Program Files/PostgreSQL/8.4/bin/postgres.exe

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 C:/Program

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

2009-12-16 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Alexey Luchko wrote: postgres.exe!mdpostckpt+0x181b38 postgres.exe!mdpostckpt+0x18bbdb This stack trace seems bogus. The stats collector should not be calling mdpostckpt at all. Given the size of the offsets, it's pretty clear that it's not

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

2009-12-16 Thread Magnus Hagander
On Wed, Dec 16, 2009 at 16:12, Tom Lane t...@sss.pgh.pa.us wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Alexey Luchko wrote: postgres.exe!mdpostckpt+0x181b38 postgres.exe!mdpostckpt+0x18bbdb This stack trace seems bogus.  The stats collector should not be calling mdpostckpt at

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

2009-12-16 Thread Robert Haas
On Wed, Dec 16, 2009 at 10:45 AM, Magnus Hagander mag...@hagander.net wrote: On Wed, Dec 16, 2009 at 16:12, Tom Lane t...@sss.pgh.pa.us wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Alexey Luchko wrote: postgres.exe!mdpostckpt+0x181b38 postgres.exe!mdpostckpt+0x18bbdb This stack

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

2009-12-16 Thread Alvaro Herrera
Robert Haas escribió: We should really take some of the vast quantity of really useful information that is in the wiki and try to index it somehow or incorporate it into the docs. I'm always learning about new pages that have good stuff on them, but I never seem to stumble across them

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

2009-12-16 Thread Robert Haas
On Wed, Dec 16, 2009 at 11:05 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: Robert Haas escribió: We should really take some of the vast quantity of really useful information that is in the wiki and try to index it somehow or incorporate it into the docs.  I'm always learning about new

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

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

2009-12-16 Thread Magnus Hagander
On Wed, Dec 16, 2009 at 17:43, Alexey Luchko l...@ank-sia.com wrote: 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

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

2009-12-16 Thread Craig Ringer
On 16/12/2009 11:55 PM, Robert Haas wrote: On Wed, Dec 16, 2009 at 10:45 AM, Magnus Hagandermag...@hagander.net wrote: On Wed, Dec 16, 2009 at 16:12, Tom Lanet...@sss.pgh.pa.us wrote: Alvaro Herreraalvhe...@commandprompt.com writes: Alexey Luchko wrote: postgres.exe!mdpostckpt+0x181b38

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

2009-12-16 Thread Robert Haas
On Wed, Dec 16, 2009 at 9:03 PM, Craig Ringer cr...@postnewspapers.com.au wrote: On 16/12/2009 11:55 PM, Robert Haas wrote: On Wed, Dec 16, 2009 at 10:45 AM, Magnus Hagandermag...@hagander.net  wrote: On Wed, Dec 16, 2009 at 16:12, Tom Lanet...@sss.pgh.pa.us  wrote: Alvaro