--- In ib-support@y..., Paul Reeves <paul@f...> wrote:

> Filippo wrote:
>
>
> >
> > V4_LOCK_MEM_SIZE 196068
> > ANY_LOCK_MEM_SIZE 98304
>
>
> The V4_LOCK_MEM_SIZE value only applies to Version 4. You need to set
> ANY_LOCK_MEM_SIZE to a value greater than the default.

Done, but I still have the error message...

>
> I'm not familiar with RH 8, but I must confess that I have never had a
> problem with the lock manager being out of room. How many users are
> attached to the database when this happens? I would suspect that there
> is something about your application that is causing a lot of (possibly
> unnecessary) locking.

No user is connected to the database, since I get this error message
during database compilation. Now I try to explain how I get this error.
My database is (I think) a complex database, with about 400 tables,
some of them with 400 or more fields.
I have one sql script that creates this database, and this works fine.
A second sql script adds generators, procedures and triggers to this
database. I'm talking of (at the moment) 1358 procedures, 348
triggers, 363 generators.
This script works fine with the Win32 Firebird server, but with Linux
Firebird (SS edition) causes the "Out of lock..." error.
I always had this problem, with all Linux distribution I tested. The
fact that my database works fine under Win32 and doesn't work under
Linux makes me think that a default installation of Firebird under
these OSes has not the same "capabilities", so I must do an additional
"tuning" on Linux. But I'm not a Linux expert (I'm a real newbie) and
I find difficult to make Firebird work... and this is (in my opinion)
something that Fierbird development team shoul take in consideration.

Thanks for the patience