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