Kbase P91639: Database hangs when using -spin.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/11/2008 |
|
Status: Verified
SYMPTOM(s):
Database hangs.
Promon's Database activity screen shows no activity
Promon, R&D, Processes, Blocked Clients, shows clients waiting on TXE's
FACT(s) (Environment):
No open transactions exist on the database
The Process ID of user with the earliest start time is owned by init
-Spin parameter is set to greater then 1.
Database is running on a single CPU system.
Must use proshut <db-name> -F to shut database down.
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
This is the expected behavior the Spin parameter is to be used on a machine with multiple CPU's and should not be set higher then 1 if only 1 CPU exists.
The spin parameter activates the spin lock algorithm to control access to shared-memory structures and acquire the resource's latch and should not be used unless there are multiple CPU's.
FIX:
To turn spin off by removing it from the database startup parameter list and restart the database.