Filepro-list Digest, Vol 200, Issue 34

Thu Oct 1 16:58:46 PDT 2020

Sllw32 at gmail.com has passed away.  Please remove him from your mailing list.

 |-----Original Message-----
 |From: Filepro-list On Behalf Of filepro-list-request at lists.celestial.com
 |Sent: Thursday, October 1, 2020 12:37 AM
 |To: filepro-list at lists.celestial.com
 |Subject: Filepro-list Digest, Vol 200, Issue 34
 |
 |Send Filepro-list mailing list submissions to
 |	filepro-list at lists.celestial.com
 |
 |To subscribe or unsubscribe via the World Wide Web, visit
 |	http://mailman.celestial.com/mailman/listinfo/filepro-list
 |or, via email, send a message with subject or body 'help' to
 |	filepro-list-request at lists.celestial.com
 |
 |You can reach the person managing the list at
 |	filepro-list-owner at lists.celestial.com
 |
 |When replying, please edit your Subject line so it is more specific
 |than "Re: Contents of Filepro-list digest..."
 |
 |
 |Today's Topics:
 |
 |   1. 5.0.14 - freechain? (Fairlight)
 |   2. Re: 5.0.14 - freechain? (Jose Lerebours)
 |   3. RE: 5.0.14 - freechain? (Walter Vaughan Jr)
 |   4. RE: 5.0.14 - freechain? (Richard Kreiss)
 |   5. Re: 5.0.14 - freechain? (Jay R. Ashworth)
 |
 |
 |----------------------------------------------------------------------
 |
 |Message: 1
 |Date: Wed, 30 Sep 2020 09:11:41 -0400
 |From: Fairlight <fairlite at fairlite.com>
 |To: filepro-list at lists.celestial.com
 |Subject: 5.0.14 - freechain?
 |Message-ID: <20200930131141.GL850699 at fairlite.com>
 |Content-Type: text/plain; charset=us-ascii
 |
 |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->
 |--
 |Fairlight Consulting
 |http://www.fairlite.com
 |fairlite at fairlite.com
 |(502) 509-3840
 |
 |
 |------------------------------
 |
 |Message: 2
 |Date: Wed, 30 Sep 2020 09:49:33 -0400
 |From: Jose Lerebours <fpgroups at gmail.com>
 |To: filepro-list at lists.celestial.com
 |Subject: Re: 5.0.14 - freechain?
 |Message-ID: <20463566-db99-46a2-c4b6-a45145b386f3 at gmail.com>
 |Content-Type: text/plain; charset=utf-8; format=flowed
 |
 |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->
 |
 |
 |------------------------------
 |
 |Message: 3
 |Date: Wed, 30 Sep 2020 18:59:30 +0000
 |From: Walter Vaughan Jr <wvaughan at steelerubber.com>
 |To: "filepro-list at lists.celestial.com"
 |	<filepro-list at lists.celestial.com>
 |Subject: RE: 5.0.14 - freechain?
 |Message-ID:
 |	<BN6PR16MB3377F720BA28975469A42C2ABE330 at BN6PR16MB3377.
 |namprd16.prod.outlook.com>
 |
 |Content-Type: text/plain; charset="us-ascii"
 |
 |I used to blame it on solar activity back in the day, because there was no
 |reason other it did seem to happen more often when there was known
 |issues with sunspot levels.
 |
 |IIRC what you are seeing is the correct behavior, however when it hangs
 |when running in the background, *that* is the interesting bit.  Everyone
out
 |of the system and a manual run of freechain with full backups and a way to
 |fix broken key/data offset points. Don't miss those days.
 |
 |I see that we are in a solar activity lull so my wives tale is of no use
 |https://spaceweatherarchive.com/2019/04/10/experts-predict-the-solar-
 |cycle/
 |
 |-----Original Message-----
 |From: Filepro-list <filepro-list-
 |bounces+wvaughan=steelerubber.com at lists.celestial.com> On Behalf Of
 |Fairlight via Filepro-list
 |Sent: Wednesday, September 30, 2020 9:12 AM
 |To: filepro-list at lists.celestial.com
 |Subject: 5.0.14 - freechain?
 |
 |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->
 |--
 |Fairlight Consulting
 |http://www.fairlite.com
 |fairlite at fairlite.com
 |(502) 509-3840
 |_______________________________________________
 |Filepro-list mailing list
 |Filepro-list at lists.celestial.com
 |Subscribe/Unsubscribe/Subscription Changes
 |http://mailman.celestial.com/mailman/listinfo/filepro-list
 |
 |
 |------------------------------
 |
 |Message: 4
 |Date: Wed, 30 Sep 2020 19:26:54 +0000
 |From: Richard Kreiss <rkreiss at gccconsulting.net>
 |To: Walter Vaughan Jr <wvaughan at steelerubber.com>,
 |	"'filepro-list at lists.celestial.com'"
 |	<filepro-list at lists.celestial.com>
 |Subject: RE: 5.0.14 - freechain?
 |Message-ID:
 |	<MN2PR04MB676756098C211A49090FD503B7330 at MN2PR04MB6767
 |.namprd04.prod.outlook.com>
 |
 |Content-Type: text/plain; charset="us-ascii"
 |
 |Since this most likely is a *nix system, I would suggest looking at the
 |hardware side of the issue.
 |
 |I have a client where a free chain rebuild on one file is set off on one
 |computer(windows system) each time(at least once a month).  Did a rebuild
 |yesterday and about a month ago on this file.
 |
 |So, is the issue happening on the same machine each time or is it random?
