[rt-users] Database connections not closing

[Vivek Khera]

On Dec 20, 2005, at 6:46 PM, Pascal Lalonde wrote:

> Now the problem is that the connections to PostgreSQL are not closed
> properly; they remain open. After some time, the system runs out of
> available file descriptors.

Two things: either increase the number of max connections allowed by  
your Postgres installation or decrease the max number of apache  
children you allow to run RT.

RT in mod_perl uses Apache::DBI to cache the db connections, so the  
children keep the connection open until they die.  This is expected.

Now, if your web server is also serving up other pages, then you're  
gonna end up with lots of way oversized httpd processes doing the  
wrong thing.  Best is to dedicate one apache instance for RT and/or  
use FastCGI to run RT.