[Catalyst] Database connections leaking

[Matt S Trout]

On Sat, Dec 22, 2007 at 12:21:00AM -0700, Kevin Nathan wrote:
> On Sat, 22 Dec 2007 15:34:14 +1030
> Jon Schutz <jon+catalyst at youramigo.com> wrote:
> 
> >It seems to me you would know about it, one way or another, if you had
> >3000 apache processes!
> >
> 
> It would seem so, wouldn't it? :-) From what I remember, though, we
> never saw a real increase in port 443 connections.
> 
> 
> >I would speculate that the logic in Catalyst::Model::DBI that checks
> >whether it currently has an active connection, is not working for
> >remote Postgres connections, so it keeps creating new ones.  
> 
> That makes sense. I even looked at C::M::DBI, quite a bit, but it just
> didn't make it through all my hair-pulling . . .

You might want to see about ripping out the C::M::DBI connection management
and using a DBIx::Class::Storage::DBI object instead - the Model::DBI code
originates from a copy of the DBIx::Class code but I'm unaware of whether
bugfixes and refactorings have been propagated to it.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/