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?

--
Milan Babuskov
http://www.flamerobin.org