Kbase 20340: Database shuts down with error 3821 in the log file.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
SYMPTOM(s):
Database shuts down with errors in the log file.
dpend: sdpend: dbkey: (3817)
dpend: sdpend dbkey: (3818)
rlwritten: , rldepend: (3819)
SYSTEM ERROR: rlputmod: wrong dpend (3821)
Database starts up again no problems
CAUSE:
The bi file log dependency 32-bit counter is kept in shared memory. It is a signed long value. When it overflows (after writing 2-gigs worth bi notes) the database will shut down because of a sanity check to insure that the filled bi buffers are written in order. It does not indicate corruption, these actions are taken to ensure integrity.
FIX:
Upgrade the server license. These counters were made 64-bit in Progress 8.3E, 9.1D09 and 9.1E.
Progress versions before this are 32-bit counters, so an overflow at 2billions is expected. If an upgrade is not feasable, shedule a shut down of the database periodically to clear the bi file log counter. You can keep a check on the value by collecting stats with the following 4GL program using VSTs:
output to "bilog.log" append.
find first _ActBILog.
display today string(time, "HH:MM") format "x(5)"
_BiLog-RecWriten format "z,zzz,zzz,zz9-" with no-labels no-box
output close.