community.borland.com

Article #25156: Error Message: statement failed sql code -104, lock manager out of room

Problem:
Running out of shared memory due to not enough shared memory 
allocated in the isc_config file

Solution:
Example:  (default)
	
		#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

	In the case that I generated this document from the customer thought
	that they allocated more shared memory but in fact they had not.  
	They made the following changes in the isc_config file.
	
		#V4_LOCK_MEM_SIZE        196608

	A minor but significant problem.  He did not uncomment the entry, thus
	InterBase is still using the default settings.  Once he removed the '#'
	the error disappeared.  I caused another error to occur, which I have 
	written another document for fixing it.
	
	see: statement failed -902 operating system directive semget failed.

Last Modified: 27-OCT-00