Mega Code Archive

 

Categories / Delphi / Examples

 

Interbase lock manager out of room

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.