Kbase P14494: Error 5022 after disconnecting abruptly a user
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/10/2004 |
|
Status: Unverified
SYMPTOM(s):
<CTRL> <C> sent to shared memory client processing a job.
Database abnormally shutdown.
Error 5022 after disconnecting abruptly a user
Crash recovery fails with error (5022)
SYSTEM ERROR: Ixundo failed in ixdel because it was unable to find the key to delete in index number <index number>. This Index may have an incorrect key. (5022)
CAUSE:
An attempt to back out an addition with a deletion failed. The key to be backed out could not be found in the index. This indicates index corruption.
FIX:
1. Rebuild all database indecies.
Example:
proutil -B 2000 -C idxbuild -TB 24 -TM 32
Or
2. To rebuild only the indecies for the table reported in the error.
Use the below 4GL code to determine the table name that corresponds to the index number.
FOR EACH _index WHERE _index._idx-num = : DISPLAY _index.
Example:
FOR EACH _index WHERE _index._idx-num = 9: DISPLAY _index.