Consultor Eletrônico



Kbase P12631: Error 651 after a crashed idxbuild.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/16/2008
Status: Verified

FACT(s) (Environment):

Progress 9.x

SYMPTOM(s):

prostrct add fails with error 651.

Index reconstruction utility was aborted. Rerun it to completion. (651)

Error 651 appears after an index rebuild crashed.

Index rebuild crashed because it ran out of disk space on one of the data extents.

CAUSE:

A crashed index rebuild leaves some internal flags in an uncertain status. As a safeguard, any access to the database is forbidden, except by a new run of the index rebuild utility.

FIX:

Progress Solution P70435, "An idxbuild SOME sometimes builds all indexes after a previous index rebuild has terminated or been cancelled." outlines a procedure to temporarily eliminate error 651. However, once that procedure is finished, all indexes in the database will be inactive, therefore it should only be used as a workaround so the "prostrct add" can be run and a full-blown index rebuild can follow.