Kbase P77209: Error 210 after crash recovery backout
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/06/2005 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 9.1D
SYMPTOM(s):
Index corruption after crash recovery backout.
When the procedure (that re-creates many records) is abnormally terminated (simulated crash) and the broker is restarted, there is an unresolved index(es) corruption in the database.
SYSTEM ERROR: Attempt to read block <number> which does not exist. (210)
The crash recovery process (upon the broker's startup) doesn't report any problems while backing out transactions.
The problem is fixable by index rebuild.
CAUSE:
Bug# 20040419-013
FIX:
Upgrade to Progress 9.1E or later
Upgrade to Progress 10.0B or later
If the upgrade is impossible, the available workaround is to run idxbuild process after the crash. This should be taken into account within the contingency procedure for such situations.