Re: pgstat wait timeout (by Robert Schnabel)

On Wed, Dec 16, 2009 at 16:12, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)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 actually
> in mdpostckpt at all.  Probably this is a stripped executable and
> mdpostckpt is just the nearest global symbol.

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 :)

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/