Kbase 20900: SQL-92: Error 7870 when deleting or updating records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/10/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error 7870 when deleting or updating records
Using JDBC or ODBC connection
[JDBC Progress Driver]:Lock table is full. (7870)
The error occurs with "committed read" and "repeatable read" transaction isolation levels.
CAUSE:
There are 3 levels of locks: record, table and schema.
For default isolation level, read uncommited, the lock is at record level, if the table is large, the lock table is exhausted
FIX:
Set the Transaction Isolation Level to "Serializable".