I thought about this last night and remembered that the app in question was losing its connection to the database due to the firewall configuration. It was fixed by convincing the sysadmin that his firewall needs to let idle connections from the webserver to the db server stay open.
The result was the same though, dbPool tries to use a connection that it thinks is still open, but in reality is closed.
-Aaron
Thomas E Jenkins wrote:
On Mon, 2003-11-10 at 15:14, Aaron Held wrote:
Sorry,
I had the same problem with pgSQL a little over a year ago. I'm a fan of Postgres and have had million row tables, but you will get the same connection issue.
I'm guessing it must be harder to expose this error in postgres since I have converted databases from mysql to postgres and seen the problem disappear. Not that I do not believe you.
------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
