Hello All,

Thanx for your continued help.

We do not use external tables at all and there are no symlinks that i know
of, and we are running the system on linux not windows.

Am awaiting the admin to come online so that we can try the new
suggestions.

Yes actually i find it odd too that its only firebird that is affected by
the too many files open thing. As i said before we do not use external
tables or symlinks to any databases. Databases are mapped in aliases.conf
and the scripts access them using the symbolic names contained in
aliases.conf

All databases are held in a folder that is owned and writable by the user
"firebird" and the firebird server process runs under the said "firebird"
user account. I hope this info sheds some new light on our environment

Again thank you for your help

--
regards
Eugene

On Thu, 17 Jan 2008 13:08:09 +0300, Milan Babuskov <milanb@...>
wrote:

> Michael Weissenbacher wrote:
>>> We had a look at the said parameters with the admin and he changed
>>> them.
>> these are the parameters that i entered in my /etc/security/limits.conf:
>> * soft nofile 100000
>> * hard nofile 200000
>>
>> Interestingly, using "firebird" (the user firebird runs as) instead of
>> "*"
>> didn't work. Check if it works correctly by issuing ulimit. You need to
>> relogin
>> and restart firebird for the change to be applied.
>>
>> # ulimit -a
>
> I completely forgot about that. Issuing 'ulimit' only works for the
> current user login, just like altering groups user belongs to for
> example. I just tried opening two terminals as the same user and
> modifying some settings - even new logins were unaffected.
>
> One thing I don't understand though. You say only Firebird is affected,
> but Firebird shouldn't be opening many files. When the error happens and
> you run 'lsof', how many files does firebird have opened?
>
> Another idea: Is it possible that you have some database or external
> table that is actually a symlink?
>

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/