Kbase P42330: [JDBC Progress Driver]:Lock table is full. (7870) executing
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/25/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
=== SQL Exception 1
=== SQLState=HY000 ErrorCode=-210016
[JDBC Progress Driver]:Lock table is full. (7870)
Executing the SQL-92 statement:
DELETE FROM PUB.Customer;
Generates the error.
CAUSE:
The table has more records than 8192; the default number of the Lock Table Entries (-L).
FIX:
Either
1. Set the -L server Startup Parameter to a number higher than the total number of records expected to be locked during the transaction. For example:
proserve databasename -L 50000 -S portnumber -H hostname.
OR
2. Set the Transaction Isolation Level to "serializable". For example:
@TransactionIsolation Serializable;