Kbase P42630: Remote user disconnects during lengthy transaction leaving entries in _connect and _lock tables.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/14/2009 |
|
Status: Verified
SYMPTOM(s):
Remote user terminated abnormally during large transaction.
User does not show up in promon shutdown menu.
User shows up in the user list.
User still active in _connect table.
User has record locks in _lock table.
Lock table entries increasing rapidly.
User disconnect recorded in database log file.
HANGUP signal received. (562)
Begin transaction backout. (2252)
No 2253 message indicating transaction backout completed.
FACT(s) (Environment):
UNIX
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
The remote server process is attempting to backout the transaction the remote user had started. Depending on the size and complexity of the transaction, this process may take a while.
FIX:
Give the transaction backout more time to complete. Once the 2253 message appears in the log file, the user should be removed from the _connect table and their locks removed.