Kbase P133138: What does transaction state DEAD mean in promon?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/10/2009 |
|
Status: Verified
GOAL:
What does transaction state DEAD mean in promon?
GOAL:
Why does promon show transaction state DEAD?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
Within promon in the Record Locking Table (option 4) a transaction may occasionally be listed with a Transaction State of dead.
When the "Tran State" is DEAD it signifies the transaction is no longer active.
The transaction id is the one that existed previously when the transaction was active but no longer does.
Effectively, It means that the transaction table entry is now free and available for resuse by a new transaction.
Example:
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags Tran State
24 usr REC 9410 19629915 121 SHR Dead 0
47 usr REC 9528 19616970 121 SHR Dead 0
35 usr REC 9528 19616970 121 SHR Dead 0
32 usr REC 9528 19616970 121 SHR Dead 0
31 usr REC 9528 19616970 121 SHR Dead 0
24 usr REC 9744 19629916 454 SHR Dead 62834
39 usr REC 9770 19630275 121 SHR Dead 0
30 usr REC 9772 19630277 121 SHR Dead
This can often occur when record locks are acquired outside of a transaction.