Issue with Index
Kenneth Brody
kenbrody at spamcop.net
Tue Jun 24 14:32:01 PDT 2014
On 6/23/2014 11:14 AM, James Flanagan wrote:
> FreeBSD 9.2
> Filepro 5.7.04
>
> Below is a list of automatic Index D, based solely on field 6, a 10
> character all up field. For some strange reason, the 6th column is not in
> proper order. What is more, the 4th record listed, T000000632, appears twice
> in the list (also the last listed record), but only one record for
> T000000632 exists in the key file. these records are being added to the file
> using "copy to" command between 2 lookups. the same index for the first file
> works as expected, with no issues. somehow, this index keeps getting corrupt.
>
>
> I N Q U I R E, U P D A T E, A D D 5.7.00.04D4
> ────────────────────────────────────────────────────────────────────────────────
> T000000631 06/17/2014 18:27:46 JLF james R000000013
> T000000501 06/21/2014 17:38:58 JLF james R000000014
> T000000073 06/17/2014 18:28:02 JLF james R000000013
> T000000632 06/21/2014 17:40:40 JLF james SC00000306
> T000000500 06/21/2014 17:40:40 JLF james SC00000306
[...]
> T000068581 06/23/2014 8:51:50 JLF james SC00000204
> T000068581 06/23/2014 8:51:50 JLF james SC00000204
> T000000632 06/21/2014 17:40:40 JLF james SC00000306
> ──Index─────────────────────────────────────────────────────────────────────────
[...]
> When I manually rebuild the index, the index is cleaned up and the phantom,
> out of place, duplicate records disappear.
[...]
You don't have enough information to make a definite diagnosis, but I would
start looking at the lookups themselves, and verifying that you are
protecting the ones you modify.
You might want to try PFCHECKLOCK=ON as a start.
--
Kenneth Brody
More information about the Filepro-list
mailing list