community.borland.com

Article #25896: Getting 'Lock Manager out of room' error

Problem:
Why am I getting this error and how can I resolve the issue.

Solution:
 As seen in the v5.x doc ( Operations Guide, pg. 95 ), there is
 a configurable setting for the /usr/interbase/isc_config
 file called 'V4_LOCK_MEM_SIZE'.  The default is 98304 bytes.

 When the server is under heavier loads (ie. more concurrent
 connections, etc.) the lock manager uses more resources to
 manage the lock table.

 When the lock manager exceeds the default memory allocated 
 as seen in ( isc_config ), it reports the 'out of room' 
 error because it is starved and needs more resources.

 Using /usr/interbase/bin/gds_lock_print -h you will get an
 output.  The first line will give you the resource usage 
 information that is important for this issue as seen below:

 LOCK_HEADER BLOCK
 Version: 114, Active owner:  0, Length:  32768, Used:  12556

 Length = default setting 
 Used = current memory being used

 To eleviate the resource issue you will need to increase 
 the default setting in the 'isc_config' file and restart
 the InterBase server.

Last Modified: 18-OCT-00