CF 7, RH3, MySQL 3.23: Too many open files, Exceptionthrown by error-handling template

[Tico]

Please, if anyone out there has any ideas pleeeease let me know. This has been
awful. We start getting a series of the errors below

exception.log
*************************************************
"Error","scheduler-3","06/21/05","10:04:52",,""
java.lang.NullPointerException
at java.util.Arrays$ArrayList.<init>(Unknown Source)
at java.util.Arrays.asList(Unknown Source)
at coldfusion.mail.MailSpooler.refreshSpoolFiles(Mail Spooler.java:1554)
at coldfusion.mail.MailSpooler.run(MailSpooler.java:9 19)
at coldfusion.scheduling.ThreadPool.run(ThreadPool.ja va:201)
at coldfusion.scheduling.WorkerThread.run(WorkerThrea d.java:70)

06/21 10:24:17 error Too many open files
java.net.SocketException: Too many open files
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at jrun.servlet.network.NetworkService.accept(Network Service.java:368)
at jrun.servlet.jrpp.JRunProxyService.accept(JRunProx yService.java:104)
at
jrun.servlet.jrpp.JRunProxyService.createRunnable( JRunProxyService.java:120)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.creat eRunnable(ThreadPool.java:316)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.createRu nnable(ThreadPool.java:378)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.createR unnable(ThreadPool.java:270)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :62)

and then we get:

application.log
*************************************************
"Error","jrpp-746","06/21/05","10:16:28",,"Exception thrown by error-handling
template:"
"Error","jrpp-746","06/21/05","10:16:28",," The specific sequence of files
included or processed is:
/data/local/coldfusionmx7/wwwroot/WEB-INF/exception/java/lang/Exception.cfm "

then finally the system dies after getting:

06/21 10:28:09 Error [scheduler-4] -
SQLException while attempting to connect: java.sql.SQLException: Cannot
connect to MySQL server on localhost:3306. Is there a MySQL server running on
the machine/port
you are trying to connect to? (java.net.SocketException)
Cannot connect to MySQL server on localhost:3306. Is there a MySQL server
running on the machine/port you are trying to connect to?
(java.net.SocketException)
Cannot connect to MySQL server on localhost:3306. Is there a MySQL server
running on the machine/port you are trying to connect to?
(java.net.SocketException)


I've grepped the access_logs and nothing corresponds (no GET requests) so it
must be something internal. But what? This brings down our system several times
a day. I'm not seeing any consistent application errors either caused by one
specific page.

RH 3
CF 7
MySQL 3.23
Apache 2

Any help would be greatly appreciated. Really really greatly appreciated.

[xentrix]

You need to bump up the file descriptors limit in Linux. By default it's 1000
but that's not enough, so try raising it to 4000.

The command to use is something like "ulimit -a 4000" (but definately double
check this).

Andy