Handles fail to get released
Posted: Tue 28 Feb 2012 02:51
Hi we have a server running postgresql 9.0.3. The server has web services on it which use dotconnect for postgresql version 5.10.141.0 to insert into the database. The web services are in C#.
Everything works great except that the System process on the server fails to release handles. Eventually the handle count on the System process goes to 130,000. Then the whole machine malfunctions and I'm forced to reboot. This happens once every seven days.
I'm closing all database connections in the web service code. Has anyone had a similar problem. Do you have any suggestions? Should I upgrade my dotconnect to the latest version?
Everything works great except that the System process on the server fails to release handles. Eventually the handle count on the System process goes to 130,000. Then the whole machine malfunctions and I'm forced to reboot. This happens once every seven days.
I'm closing all database connections in the web service code. Has anyone had a similar problem. Do you have any suggestions? Should I upgrade my dotconnect to the latest version?