usually a default OS install does not have enough
available file handles for use as a webserver.

Consider using ulimit -n, and ndd or sysctl settings
for file descriptors.

On a busy site you may need to increase the hard limit
by also modifying the kernel FDMAX #define and rebuilding.

Or you might just be having leaky code ...

Frank Sonnemans wrote:
>  
>  I am currently building an intranet site which uses a Postgresql database
>  backend. Unfortunately the database server is opening more files for every
>  SQL request from the web site. This quickly leads to a crash after the
>  kernels file table has filled up.
>  
>  As of today I have no idea about the cause of the problem. Initially I
>  blamed Apache::DBI and therefore I disabled it, adding $dbh->disconnect
>  statements to my code. However this has not solved the problem.
>  
>  My server runs the following software:
>  
>  FreeBSD 4.0 or FreeBSD 4.2 stable
>  Apache 1.3
>  ModPerl
>  Apache::DBI (disabling this doesn't change anything)
>  HTML::Mason
>  
>  Any ideas on the cause of the problems. Any similar experiences?
>  
>  Thanks in advance for your reply.
>  
>  Frank Sonnemans

--
ActiveMessage - Targeted Email Marketing
Ask me for a free outbound email trial account!
http://ActiveMessage.com