5.0.14 - freechain?

[Jose Lerebours]

A couple of things come to mind:

1. While the application is old, the causing code may have been recently 
introduced
2. Make sure you are not changing real fields within automatic process 
(specially fields auto indexes are based on)
3. Possibly a file you are writing to or deleting from has a lot of 
"deleted" records or writing/deleting record that is not locked
4. Deleting a record from file with a lot of automatic indexes
5. Your table has reached a size that the freechain message is now 
visible where before, it happened so fast it was not a concern thus the 
root cause may be there for a while ...

if you have a table with a lot deleted records (blank in key file), it 
is best to purge the delete records but not sure if a good idea if you 
use @rn to manage tables relationship.

I have not seen this message in such a long time that I do not recall if 
it shows the file name for which the chain is being rebuilt; this is 
relevant since you can be altering any number of records in any number 
of tables at any given time ... specially if you running a loop or 
recursive type routine.


On 9/30/20 9:11 AM, Fairlight via Filepro-list wrote:
> We've started seeing the freechain command popping up in atop and top
> for a specific filePro file.  It runs at 100% of a CPU core worth of
> usage for multiple seconds, then exits.  It's doing this regularly.
>
> What is likely causing it to run, and how do we rectify whatever is
> going on?  We've not really seen this before a day ago, and we have been
> monitoring this system for ages.
>
> Thanks!
>
> mark->