Kbase P58620: Error (1093) when starting database cause the -n parameter to be decreased
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/2/2008 |
|
Status: Verified
FACT(s) (Environment):
UNIX
Progress 9.x
SYMPTOM(s):
proserve of database encounters error (1093)
Warning: only <num> wait semaphores are available. (1093)
User sessions terminate with error (1093)
The -n value written to the database log file does not equal the -n that was specified when starting the database.
Database starts with an incorrect value for -n
-n parameter shows a different value in the database log file then what it was started as
CAUSE:
A low setting for SEMMNS and SEMMNU UNIX Kernel parameters will keep the database from using the total amount specified for -n, as the database server was started without enough semaphores available to accommodate the maximum number of users (-n). When not enough semaphores are available, the following message appears as the server starts:
BROKER : Warning: only <n> wait semaphores are available. (1093)
The database server is started, but there may be operational problems when the number of users approaches the number specified in the -n startup parameter.
FIX:
Tune the semaphore-related parameters in the UNIX kernel according to Solution P4741, "Calculating SEMMSL, SEMMNS and SEMMNU". Particularly: SEMMNS (Total number of semaphores allowed for the system), SEMMSL (The maximum number of semaphores allowed per semaphore identifier) and SEMMNU.
The amount of kernel memory required for semaphores is relatively small, so setting the limits higher than your current needs may not hurt.