Kbase P130655: 210 errors when adding records to a table due to index corruption
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/15/2010 |
|
Status: Verified
SYMPTOM(s):
Receiving a 210 error when adding records to a table.
SYSTEM ERROR: Attempt to read block <number> which does not exist. (210)
SYSTEM ERROR: Attempt to read block 0 which does not exist. (210)
Stack trace from _progres reads:
bmLocateBuffer2
cxLocateValidBlock
cxSearchTree
proutil dbname -C idxfix with option 3 fails with error 8828
Index <index number> (<owner name>.<table name>, <index name>): Deleted key <key value> recid <record identifier>. (8828)
FACT(s) (Environment):
Scan of the suspected table involved was clean using proutil dbname -C dbrpr
IBM AIX POWER 5.3
OpenEdge 10.1A02 64-bit Service Pack
CAUSE:
Corrupted index associated with the table that clients were attempting to insert records into.
FIX:
Rebuild all indexes associated with the table that failed when performing the idxfix command.