DelphiFAQ Home Search:

InterBase: 'lock manager out of room'

 

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

Comments:

2008-10-23, 13:45:21
anonymous from Brazil  
'congratulations'
marceloalcenio
2017-01-10, 14:38:25
anonymous from Indonesia  
JIKA ANDA BUTUH ANGKA TOGEL GAIB (_SGP,HKG,MLYS,SYD,THLND,TAIWAN_)
YANG DI JAMIN 100% TEMBUS SILAHKAN
Call/Sms Di No_o82_319_2o8_865_ AKI NUGROHO
Insya Allah Beliau Akan Siap Membantu Menyelesaikan Smua Masalah Anda,.
(_..KUNCI KESUKSESAN..._)
1. Pikiran Yang Positif,
2. Keyakinan Yang Bulat
3. Percaya Bahwa Kita Akan Berhasil
.

 

 

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.

photo Add a picture: