Yesterday I upgraded one of my M1 mac mini servers from macOS ventura 13.1 to 13.2, and also did the FileMaker Server 19.6.3 upgrade.
I ran into a bunch of problems.
FileMaker seemed dead - no databases would open, scheduled scripts failing, eventually I figured out the problem: Additional database folder is invalid or could not be set. The solution was to go to my additional databases folder /Users/myUser/myFileMakerData/ in the Finder, get Info, authenticate, and manually add the FMSERVER user with read/write permissions, then "Apply to Enclosed Folders". I also had to do this all the way up the chain, to /Users/myUser/ folder. Somehow, either the Ventura or FMS updates had reset permissions during the install.
Scheduled scripts reported as "Failed". In the FMS Admin page, I could select a scheduled script, click the button to Run it, see that it worked, but the status would show as "Failed". This appears to be a false alarm: if the last script step in a scheduled script has an error (such as a Find Records step that returned no results), that error status would propagate outwards so that the FMS admin would show the script as failed. This seems like a behavior change to me. In any case, the fix is simple: Adding these two lines to the very end of the script seems to solve the problems:
Set Error Capture [Off]
Exit Script ("")
After fixing these issues, I thought all was good! I went to sleep, and then a few hours later, started getting SMSs that the server was down. The problem?
For this mac mini server, I had also changed out the USBC to VGA dongle (from a generic brand to Apple brand). I suppose it's possible this change of monitors is what reset the "Prevent automatic sleeping..." setting? rather than the 13.1 to 13.2 upgrade?
Even though the server was "asleep", I was still getting FileMakerServer emails warning me of script failures:
2023-02-06 03:17:19.304 -0800 Error 691 example.com Schedule "ServerScheduledRobot" aborted; time limit exceeded or server stopped.
But, dear reader, you may ask: if the server was off, how could it be sending emails? I wonder this myself.
As far as I know, the Mac Mini M1 does not have any sort of "PowerNap" feature.
Maybe the server was in fact waking up occasionally, sending an email, then falling back to sleep?
On the positive side: 24 hours later, and after telling the M1 Mini that "sleep is not an option" all is good again.
On the negative side, the FMS upgrades are still pretty awful though:
the Admin console web page tells you an upgrade is needed, but doesn't tell you how to get it
you have to remember your Claris download URL and get the download from there, but...
the FMS installer immediatly complains "FileMaker is still running" and then provides no hints about how to do the upgrade
the answer is to go to another URL to find the ReadMe for FMS installer updates, and read the hints. The answer seems to be: sudo launchctl stop com.FileMaker.fms
however, if you try the install, it fails (sometimes)
the real answer seems to be sudo launchctl stop com.FileMaker.fms
wait some amount of time (not specified) until all the services have stopped
then try the installer
I did get it to work normally after a while; I'm not sure what I did, but some combination of Restarting the server, updating to 13.2.1, and double checking that the Prevent automatic sleeping when the display is off setting was set seems to have done it. The server has 11 days uptime so far and is doing fine.
It has been SOP for the FMS installer to reset file permissions, and reset the fmsadmin group, on every install or update. Probably often a good thing, but this might be another case of that causing problems, although I haven't seen it break the permissions to the database folders in the way you mention.
The unexpected powering down is classic Power Nap behavior. Certain actions can cause the system to wake back up, including FMS. To get the power/energy saver settings to stick I've sometimes had to reset the system's PRAM, appears to be an issue with certain hardware where these setting don't get saved correctly.