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
