At 03:27 PM 10/27/2004, olivier_lucaes wrote:

>I got a message "look of manager out of room" and "deadlock" the
>first day. After some investigations, it seems that this message
>occurs when the firebird server runs out of memory for its locking
>management (parameter LOCK_MEM_SIZE in firebird.conf not changes
>from its default value). Is this the right direction ?

Yes. Double that parameter value - and remember to remove the "#"
comment indicator. If that doesn't work, double it again and increase
the hash slots from 499 to 991 - you might do that anyway.

>If yes, could it be due to some transactions not commited ?

Possibly, though you would see other symptoms, like very low
through put as many requests wait for others. I wouldn't worry
about your application until after you've given the lock table
space to work.


Regards,


Ann