Kbase P60768: Undo transaction leaves records locked if it was a change to an empty field that is a component in a
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/25/2008 |
|
Status: Verified
SYMPTOM(s):
Undo transaction leaves records locked if it was a change to a empty field that is an component in a word index.
Undoing a block from within a transaction removes the Limbo lock flag from _Lock._Lock-Flags field. When the transaction ends the Exclusive lock is down graded to a share lock and this is left even after the procedure completes
The following code ilustrates this issue:
DO TRANSACTION:
SubTrans:
DO ON ERROR UNDO, LEAVE:
FIND FIRST Customer EXCLUSIVE-LOCK.
ASSIGN Customer.Comments = "ABC".
RELEASE Customer.
UNDO SubTrans, LEAVE SubTrans.
END.
END.
Share-lock is not released until the Progress session has ended
FACT(s) (Environment):
A change to a field that is a component in a non-word index will result in the lock being released.
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.0A
OpenEdge Category: Language (4GL/ABL)
CAUSE:
Bug# OE00099534
FIX:
Upgrade to OpenEdge 10.0B or later.