Consultor Eletrônico



Kbase P42870: Webspeed agents get into BUSY state after upgrade to SMP XEON
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   25/04/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