Kbase P3486: Error 865 during database crash recovery.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/11/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
Error 865 during database crash recovery.
SYSTEM ERROR: rlrdprv: There are no more notes to be read. (865)
BI file reached 2 GB
CAUSE:
This message indicates that the end of the BI file was reached before the backout of an active transaction was completed. Transaction backouts are accomplished by reading the BI file. The message reports that the beginning of the BI file was reached before the transaction begin note for that transaction was encountered, thus the transaction could not be backed out. This means that the database is still marked as crashed and thus a crash recovery will be performed which will again lead to error 865. It is an eternal loop, therefor there are only 2 possible options as stated in the Fix.
FIX:
1. Go to backup (recommended, preferred).
2. As a last resort (if no backup whatsoever is available):
proutil <dbname> -C truncate bi -F
Dump and load.
Please note that -F bypasses crash recovery, therefore your database integrity will be at stake. Please see Solution P24330 Consequences of using the -F startup option for further details.