Kbase 32988: Error: Failure getting record lock on a record from table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P2988
FACT(s) (Environment):
Progress 9.1C
RedHat Linux 6.2
SYMPTOM(s):
Error: Failure getting record lock on a record from table <table>
DataDirect ODBC Driver 3.6
MERANT ODBC Driver 3.6
From SQL-92 client using READ COMMITTED Transaction Isolation Level, cannot read record locked by another user
The error does appear in the ODBC trace (SQL.LOG)
An empty result set is returned
CAUSE:
The record is locked in EXCLUSIVE-LOCK by another user.
From a third-party product, such as Visual Basic or PHP, the error message is not shown.
FIX:
Use READ UNCOMMITTED Transaction Isolation Level instead.