The handles persist through restarting the postgresql service and restarting the IIS server. The handles are
accumulatingon the System process. I think the handles are created when the web service is accessed but that would mean
theIIS worker processes would have responsibility and they don't seem to. Recycling the worker processes in IIS does
nothing.And the worker processes have their own process w3wp.exe which never accumulate handles. It's probably not a
postgresqlthing or other people would be seeing it.
Adam Bruss
Senior Development Engineer
AWR Corporation
11520 N. Port Washington Rd., Suite 201
Mequon, WI 53092 USA
P: 1.262.240.0291 x104
F: 1.262.240.0294
E: abruss@awrcorp.com
W: http://www.awrcorp.com
-----Original Message-----
From: Marti Raudsepp [mailto:marti@juffo.org]
Sent: Tuesday, February 28, 2012 8:23 AM
To: Adam Bruss
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] accumulating handles problem on machine running postgresql
On Tue, Feb 28, 2012 at 04:34, Adam Bruss <abruss@awrcorp.com> wrote:
> The problem is the
> Handle count on the Windows System process of the server, image name
> c:\windows\system32\ntoskrnl.exe, accumulates over time and the handles
> never get released. This causes the handle count to go to about 130,000 at
> which time the machine starts malfunctioning and a reboot is needed.
Do these handles go away when you restart any of these services? If
it's a user space code problem then the handles should get freed
automatically after the process exits.
Regards,
Marti