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