Re: [Catalyst] Database connections leaking

2007-12-31 Thread Kevin Nathan
On Mon, 24 Dec 2007 18:22:13 + Matt S Trout [EMAIL PROTECTED] wrote: 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

Re: [Catalyst] Database connections leaking

2007-12-24 Thread 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 [EMAIL PROTECTED] 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,

[Catalyst] Database connections leaking

2007-12-21 Thread knathan
Just for background, I have inherited a Catalyst/TT/Postgresql/Apache2/mod_perl web application. The programmer that was responsible for the design and initial coding left our company and is unavailable for consults. I am very new to Catalyst, fair level of experience in TT, Perl and

Re: [Catalyst] Database connections leaking

2007-12-21 Thread Jon Schutz
On Fri, 2007-12-21 at 18:34 -0700, [EMAIL PROTECTED] wrote: The program seems to be working fine while on the Catalyst test server, and when on an Apache/mod_perl server when the postgres database is on the same physical server. The database connections don't start leaking until we

Re: [Catalyst] Database connections leaking

2007-12-21 Thread Kevin Nathan
On Sat, 22 Dec 2007 13:32:00 +1030 Jon Schutz [EMAIL PROTECTED] wrote: On Fri, 2007-12-21 at 18:34 -0700, [EMAIL PROTECTED] wrote: The program seems to be working fine while on the Catalyst test server, and when on an Apache/mod_perl server when the postgres database is on the same

Re: [Catalyst] Database connections leaking

2007-12-21 Thread Jon Schutz
On Fri, 2007-12-21 at 21:32 -0700, Kevin Nathan wrote: I can't check the server right now (need to be at work for that), but I didn't think to watch for Apache/mod_perl processes. What we were looking for was port 5432 connections (postgres). When it works, we get two or three connections

Re: [Catalyst] Database connections leaking

2007-12-21 Thread Kevin Nathan
On Sat, 22 Dec 2007 15:34:14 +1030 Jon Schutz [EMAIL PROTECTED] 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