Filepro-list Digest, Vol 200, Issue 34

Fairlight fairlite at fairlite.com
Fri Oct 2 07:11:26 PDT 2020


I just unsubbed him.

m->

On Fri, Oct 02, 2020 at 01:19:31PM +0000, Walter Vaughan Jr via Filepro-list thus spoke:
> I did put his email in the unsubscribe box and submitted it. However someone who has access to Stewart's email will have to I believe click on it. Unless Mark or Bill can do something, that is...
> 
> -----Original Message-----
> From: Filepro-list <filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com> On Behalf Of Stuart Werner via Filepro-list
> Sent: Thursday, October 1, 2020 7:59 PM
> To: filepro-list at lists.celestial.com
> Subject: RE: Filepro-list Digest, Vol 200, Issue 34
> 
> 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
> 
> _______________________________________________
> 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
> 

-- 
Audio panton, cogito singularis.


More information about the Filepro-list mailing list