Subject Re: look of manager out of room
Author olivier_lucaes
Thanks a lot Ann.
As recomended, i will first increase these parameters and check the
result.
best regards
Olivier

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:
> 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