Subject Re: [firebird-support] Database Errors: "Too many files open"
Author Eugene Lidede (Firebird)
Hello Milan

Thanx for your reply.

We had a look at the said parameters with the admin and he changed them.

However the problem still persists. Interestingly, the 'Too many files
open' error is limited to firebird. There are numerous virtual hosts
running
in use shared hosting environment and there are numerous file opening and
closing sessions which conclude ok only firebird returns 'Too many files
open'.

For example i created 1000 files on the server wrote 1024 bytes in each and
closed the files. all went very ok

--
Regards
Eugene,


On Mon, 14 Jan 2008 17:43:25 +0300, Milan Babuskov <milanb@...>
wrote:

> Milan Babuskov wrote:
>>> I/O error for file "<DB_FILENAME>" Error while trying to open file
>>> Too many open files
>> 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
>
> I forgot, there are some other limits too. Check these values:
>
> cat /proc/sys/fs/file-max
> sysctl fs.file-max
>
> To increase that you can use the sysctl command.
>
> There is also per-user limit on some systems, so better check:
>
> /etc/security/limits.conf
> /etc/limits
>
> if they exist on your system.
>