Kbase P22896: Database Server starts with (1093) message
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/1/2009 |
|
Status: Verified
SYMPTOM(s):
Warning: Setting -n to a new value of <num> (9509)
Warning: only <num> wait semaphores are available. (1093)
Errors 6500 and 6501 trying to connect or shutdown the database
stVacate of invalid memory. (6500)
SYSTEM ERROR: pstpool=0x401ae194 pdsmStoragePool=0x8194800 phdr=0x401f957e abkoffst=0 magic=0. (6501)
SYSTEM ERROR: pstpool= pdsmStoragePool= phdr= abkoffst= magic=. (6501)
** Save file named core for analysis by Progress Software Corporation. (439)
Stack trace from _mprshut reads:
msgnCB
msgCB
dsmFatalMsgnCallBack
stVacate
fillstr
Database log file shows warnings 1093 with negative -n value
Warning: Setting -n to a new value of -3851 (9509)
Warning: only 250 wait semaphores are available. (1093)
Progress 9.1D07
Progress 9.1D08
FACT(s) (Environment):
SCO OpenServer
Linux Intel
CAUSE:
Number of wait semaphores available on a system are exceeded by the requirements of -n
FIX:
Lower the -n value or regenerate the kernel and increase the SEMMNS and SEMMSL parameters that define semaphore maxes on the system as follows
Tune 2 kernel parameters:
SEMMNS (max. semaphores per semaphore id) and
SEMMSL (total semaphores in the system)
to double their current values initially:
/etc/conf/bin/idtune SEMMNS 120
/etc/conf/bin/idtune SEMMSL 300
(then verify these in stune)
Then rebuild the kernel:
/etc/conf/bin/idbuild -B
and REBOOT the live server to make the new settings take effect.
(You will need root access to perform these tasks)