Kbase P2990: Error 7870 when performing a SELECT from a SQL-92 client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/03/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Using JDBC or ODBC connection.
Occurs when retrieving information from a Progress database.
Occurs when performing a SELECT on a Progress database.
The error occurs with "Committed Read" and "Repeatable Read" Transaction Isolation Levels.
-210016 [JDBC Progress Driver]:Lock table is full. (7870)
CAUSE:
There are 3 levels of locks: record, table and schema.
The current Transaction Isolation Level is causing a record share-lock, which consumes the available entires in the Lock Table.
The error occurs when the number of Lock Table Entries (-L database startup parameter) is exceeded, which by default is 8192.
FIX:
Set the Transaction Isolation Level to "Read Uncommitted", which connects to the database as a read-only client.
This type of connection does not consume any entires in the Lock Table.
- OR -
Set the Transaction Isolation Level to "Serializable", which locks the entire table thus only allowing 1 user to use the database.
This type of connection only takes 1 entry in the Lock Table.
- OR -
Increase the -L database startup parameter.