Kbase P5100: Error on rlrdnxt attempting to start the database after an abnormal shutdown
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/09/2008 |
|
Status: Verified
SYMPTOM(s):
Error on rlrdnxt attempting to start the database after an abnormal shutdown
rlrdnxt: note prefix and suffix lengths don't match <prefix length> <suffix length> (9383)
rlrdnxt: note prefix and suffix lengths don't match (5112)
rlrdnxt: note prefix and suffix lengths don't match . (7167)
SYSTEM ERROR: rlrdnxt: note prefix and suffix lengths don't match <prefix length> <suffix length> (5112)
Stack trace from _mprosrv reads:
rlrdnxt
dorollf
rlrollf
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B03 Service Pack
CAUSE:
All the above errors indicate non-recoverable corruption of the notes in the before image file.
Before-image notes are kept in order with transaction numbers and are used keep track of all changes to the database. When an abnormal shutdown event occurs, the before image file is used at database startup in crash recovery mode to reconcile changes recorded in the bi notes against those in the database. This is a necessary file to ensure data integrity. The corruption of the before-image file may have been caused by hardware failures, user or operating system level errors.
FIX:
If you have after-image enabled, restore your database backup and roll forward the after image files.
If for some reason going to backup is not feasible, the last resort is to force into the database and bypass crash recovery.
Forcing into a database and by-passing crash recovery is done by truncating the bi file with the -F option.
Prior to taking this action it is highly recommended that an operating system backup of the database be taken so if something should go wrong during the force, you can always get back to this point in time.
Command: proutil dbname -C truncate bi -F
The following messages will then appear:
** The FORCE option was given, database recovery will be skipped. (33)
** Your database was damaged. Dump its data and reload it. (37)
Remeber: Forcing into a database can cause logical and physical corruption of a database. This should only be used as a last resort. The database should be dumped and loaded to regain database integrity.