Kbase P1106: System Error 874 caused by unfinished checkpoint process
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/09/2004 |
|
Status: Unverified
SYMPTOM(s):
Database crashed
Crash recovery fails with error
User perfers not to restore from Backup.
Truncate database bi file cannot be done.
SYSTEM ERROR: Two clusters in the .bi file have the same rlcounter. (874)
CAUSE:
When a BI cluster is filled, Progress performs a checkpoint operation in which it reconciles the memory-resident database with the disk-resident database.
Crash recovery is a two-phase process, during the phase 1, Progress reads the last two clusters to REDO transactions with end notes.
When a database crash occurs if the bi was performing a checkpoint it could happen that some internal values, as rlcounter are not updated yet.
When the crash recovery is performed, it could find this inconsistency and the error (874) appears.
FIX:
Force the entrance of the database using proutil db-name -C truncate bi -F, ignoring the current before image file and skipping the crash recover process.