Re: Win32 hard crash problem - Mailing list pgsql-hackers

From Zeugswetter Andreas DCP SD
Subject Re: Win32 hard crash problem
Date
Msg-id E1539E0ED7043848906A8FF995BDA579014DBE80@m0143.s-mxs.net
Whole thread Raw
In response to Re: Win32 hard crash problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> >> My bet is something depending on GetTickCount to measure elapsed
time
> >> (and no, it's not used in the core Postgres code, but you've got
> >> plenty of other possible culprits in that stack).
>
> > This doesn't quite make sense. The only reason we have to reboot is
> > because PostgreSQL no longer responds. The system itself is fine.
>
> The Windows kernel may still work, but that doesn't mean that
> everything Postgres depends on still works.

It may be a not reacting listen socket. This may be because of a handle
leak. Next time it blocks look at the handle counts (e.g. with
handle.exe
from sysinternals).

You could also look for handle count now with Task Manager and see if it
increases constantly. (handle.exe shows you the details)

Andreas


pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Win32 hard crash problem
Next
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: Prepared statements considered harmful