Kbase P1105: Incomplete Checkpoint process causing SE 874
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
SYMPTOM(s):
Database crashed
When re-starting the database crash recovery fails with error
SYSTEM ERROR: Two clusters in the .bi file have the same rlcounter. (874)
CAUSE:
Corruption in the bi file. In this particular case, when the database crash occurred the bi was performing a checkpoint at the time, which reconciles the memory-resident database with the disk-resident database and some internal values, such as rlcounter were not able to complete their update.
On re-starting the database (or truncating the bi file), crash recovery is performed and during phase 1, where Progress reads the last two clusters to REDO transactions with end notes, this inconsistency is found and reported in the error (874).
FIX:
There are two options to recover from this situation:
1.) Recommended approach:
Restore the previous backup and, if after-imaging part of the recovery plan, roll forward the after image files.
2.) If going to backup is not an option, the only option left is to force into the database and skip crash recovery. This action will compromise the logical integrity of your database, please read below about the consequences/risks of taking this action.
$ proutil dbname -C truncate bi -G 0 -F