I
 |use the term machine as I do not know of this a terminal or a computer
 |running a terminal emulator.
 |
 |
 |Richard Kreiss
 |GCC Consulting
 |
 |
 |
 |> -----Original Message-----
 |> From: Filepro-list <filepro-list-
 |bounces+rkreiss=verizon.net at lists.celestial.com>
 |> On Behalf Of Walter Vaughan Jr via Filepro-list
 |> Sent: Wednesday, September 30, 2020 3:00 PM
 |> To: filepro-list at lists.celestial.com
 |> Subject: RE: 5.0.14 - freechain?
 |>
 |> I used to blame it on solar activity back in the day, because there was
no
 |reason
 |> other it did seem to happen more often when there was known issues
 |with
 |> sunspot levels.
 |>
 |> IIRC what you are seeing is the correct behavior, however when it hangs
 |when
 |> running in the background, *that* is the interesting bit.  Everyone out
of
 |the
 |> system and a manual run of freechain with full backups and a way to fix
 |broken
 |> key/data offset points. Don't miss those days.
 |>
 |> I see that we are in a solar activity lull so my wives tale is of no use
 |> https://spaceweatherarchive.com/2019/04/10/experts-predict-the-solar-
 |cycle/
 |>
 |> -----Original Message-----
 |> From: Filepro-list <filepro-list-
 |> bounces+wvaughan=steelerubber.com at lists.celestial.com> On Behalf Of
 |> Fairlight via Filepro-list
 |> Sent: Wednesday, September 30, 2020 9:12 AM
 |> To: filepro-list at lists.celestial.com
 |> Subject: 5.0.14 - freechain?
 |>
 |> 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->
 |> --
 |> Fairlight Consulting
 |> http://www.fairlite.com
 |> fairlite at fairlite.com
 |> (502) 509-3840
 |> _______________________________________________
 |> Filepro-list mailing list
 |> Filepro-list at lists.celestial.com
 |> Subscribe/Unsubscribe/Subscription Changes
 |> http://mailman.celestial.com/mailman/listinfo/filepro-list
 |> _______________________________________________
 |> Filepro-list mailing list
 |> Filepro-list at lists.celestial.com
 |> Subscribe/Unsubscribe/Subscription Changes
 |> http://mailman.celestial.com/mailman/listinfo/filepro-list
 |-------------- next part --------------
 |A non-text attachment was scrubbed...
 |Name: winmail.dat
 |Type: application/ms-tnef
 |Size: 12432 bytes
 |Desc: not available
 |URL: <http://mailman.celestial.com/pipermail/filepro-
 |list/attachments/20200930/97919f9d/attachment.bin>
 |
 |
 |------------------------------
 |
 |Message: 5
 |Date: Thu, 1 Oct 2020 04:32:02 +0000 (UTC)
 |From: "Jay R. Ashworth" <jra at baylink.com>
 |To: Filepro 2 List <filepro-list at lists.celestial.com>
 |Subject: Re: 5.0.14 - freechain?
 |Message-ID:
 |	<1893647065.7005.1601526722201.JavaMail.zimbra at baylink.com>
 |Content-Type: text/plain; charset=utf-8
 |
 |----- Original Message -----
 |> From: "Fairlight via Filepro-list" <filepro-list at lists.celestial.com>
 |
 |> 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.
 |
 |What's the parent process, and can you see commandline switches?
 |
 |Cheers,
 |-- jra
 |--
 |Jay R. Ashworth                  Baylink
jra at baylink.com
 |Designer                     The Things I Think                       RFC
2100
 |Ashworth & Associates       http://www.bcp38.info          2000 Land Rover
DII
 |St Petersburg FL USA      BCP38: Ask For It By Name!           +1 727 647
1274
 |
 |
 |------------------------------
 |
 |Subject: Digest Footer
 |
 |_______________________________________________
 |Filepro-list mailing list
 |Filepro-list at lists.celestial.com
 |http://mailman.celestial.com/mailman/listinfo/filepro-list
 |
 |
 |------------------------------
 |
 |End of Filepro-list Digest, Vol 200, Issue 34
 |*********************************************

-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus