Kbase P8878: Damaged indexes as a result of errors 129 and/or 2696
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/16/2008 |
|
Status: Verified
SYMPTOM(s):
The following errors can occur when updating or deleting a record:
SYSTEM ERROR: proixdel failed for word indexing of array (2699)
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
IDXBUILD and IDXFIX temporarily fixes the issue.
Dumping and loading table temporarily fixes the issue.
One or more of the following errors have occurred in the environment before damaged indexes are detected:
The total length of the fields in an index exceeds max key size. (129)
Stash area exceeded maximum size. (2696)
FACT(s) (Environment):
Database was NOT forced with the -F option.
No duplicate indexes or word indexes
Progress 9.1C
Progress 9.1D
All Supported Operating Systems
CAUSE:
Bug# OE00061080
CAUSE:
Due to the bug, transactions are not backed out properly after the maximum key size of index overflowed (as indicated by errors 129 and 2696).
As a result, the data and the affected indexes are out of sync, which will result in the 1422 and 2699 error messages when trying to modify or delete the records.
FIX:
Upgrade to 9.1D05 or later.