Search Postgresql Archives

accumulating handles problem on machine running postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I’m running Postgresql 9.0.3 on a Windows 7 box. There is one large database that gets inserted to thousands of times a day every day. 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. It takes about 6 days before a reboot is needed. This is causing our regression test machines, which do inserts into the database via a gsoap connection to a web service running on the database machine, to get bungled up every 6 days or so. Has anyone had a problem with their postgresql server where the System process accumulates handles and doesn’t release them?

 

P.S. In addition to postgresql, the Windows 7 server is running IIS 7 and asp.net web services. The web services are reached via gSOAP from various test machines on the local network, some running windows and some running linux.

I really wish I knew what was causing this. I guess it could be postgresql, the devart bindings, gsoap or the web service code itself. I’m sure I’m closing all database connections in the web service code. The database and web services function perfectly except for the handle problem.

 

Thanks,

Adam

 

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@xxxxxxxxxxx

W: http://www.awrcorp.com

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux