Kbase P9237: Database starts with an incorrect value for -n and proserve
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/29/2004 |
|
Status: Verified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
You have attempted to connect to a database with too many users connected to it. Retry the connection later, or increase -n on the server. (5291)
Database starts with an incorrect value for -n
The -n value written to the database log file does not equal the -n that was specified when starting the database.
Maximum Number of Users (-n): . (4260)
proserve shows error 1093
Warning: only <num> wait semaphores are available. (1093)
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 Progress Solution P4741. Particularly: SEMMNS (max. semaphores per semaphore id), SEMMSL (total semaphores in the system) 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.