Kbase P4355: Exclusive record locks are not released after buffer scope ends.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
SYMPTOM(s):
Exclusive record locks are not released after buffer scope ends.
When buffer scope ends, a transaction is active.
CAUSE:
This is expected behavior.
FIX:
Exclusive locks cannot be released inside a transaction.
The idea behind it is that, in case of a transaction rollback, we must be able to restore the record to the status it was before the transaction started, therefore we cannot allow any other user to change it before the whole transaction is committed.