Re-Connection Issue
Posted: Tue 23 May 2006 22:25
I'm running the 2.50 stable version of the driver in an ASP.NET 1.1 application. Every now and again, our DB server gets into a deadlock situation, all of the ASP.NET queries begin backing up, and then we get the exception:
"Connection Limit Exceeded For Non-Superusers"
We're running two web servers, with a basically default connection string - from what I understand includes connection pooling enabled and 100 connections in each pool.
That's one issue of oddness, we have our max connections on the server set to 500, and everything else connecting will account for no more than 100 connections. Has anyone had a similar experience? We always connection.close() and connection.dispose() after every interaction with the driver.
The larger issue - is that the driver seems to just "give up" after a certain amount of time and won't try to reconnect anymore even after all connections are freed up. We get a simple "Connection Failure" exception until we restart the application pool or IIS on both web servers. This can easily be reproduced by simply restarting our postgres server. Any ideas on this?
Thanks in advance!
"Connection Limit Exceeded For Non-Superusers"
We're running two web servers, with a basically default connection string - from what I understand includes connection pooling enabled and 100 connections in each pool.
That's one issue of oddness, we have our max connections on the server set to 500, and everything else connecting will account for no more than 100 connections. Has anyone had a similar experience? We always connection.close() and connection.dispose() after every interaction with the driver.
The larger issue - is that the driver seems to just "give up" after a certain amount of time and won't try to reconnect anymore even after all connections are freed up. We get a simple "Connection Failure" exception until we restart the application pool or IIS on both web servers. This can easily be reproduced by simply restarting our postgres server. Any ideas on this?
Thanks in advance!