perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Stosberg <>
Subject debugging 'server closed the connection unexpectedly' from PostgreSQL 8.0
Date Tue, 02 Aug 2005 20:20:34 GMT

I'm debugging why I'm getting 'server closed the connection
unexpectedly' intermittently in a modperl application.

Unfortunately it has only been seen on the production server and not on
our development server making it harder to debug.

On the database side, nothing looks unusual in the load or the logs, so
I'm suspecting there is a fix on the modperl side.

I am using Apache::DBI, and have identified a couple of aspects which
might be "special" in this part of the application:

1. The db handle is being used inside of a Data::FormValidator
constraint. From what I've read, it seems possible that the handle is
suffering some "trapped in a closure" effect. However, we use constructs
like this throughout the site without a problem, so I doubt this is
where the issue is.

2. In a couple related modules we a construct like: "our $DBH = DBI->connect()". 
We don't do that elsewhere in the application. With some effort we could
refactor the code to get rid of this. I tried switching to "local our",
but I got a test failure. (Although I didn't get to the bottom of why
that test failed before reverting). 

Usually we pass the handle around through the CGI::Application object,
and that works fine. 

I'm interested to know: Does it seem like I am even looking in the right
place to troubleshoot this? General suggestions?  


View raw message