Kbase P853: Database startup fails with: Semaphore limit exceeded (1131)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/12/2008 |
|
Status: Verified
SYMPTOM(s):
Receiving 1131 error when starting a database from command line.
Semaphore limit exceeded (1131)
FACT(s) (Environment):
Other databases are running on the machine without receiving these errors.
1131 error occurs with default database startup parameters.
Progress/OpenEdge Product Family
UNIX
CAUSE:
Progress is hitting one of the semaphore related limits in the UNIX kernel, SEMMNI.
FIX:
The maximum number of semaphore identifiers allowed system wide must be increased in the UNIX kernel.
Progress needs 2 semaphores per active database, the total number required is dependent on the number of concurrent users (add 1 semaphore per 50 users), Before Image Buffers (add 1 semaphore per 400 -B), number of active databases on the system, the number of semaphore the OS uses (kernel, daemons etc.) and the number any 3rd party applications / services / daemons etc. may be using.
The semaphore usage is presented per our guidelines. Manual tuning of these parameters may be necessary. Recommend testing and monitoring in order to identify the optimal value for the effected system.