Jump to content

FMS18 on Mac randomly crashing at around 11:55 PM


Recommended Posts

Hello, 

 

We run several FMS18 instances on Mac OSX machines. 

Randomly, more often on Fri / Sat / Sun, Filemaker server will shut down and disconnect all clients - curiously always at the same time, around 11:55 PM - , and I am unable to restart it from the command line and the web admin drops offline. The only way to bring it back to life is to reboot the entire machine. 

 

Is there any scheduled update job at 11:55 PM that I should be aware of that would cause this behavior? 

 

 

Edited by DataCruncher
Link to post
Share on other sites
  • 3 weeks later...

No / not yet. It still keeps crashing at 11:50 PM like clockwork on several machines. I use the term crashing loosely as when I’m connected, I get the disconnect warning message, so it seems to be a clean shutdown. I only can’t start it back up either from the command line or the web interface as that’s also shut down. Terminal responds Error 10007 to restart, start and stop commands

Link to post
Share on other sites
  • 1 month later...

Bumping this topic. It keeps happening, light clockwork, to all three of our FM 18 servers 11:55 PM every Saturday. 

All filemaker functions drop off, and CLI result in 10007 error. What I did observe is when it goes down, the connected FMP clients get this warning message "Filemaker Server is shutting down now' so this appears to be some sort of graceful commanded shutdown that then kills the entire ecosystem for good. We do not have scheduled script tasks or cron jobs running at that time - why would Filemaker Server do that? 

 

Which log should I check for hints why this is happening?

 

Thank you

Link to post
Share on other sites

Hi Data Cruncher. It seems that the data restoration function may be responsible for causing this in FMS18. I moved to FMS19 and made sure that Data Restoration was not enabled and mostly it seems more stable. That having been said, one file stopped spontaneously last week but it appears it wasn’t damaged. I hope that helps...

Link to post
Share on other sites

Thank you, John - I have data restoration disabled on all my machines as this can really really have things head south, and fast 🙂

 

I was hesitant to move to FMS19 without identifying the cause first, simply because I did not know what else that would break and whether the same error occurs again. But I'll give it a try!

 

Thank you

Link to post
Share on other sites
2 hours ago, johnBuckingham said:

I suspect its not actually possible to properly disable Restoration in 18

The link to the community page doesn't work; but you can most certainly completely disable the data restoration in 18 and 19.0.  In fact, 19.0 installs with the feature turned off by default.  The feature is gone in 19.1.

4 hours ago, DataCruncher said:

why would Filemaker Server do that? 

Because it is instructed to do so.  There is most definitely something on your machine that is triggering a shutdown.  And moving up to 19 is probably not going to solve it since this is a non-FMS event.  Use all the logs available to you through the macOS console app and go through them with a fine comb.  Tedious, and easy to get impatient with it, but the clues will be there.

Link to post
Share on other sites
3 hours ago, johnBuckingham said:

What, then, would be your advice to the OP?

I already gave it a few replies back in this thread: use all the system logs available to trace any and all activity on those boxes - the clues will be there.

Since this is a fairly specific time-frame and happens to all of the servers there it has to be some environmental thing.  Or a piece of extra software that gets installed by default on all machines.  Could be as simple as the control software for the UPSes.

This behavior is not induced by FMS, otherwise it would happen to a lot more servers everywhere and it isn't.  So it is something specific to this deployment.

Link to post
Share on other sites
  • 2 weeks later...

Thank you Wim and John - I will keep looking. Like I said, it's a graceful shutdown as far as FMS is concerned - but after that has shut down, it won't come back on even from fmsadmin CLI. That's what's weird, but I agree it has to be something in the environment. 

 

Link to post
Share on other sites

SOLVED!

Wim was very right. 

On my virtualized Mac server, I looked high and low and couldn't find any cronjobs that would run at that time. 

However, I did not check the launchd plists!!! D'Oh!

 

Turns out, /Library/LaunchDaemons contained two .plist files that invoked letsencrypt renewal scripts at 11:51 PM every Saturday! The StartCalendarInterval was the dead giveaway. 

 

I assume FMS shuts down into some sort of safe hibernation that disallows it to be re-started if someone tries to mess with the SSL certificate while the server is running. 

 

I disabled the letsencrypt plist launchd's and will observe, but I am very confident that will do the trick!

 

Thank you for all the help - this has been a year in the making. 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Thomas Sanguinetti
      Good day all,
      Issue -
      I have created the file Radio.fmp12, stored in the same networked location as my other filemaker files. (See attached 'Filemaker Files.png').
      I am however unable to open this file using a script as have previous done with my other files.
      When I open the Hosts window, all my other programs are displayed except for Radios.fmp12. (See attached 'Hosts.png')
      I attempted to open the file directly via its network path and filemaker alerted me that the file could not be found (See attached 'filepath.png')
      Please forgive me if i am missing something but i can open the file directly from the directory so i am baffled as to why the file cannot be found.
      Any help would be appreciated as I am somewhat of a beginner with Filemaker.
       
      Thank you in advance
      Tom
       



    • By ggt667
      FM18P: What is best practice when it comes to importing data using JSON / ION? I usually use XSLT and FMPXMLRESULT for import, is there a similar way to do these imports of records into FileMaker?

      FM19S consideration: I guess the simplest way is to write something in ECMA or Swift that outputs the portable array as FMPXMLRESULT? As pr example
      curl -kL https://api.domain.tld > /opt/local/usecaseION2FMPXMLRESULT > /opt/FileMaker\ Server/Data/Documents/usecase.$(date).fmpxmlresult.xml But then again FileMaker 19 Server does not allow for XML imports?
    • By ggt667
      I have been running on 2 copies of the same license in my house, in the mean time I bought a 5 user VLA, how can I change the license in FileMaker 18?, when the trial expires I can simply click Browse and click on the cert file that came with the VLA.
    • By Clayton King
      First, I appreciate any help I can get as this project has been evolving over two years and, as these kinds of projects to, has become more involved and complicated over that time. I've posted related questions, but exploring other parts of my project. As I'm not a programmer, but a sort of user nerd, my inquisitive mind wants to learn, but sometimes simple concepts elude me. Feedback, both on the specific goal at hand as well as the project overall is always appreciated.
      Performers is one piece of a much larger project, but I'm trying to enhance the project and working on a piece at a time. 
      BACKGROUND
      I'm sharing the entire project layout to provide some insight into how the parts fit together. The application is a booking management tool for performers, consisting is several tables as shown:

      Again my focus right now is the Performers table and how to use it in relation to the Gigs (and Gigs~Songs_Join) tables.
      There is a Gigs layout which is the hub for performances by one or more Performers. On that layout is summary information about a gig and a portal which shows which songs were performed and in what order (Set & Slot fields). The portal also includes a Performer Name. The assumption at this point is that up to 4 performers will do a given gig. This might change in the future, and could impact the below goals.
      Gigs~Songs_JOIN is a connecting table for Gigs, Performers, Songbook, Venues, Musicians, etc. Performers is a table of singers and includes fields for a serialized SingerID, name, area of speciality (Tenor, Baritone, etc.), etc., and additional fields for combinations of the same performers including: 
      Multi: checkbox-indicates this record is more than one performer
      PerformerName: calculated based on Multi: if NOT Multi, show performers Name, if Multi, show MultiName (below)
      Type: value list-is this a duet, trio, quarter, all, etc.
      MultiName: the description of this record (i.e., Duet-Clayton/Vicky)
      Other summary fields include:
      Total Gigs: count of gigs in which this person has performed
      Total Songs: count of songs this person has performed
      GigID: match field to Gigs~Songs_Join

      GOAL
      I have two goals, one related to the other. First, if the Performer record is checked Multi, I want to "attach" or "associate" individual singer(s) to the record (i.e., show what people are "included" in the MultiName). For example, MultiName=Duet-Clayton/Vicky, I want to show that Clayton and Vicky (each in separate records) are part of Duet-Clayton/Vicky.
      Second, ultimately on the Gigs layout, I want to show which Performer sang which song (currently works in the portal), but more importantly, show variable summary information (goal layout below) which changes for each Gig as to each Performer, how many songs they sang and the total amount of time they sang. The catch is, in the summary I don't want to show the Multi records, but instead increment individual singers. So, in the summary info with related portal records in the example below, rather than showing Clayton sang one song, Vicky sang one song and Duet:Clayton/Vicky sang one song, I want to show Clayton sang 2 songs and Vicky sang 2 songs. In summary info, Duet:Clayton/Vicky wouldn't appear. In other words, the summary would show how much time each person was singing.

       In the summary block of the Gig's layout, each of the above sets is a one-row portal filtered by set. I want to have the SINGER1,2,3,4 replaced with the actual Performer's name, and each band/portal show summary info for the appropriate singer. 
      Here is my relationship graph:

       
    • By ggt667
      For FileMaker hosted solution does anyone use $$VARIABLE for external data source? I'm able to make $$VARIABLE="file:filename" work, however $$VARIABLE="fmnet:/host/filename" does not.
      In my case this would be $$FM16S00CONTACT="fm16s00.domain.tld/contact" and $$FM18S00CONTACT="fm18s00.domain.tld/contact"
      This now works, however it's unclear to me what triggered this working. I have a startup script that sets the variables. I have configure the External Data Source with $$FM16S00CONTACT, and this works, however adding another data source does not work for now, I tried quitting FileMaker and relaunch.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.