Filepro-list Digest, Vol 200, Issue 34

Walter Vaughan Jr wvaughan at steelerubber.com
Fri Oct 2 06:19:31 PDT 2020

Previous message (by thread): Filepro-list Digest, Vol 200, Issue 34
Next message (by thread): Filepro-list Digest, Vol 200, Issue 34
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

Previous message (by thread): Filepro-list Digest, Vol 200, Issue 34
Next message (by thread): Filepro-list Digest, Vol 200, Issue 34
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the Filepro-list mailing list