The handles persist through restarting the postgresql service and restarting the IIS server. The handles are accumulating on the System process. I think the handles are created when the web service is accessed but that would mean the IIS 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 postgresql thing or other people would be seeing it.
Senior Development Engineer
11520 N. Port Washington Rd., Suite 201
Mequon, WI 53092 USA
P: 1.262.240.0291 x104
From: Marti Raudsepp [mailto:marti(at)juffo(dot)org]
Sent: Tuesday, February 28, 2012 8:23 AM
To: Adam Bruss
Subject: Re: [GENERAL] accumulating handles problem on machine running postgresql
On Tue, Feb 28, 2012 at 04:34, Adam Bruss <abruss(at)awrcorp(dot)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.
In response to
pgsql-general by date
|Next:||From: Adrian Klaver||Date: 2012-02-28 14:51:00|
|Subject: Re: archive_cleanup_command recovery.conf Standby server error|
|Previous:||From: Marti Raudsepp||Date: 2012-02-28 14:22:40|
|Subject: Re: accumulating handles problem on machine running postgresql|