[All]
Error Message: statement failed sql code -104, lock manager out of room
By: Borland Staff
Abstract: Increasing shared memory may resolve the problem
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.
Connect with Us