InterBase: 'lock manager out of room'

Databases
InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)

InterBase: 'lock manager out of room'

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:
My application that runs against InterBase 5 throws an exception 'sql code -104, lock manager out of room'. How can I increase the lock space?

Answer:
Go to the interbase/bin directory (Windows) or /usr/interbase (Unix) and locate the configuration file isc_config. By default your configuration file will look like this:

#V4_LOCK_MEM_SIZE       98304
#ANY_LOCK_MEM_SIZE      98304
#V4_LOCK_SEM_COUNT      32
#ANY_LOCK_SEM_COUNT     32
#V4_LOCK_SIGNAL         16
#ANY_LOCK_SIGNAL        16
#V4_EVENT_MEM_SIZE      32768
#ANY_EVENT_MEM_SIZE     32768

I increased the V4_LOCK_MEM_SIZE entry from 98304 to 198304 and things were fine then.

!!! Important: !!!

By default all lines in the config file are commented out with the leading # sign. Make sure to remove the # sign in any line that you change - the default config file just shows the default parameters.

Send a message to
Subject

Comments:

2008-10-23, 13:45:21

anonymous from Brazil

'congratulations'
marceloalcenio

NEW: Optional: Register Login Email address (not necessary): Rate as	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option, or post under a registered account.

	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material. Add a picture:


	Search: