Kbase P96734: Database hangs when a 4GL program using _lock locks up.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/12/2010 |
|
Status: Verified
SYMPTOM(s):
A 4GL program querying the _Lock VST table hangs.
Database hangs and all users freeze.
Stack trace from _progres on Solaris reads:
poll
select
select
latSleep
latlkmux
vstLockFetch
rmFetchVirtual
FACT(s) (Environment):
UNIX
Progress 9.x
OpenEdge 10.x
CAUSE:
Under specific conditions, if a client hangs while reading the _Lock VST table, the whole database may hang.
CAUSE:
Bug# OE00111869
FIX:
It may be worthwhile to use a more efficient table called _Userlock. It's result set is much smaller because it limits the number of locks per user instead of a scan of the entire lock table.