Kbase P92629: Index fix online aborted with errors 8812 and 4344
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
SYMPTOM(s):
Index fix online aborted with errors 8812 and 4344
Phase 1, processing block number <block> in area <area>. (8365)
Lock wait timeout of seconds expired (8812)
Lock wait timeout of 1800 seconds expired (8812)
Unable to get a lock for recid <record identifier>. Return code = <return code>. (4344)
Unable to get a lock for recid 48996320. Return code = -1218. (4344)
FACT(s) (Environment):
"proutil <dbname> -C idxfix" run while the database is running
All Supported Operating Systems
Progress/OpenEdge Versions
CAUSE:
idxfix waited 1800 seconds (30 minutes) for a needed lock, as per the default value for Lock Timeout
FIX:
Run idxfix at the time there is no potentially locks during "Lock Timeout" minutes on one record.
or
Modify the default Lock Timeout using -lkwtmo option.
To a value of 60 minutes for example, run:
proutil <dbname> -C idxfix -lkwtmo 3600