DelphiFAQ Home Search:
General :: Databases :: InterBase
Help with InterBase, Borland's open source database.


This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

InterBase: 'lock manager out of room'

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?

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
 #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.

Generated 4:00:26 on Aug 5, 2020