Kbase P91267: Database hung while Users wait to acquire TXE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/12/2004 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Database hung
Promon database activity shows no activity
Promon, R&D, Processes, Blocked Clients, shows many clients waiting on TXE's
There are no open transactions
Process ID of user with the earliest start time is owned by the init
-Spin parameter is set on the system.
CAUSE:
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 mutliple cpu's.
FIX:
Turn spin off by setting it to 0.
i.e.
-spin=0