Kbase P132352: Database Hang situation can occur when a db latch contention issue occurs at the same time as a proc
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/26/2008 |
|
Status: Verified
SYMPTOM(s):
Database Hang situation can occur when a db latch contention issue occurs at the same time as a process terminating with a kill signal
All database activity has stopped
Users are unable to log into the database.
Database appears to be hung.
promon lock activity screen shows a couple of exclusive locks
promon lock activity screen shows 20 or more processes holding a share lock on the _Db Table (-6).
Database log file (dbname.lg) shows a user terminating their session with a kill signal around the time of the database hang.
FACT(s) (Environment):
There are record fragmentation on the database
All Supported Operating Systems
Progress/OpenEdge Versions
OpenEdge Database Category: Performance
CAUSE:
Bug# OE00166773
CAUSE:
Database latches being held and not released
FIX:
Upgrade to 10.1C01.
If your site is unable to upgrade to 10.1C01, please upgrade to 10.1B03 and contact Progress Technical Support for additional assistance.