Mirror

InterBase: "lock manager out of room" (Views: 100)


Problem/Question/Abstract:

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.

<< Back to main page