Subject Re: [firebird-support] Database Errors: "Too many files open"
Author Milan Babuskov
Eugene Lidede wrote:
> I/O error for file "<DB_FILENAME>" Error while trying to open file
> Too many open files
>
> I run Apache 1.3.39; Linux 2.6.9; with PHP 5.2.4 and firebird 1.5.4
> The error started appearing a week ago out of the blues
>
> What causes this error and how do i fix this

Apparently you have hit the OS limit for the file handles. You can try
to detect which program is causing by dumping output of:

lsof | awk '{print $1}'

into some (Firebird) database and doing count(*) group by process name.

To see what is your OS limit and to increase it, you can use ulimit
command. To show the limit:

ulimit -n

To change it to, for example, 4096:

ulimit -n 4096


--
Milan Babuskov
http://www.guacosoft.com