Kbase P126826: What are Purge Locks?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/02/2009 |
|
Status: Verified
GOAL:
What are Purge Locks within the Database Engine?
GOAL:
How are Purge Locks created?
GOAL:
What is the purpose of a Purge Lock?
GOAL:
Can Purge Locks cause conflcits within the database?
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.x
All Supported Operating Systems
All Supported Operating Systems
FIX:
When a record delete occurs and the transaction is rolled back, purge locks come into play. An IX (intent to get exclusive) table lock is acquired on the table containing the no-longer-to-be-deleted record. The exclusive lock on the no-longer-to-be-deleted record becomes a purge lock and is moved to a purge chain. Usually, the ABL will issue an explicit lock release request which allows the database engine to release the lock at transaction end. If no explicit lock release request is received, the lock will remain on the purge chain and will be removed when the user disconnects from the database. Locks on the purge chain do not cause lock conflicts.