Kbase 19705: System Error 822 What to do?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
SYSTEM ERROR: rmdoins 1: pbk->free went negative dbkey (822)
Error when restarting a crashed database.
CAUSE:
There is probably before-image (BI) file corruption or the BI file has reached the 2GB size limit.
FIX:
Look at the database log file. If you see the entry:
SYSTEM ERROR: rlbinext: past end of cluster -2147483648 (3829)
then the BI file has reached the 2Gb limit. In that case, Progress recommends restoring from backup to protect database integrity.
If a restore is not possible, you can force a truncation of the BI file with the command:
Proutil db-name -C truncate bi -F
The "-F" is the force option.
Please note that if you forcibly truncate the BI files, you work around the error message but crash recovery will be skipped, so you will have some data inconsistency. The database will be marked as damaged. Dump and load the database at the next convenient time.