Kbase P2988: SQL: Error: Failure getting record lock on a record from table executing UPDATE statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/4/2011 |
|
Status: Verified
SYMPTOM(s):
SQL: Error: Failure getting record lock on a record from table executing UPDATE statement
Error: Failure getting record lock on a record from table <table>
Error: Failure getting record lock on a record from table Customer
From SQL-92 client using READ COMMITTED Transaction Isolation Level, cannot read record locked by another user
FACT(s) (Environment):
The error does appear in the ODBC trace (SQL.LOG)
An empty result set is returned
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The record is locked in SHARE or EXCLUSIVE LOCK by another SQL or 4GL/ABL Client.
FIX:
If the intention is to simply read and NOT to UPDATE the result set, then use READ UNCOMMITTED Transaction Isolation Level.
If the intention is to to UPDATE the result set, then wait till the other client holding the records with SHARE or EXCLUSIVE LOCK release those records.
If the client holding the records with SHARE or EXCLUSIVE LOCK does not need to UPDATE the records, modify the code used by that client to prevent it from unnecessarily holding the records with SHARE or EXCLUSIVE LOCK.