Kbase P42870: Webspeed agents get into BUSY state after upgrade to SMP XEON
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/25/2007 |
|
Status: Verified
FACT(s) (Environment):
Linux Intel
Windows
SYMPTOM(s):
WebSpeed agents get into BUSY state
The server is an SMP machine
Using Intel XEON processors
Workgroup database license
The database is on the same server as webspeed transaction server
Application works fine when machine being booted without SMP support
CHANGE:
Installed application on a SMP XEON box
CAUSE:
This is due to the usage of semaphores in a multi-cpu environment. There is a known issue on Linux intel platforms with SMP | NUMA processors (specifically but not exclusively XEON processors) and applications using semaphores. (ie Progress Workgroup databases) Below is a technical discussion as preserved from our investigations with the RedHat vendor, the same applies for SuSe (and Windows) This is not a Progress isssue, it's a limitation of the recent Linux OS distributions.
FIX:
Upgrade to Enterprise Database license and use the -spin database startup parameter (to engage spin locks) with value 32000 or higher when starting database.
The -spin 32000 is a ballpark figure for machines with 4 physical CPU (and more), should you have 2 physical CPU's you might want to start with -spin 16000.
Alternatively, reboot the machine as single processor machine, using no SMP kernel when your OS is Linux or with /onecpu option when your OS is Windows