Kbase P3786: Errors 5140 and 915 appearing together in the database log f
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/04/2003 |
|
Solution ID: P3786
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
Errors 5140 in the database log file
SYSTEM ERROR: cxdlc: user <user number> freeing a released cursor (5140)
Error 5140 is preceded by error 915
Lock table overflow, increase -L on server (915)
Errors 915 and 5140 refer to same user or server
CAUSE:
The -L option lets you set a locking table entry. Each record that is share-locked or exclusive-locked by any user takes one entry. The multi-user default for -L is 500, and is limited by available memory and shared memory kernel settings.
The 5140 error message is sometimes displayed due to too small -L parameter and it seems that if the current -L value is increased, it often solves this problem.
Error 5140 means that Progress found that a request to free a cursor is for an already freed cursor. This behavior has been changed in Progress Version 9, where it ignores the condition rather than notifying the user of an error condition they cannot influence.
In this particular situation the error 5140 doesn't seem to be critical.
FIX:
Increase -L.
A simple test can be done with -L 10000 just as a test, then decrease this figure step by step to find the optimal value, possibly after looking into promon, option 6 "Shared ressource" and then the "Locking table high water mark" field, after significant production time.