Bugzilla not releasing mysql connections

[Joe Fremont]

I have just setup bugzilla and for the most part it seams to be working but
after using it for a while we can't connect to the database anymore. It
sames that every time bugzilla refreshes its creating a new connection to
the mysql database and does not release it. The only way out of this is to
either restart the mysql database or the apache server. Is there any way to
get bugzilla to automatically close its mysql connection after it has served
up a page.

My specifics:

bugzilla 3.0.3
Linux Red Hat Fedora Core 7
Perl 5.8.8
MySQL 5.0.22
Apache 2.2
Mod_perl 2.0.2

[Marc Schumann]

Joe,

2008/4/2, Joe Fremont <joe.n...@nonexistant.org>:

> I have just setup bugzilla and for the most part it seams to be working but
> after using it for a while we can't connect to the database anymore. It

[...]
> Mod_perl 2.0.2

afaik the point of mod_perl pretty much is to re-use connections, and
not release them... I'm not too much of an expert there, though, so I
can't say whether mod_perl is within its limits doing so or not.

Regards
Marc

[Joe Fremont]

Ok I think I figured it out, I had to set apache configuration correctly for
mod_perl to disable KeepAlive,

"Joe Fremont" <joe.n...@nonexistant.org> wrote in message
news:leGdnWttD7dXWW7a...@mozilla.org...

[David Miller]

Joe Fremont wrote on 4/2/08 1:39 PM:

> I have just setup bugzilla and for the most part it seams to be working but
> after using it for a while we can't connect to the database anymore. It
> sames that every time bugzilla refreshes its creating a new connection to
> the mysql database and does not release it. The only way out of this is to
> either restart the mysql database or the apache server. Is there any way to
> get bugzilla to automatically close its mysql connection after it has served
> up a page.

mod_perl reuses them on purpose. Probably need to either decrease your
MaxClients in apache or increase the max_connections in MySQL.

> My specifics:
>
> Apache 2.2
> Mod_perl 2.0.2

I'm surprised you got this to work. ExecCGI is broken in mod_perl 2.0.2
on Apache 2.2. Typically if you want to use Bugzilla with mod_perl, you
have to upgrade to mod_perl 2.0.3 (which, if you're on RHEL, usually
means recompiling an SRPM from Fedora).

--
Dave Miller http://www.justdave.net/
System Administrator, Mozilla Corporation http://www.mozilla.com/
Project Leader, Bugzilla Bug Tracking System http://www.bugzilla.org/