Kbase 18815: 2329 Error with AI & 2Phase Commit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
Error running 2Phase commit & After Imaging (ai)
SYSTEM ERROR: Invalid block <block> for file <file-name>, max is <max-block> (2329)
CAUSE:
Bug 19971014-016.
This indicates that an attempt has been made to read a block beyond the end of the database, Before Image (bi) or ai file.
This will cause the ai files to be unable to roll forward to the backup database because of corruption in the Transaction Log (tl) file, the transaction log file for 2phase commit.
FIX:
To correct this error, shut down the database, and try to recover any limbo transactions. To do this, run the command:
proutil dbname -C 2phase recover.
Truncate the transaction log file by running:
proutil dbname -C 2phase new.
Start the database and the corruption should be gone.