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

Articles:

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'

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.

Generated 16:00:36 on Oct 16, 2019