1 2 3 Previous Next 30 Replies Latest reply on Jul 18, 2017 6:05 PM by StephenWonfor

    Server 16 Sleep

    StephenWonfor

      Hi

       

      I am setting up a client server - FMS16.0.2.212. OS X 10.12 Sierra

      Have 30 dbs on it - client still needs their old data.

      I have one script running - every 10 minutes it FTPs (using 360Works FTPeek) a tiny little file to a remote server.

      Has been working well for a few hours, then this...

      "FileMaker Server is going to sleep. The entire cache will be flushed. All schedules will be suspended."

      Then, a little while later...

      "FileMaker Server is now awake. All schedules will now be resumed."

       

      I thought I had everything set for no hard drive spin down etc. but noticed "Power Nap" was on.

      Does FMServer respond to Power nap?

       

      Stephen

       

      "I stopped understanding math when the alphabet decided to get involved." ~anon

        • 1. Re: Server 16 Sleep
          psijmons

          In your Preferences > Energy Saver >  ...

          you should have these settings:

          • prevent from sleeping   ON
          • put harddisk to sleep OFF
          • wake for Wifi access (up to you)
          • enable PowerNape OFF
          • 2. Re: Server 16 Sleep
            StephenWonfor

            Yes

             

            Had all that.  Forgot about power naps.  This machine has had a a number of wipe/reinstall sessions.  Naps off now.  Thought power naps was for apps only.  Isn’t FMS a service?

             

            Stephen

             

            ---

             

            #####################################################################################

            HASH NOTE: The lines above and below this note are comprised of strings of the glyph "#" (Unicode as U+0023).  It is also known as a hex, an octothorp (originally a joke term) and is sometimes confused with the Chinese character for a "water well" -  井.  If you are not the intended recipient of this message then I have messed up.  Sorry.

             

            • 3. Re: Server 16 Sleep
              psijmons

              You might be right with the powernap, these are my default settings when setting up a Mac server for FMS and have never seen it's going to sleep. I can't imagine another pref that would cause this, except if you've set up a schedule via EnergySaver (?)

              • 4. Re: Server 16 Sleep
                wimdecorte

                StephenWonfor wrote:

                 

                Thought power naps was for apps only. Isn’t FMS a service?



                 

                According to best practices an FMS machine should be dedicated to the task, so there would be no apps and hence you would turn power naps off.  In general any and all settings that don't belong on a server would need to be turned off so that there is zero chance of them interfering with FMS.

                 

                The distinction whether something applies to an app or service then becomes moot and you are in full control.  Which is what you want.

                1 of 1 people found this helpful
                • 5. Re: Server 16 Sleep
                  StephenWonfor

                  Wim

                   

                  This is a section of the server log from last night.

                  The empty rowsare there to highlight the gaps - the FTP routine did not run on its 5 minutes schedule.  And there is nothing in the log to indicate why.

                  This “server awake” bit rather alarms me.

                  Everything in the Energy Saver is set too “off”.

                  This machine is part of the client upgrade to FMP16 - the run FM11 right now.  Their server has FTP’d files every 10 minutes during business hours for about 4 years now.

                  We use 360WorksFTPeek.

                   

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     Resuming database "Database_New_v3"...

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     Resuming database "DatabaseWebStore"...

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     Database "DatabaseWebStore" resumed.

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     Resuming database "DatabaseWebStoreLexicom"...

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     Database "DatabaseWebStoreLexicom" resumed.

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     Database "DatabaseMenu" resumed.

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     Resuming database "DatabasePDFDocuments"...

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     Database "DatabasePDFDocuments" resumed.

                  Sun Jul 16 07:11:36 MDT 2017     Server Events     Information     FileMaker Server is now awake. All schedules will now be resumed.

                  Sun Jul 16 07:11:20 MDT 2017     Server Events     Information     Administrator connected: "admin " (admin console).

                   

                  Sun Jul 16 07:10:40 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" completed.

                  Sun Jul 16 07:10:40 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" scheduled for 07/16/2017 07:15 AM.

                  Sun Jul 16 07:10:37 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" has started FileMaker script "Server16 - SFTP Test Uploads".

                  Sun Jul 16 07:10:37 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" running.

                   

                  Sun Jul 16 06:46:08 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" completed.

                  Sun Jul 16 06:46:08 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" scheduled for 07/16/2017 06:50 AM.

                  Sun Jul 16 06:46:04 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" has started FileMaker script "Server16 - SFTP Test Uploads".

                  Sun Jul 16 06:46:04 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" running.

                   

                  Sun Jul 16 04:45:15 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" completed.

                  Sun Jul 16 04:45:15 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" scheduled for 07/16/2017 04:50 AM.

                  Sun Jul 16 04:45:11 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" has started FileMaker script "Server16 - SFTP Test Uploads".

                  Sun Jul 16 04:45:11 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" running.

                   

                  Sun Jul 16 02:45:03 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" completed.

                  Sun Jul 16 02:45:03 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" scheduled for 07/16/2017 02:50 AM.

                  Sun Jul 16 02:45:00 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" has started FileMaker script "Server16 - SFTP Test Uploads".

                  Sun Jul 16 02:45:00 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" running.

                  Sun Jul 16 02:44:22 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" scheduled for 07/16/2017 02:45 AM.

                  Sun Jul 16 02:44:22 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" completed.

                  Sun Jul 16 02:44:18 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" has started FileMaker script "Server16 - SFTP Test Uploads".

                  Sun Jul 16 02:44:18 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" running.

                   

                  Sun Jul 16 00:43:29 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" completed.

                  Sun Jul 16 00:43:29 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" scheduled for 07/16/2017 12:45 AM.

                  Sun Jul 16 00:43:25 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" has started FileMaker script "Server16 - SFTP Test Uploads".

                  Sun Jul 16 00:43:25 MDT 2017     Server Events     Information     Schedule "FTPServer16Test" running.

                   

                   

                  Stephen

                   

                  ---

                   

                  "The difference between fiction and reality? Fiction has to make sense." (Tom Clancy)

                  • 6. Re: Server 16 Sleep
                    StephenWonfor

                    Well.

                     

                    This continues to occur.  The server pauses all the databases, the FTP routine is aborted as time limit exceeded.  About 75 minutes later the server reports wakeup and things continue again for a few hours.

                    All energy saver items are off: no hard disk sleep, no power nap, no computer sleep.  Only "wake for network access" is on.  No users except when I connect to fiddle with the script.

                     

                    This is the script:

                     

                    The script

                     

                    Go to Layout [ “No Fields No Triggers” (T15_PRODUCTS) ; Animation: None ]

                    Show All Records

                    Omit Record

                    Show Omitted Only

                     

                    Set Variable [ $Register ; Value: FTPeek_Register( “blah blah ) ]

                     

                    Set Variable [ $Login ; Value: FTPeek_ConnectSFTP( "blahblah”   ) ]

                    Set Variable [ $Output ; Value: Get ( DocumentsPath ) & GetAsNumber( Get ( CurrentTimestamp )) & ".csv" ]

                    Export Records [ With dialog: Off ; “$Output” ; Macintosh ]  //this file is 19 bytes in size - one record two fields

                    Set Variable [ $Push ; Value: FTPeek_UploadFile( "incoming/StephenFMS16Tests/"; $Output ) ]

                     

                    Set Field [ T15_PRODUCTS::_gtLink ; GetAsNumber( Get ( CurrentTimestamp ) ) & "-" & Random ]

                    Set Field [ T15ae_products_FTPLOG|Link|::Log_Account ; Get ( AccountName ) ]

                    Set Field [ T15ae_products_FTPLOG|Link|::FilePath ; Get ( AccountName ) ]

                    Set Field [ T15ae_products_FTPLOG|Link|::FTPResult ; $$Push5 & " Version: " & FTPeek_Version & " AppVersion: " & Get ( ApplicationVersion ) ]

                    Set Field [ T15ae_products_FTPLOG|Link|::ScriptName ; Get ( SystemIPAddress ) & " " & “FW: " & Get ( ScriptName ) ] '

                     

                    Commit Records/Requests [with dialog: off]

                    Set Variable [ $Done ; Value: FTPeek_Disconnect ]

                     

                    A vastly more complex version of this routine has been running without issue for more than 4 years on an FMS 11 server.

                     

                    I am at a loss.

                    My next attempt - turn off the FTP bit and just write into the log file.

                     

                    Stephen

                    • 7. Re: Server 16 Sleep
                      wimdecorte

                      The server is not on wifi Ihope?

                       

                      Get Outlook for iOS<https://aka.ms/o0ukef>

                      • 8. Re: Server 16 Sleep
                        psijmons

                        Is the FTP user on its own account? With different settings in security?

                        • 9. Re: Server 16 Sleep
                          StephenWonfor

                          Scripts are running under the database full access account.  OS X user is admin account.

                          I will note, I imagine to Wim's horror, that it is on Wifi.

                          I will run some cat5 to it, disable the wifi and see what happens.

                          • 10. Re: Server 16 Sleep
                            StephenWonfor

                            So...

                             

                            Most recent log file (slight edits for brevity):

                             

                            Sun Jul 16 13:31:30 MDT 2017 Server Events Information Administrator connected: "admin [127.0.0.1]" (admin console).

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Schedule "FTPServer16Test" scheduled for 07/16/2017 01:35 PM.

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Schedule "FTPServer16Test" completed.

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Database "ProductionCalendar_v2" resumed.

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Resuming database "ProductionCalendar_v2"...

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Database "Plunk" resumed.

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Resuming database "Plunk"...

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Database "InventoryCounter_v3" resumed.

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Resuming database "InventoryCounter_v3"...

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Database "Database_New_v3" resumed.

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information Resuming database "Database_New_v3"...

                             

                            Sun Jul 16 13:31:04 MDT 2017 Server Events Information FileMaker Server is now awake. All schedules will now be resumed.

                            Sun Jul 16 13:30:58 MDT 2017 Server Events Information Administrator disconnected: "admin [127.0.0.1]" (admin console).

                            Sun Jul 16 13:30:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" running.

                            Sun Jul 16 13:30:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" has started FileMaker script "Server16 William - SFTP Test Uploads".

                            Sun Jul 16 13:29:42 MDT 2017 Server Events Information Pausing database "Plunk"...

                            Sun Jul 16 13:29:42 MDT 2017 Server Events Information Database "Plunk" paused.

                            Sun Jul 16 13:29:42 MDT 2017 Server Events Information Pausing database "ProductionCalendar_v2"...

                            Sun Jul 16 13:29:42 MDT 2017 Server Events Information Database "ProductionCalendar_v2" paused.

                            Sun Jul 16 13:29:42 MDT 2017 Server Events Information Database "Database_New_v3" paused.

                             

                            Sun Jul 16 13:29:42 MDT 2017 Server Events Information FileMaker Server is going to sleep. The entire cache will be flushed. All schedules will be suspended.

                            Sun Jul 16 13:27:07 MDT 2017 Server Events Warning Client "systems (CascadiaFault) [10.0.1.27]" no longer responding; connection closed. (51)

                            Sun Jul 16 13:25:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" completed.

                            Sun Jul 16 13:25:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" scheduled for 07/16/2017 01:30 PM.

                            Sun Jul 16 13:25:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" has started FileMaker script "Server16 William - SFTP Test Uploads".

                            Sun Jul 16 13:25:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" running.

                            Sun Jul 16 13:20:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" completed.

                            Sun Jul 16 13:20:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" scheduled for 07/16/2017 01:25 PM.

                            Sun Jul 16 13:20:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" running.

                            Sun Jul 16 13:20:00 MDT 2017 Server Events Information Schedule "FTPServer16Test" has started FileMaker script "Server16 William - SFTP Test Uploads".

                             

                            To reiterate:

                            Server 16.0.2.212

                            Sierra 10.12.5

                            2.8 GHz Intel Core i5 Dual Core

                            16 GB Ram

                            500 GB SSD

                            Direct Ethernet connection.

                             

                            Energy Saver set to be energy hungry - never spin down, never sleep, never nap.

                            The only things that sticks out is when a user - me - gets dropped due to inactivity - the server thinks it is time for a sleep.  Does that make sense?  Wondering if I should wind back to FMS 15 or El Cap?

                             

                            The server admin setting for idea time was not one so I reset to 1440.


                            Stephen

                            • 11. Re: Server 16 Sleep
                              StephenWonfor

                              A request for TSGAL. this is inhibiting a production rollout.  It is a real problem.

                               

                              Sun Jul 16 17:48:35 MDT 2017Server EventsInformationFileMaker Server is now awake. All schedules will now be resumed.
                              Sun Jul 16 16:57:00 MDT 2017Server EventsErrorSchedule "FTPServer16Test" aborted; time limit exceeded or server stopped.
                              Sun Jul 16 16:55:00 MDT 2017Server EventsInformationSchedule "FTPServer16Test" running.
                              Sun Jul 16 16:55:00 MDT 2017Server EventsInformationSchedule "FTPServer16Test" has started FileMaker script "Server16 William - SFTP Test Uploads".
                              Sun Jul 16 16:52:00 MDT 2017Server EventsErrorSchedule "FTPServer16Test" aborted; time limit exceeded or server stopped.
                              Sun Jul 16 16:52:00 MDT 2017Server EventsInformationSchedule "FTPServer16Test" scheduled for 07/16/2017 04:55 PM.
                              Sun Jul 16 16:50:00 MDT 2017Server EventsInformationSchedule "FTPServer16Test" has started FileMaker script "Server16 William - SFTP Test Uploads".
                              Sun Jul 16 16:50:00 MDT 2017Server EventsInformationSchedule "FTPServer16Test" running.
                              Sun Jul 16 16:49:49 MDT 2017Server EventsInformationDatabase "ProductionCalendar_v2" paused.
                              Sun Jul 16 16:49:49 MDT 2017Server EventsInformationDatabase "Plunk" paused.
                              Sun Jul 16 16:49:49 MDT 2017Server EventsInformationPausing database "ProductionCalendar_v2"...
                              Sun Jul 16 16:49:49 MDT 2017Server EventsInformationPausing database "Plunk"...
                              Sun Jul 16 16:49:49 MDT 2017Server EventsInformationFileMaker Server is going to sleep. The entire cache will be flushed. All schedules will be suspended.
                              • 12. Re: Server 16 Sleep
                                Mike Duncan

                                Silly question, but did you reboot the server after adjusting the energy saver settings? FM Server may have cached system settings and needs to get restarted to read them fresh. I would restart the entire server to give it a fresh start.

                                 

                                Mike

                                • 13. Re: Server 16 Sleep
                                  StephenWonfor

                                  Mike

                                   

                                  Pretty sure I have but just did it again now.  We’ll see.

                                   

                                  Stephen

                                   

                                  -


                                   

                                  HOSE  CUTTER:  A tool used to make hoses too short.  (---Attributed to the list at http://techtalk.parts-express.com/; Also claimed by others...)

                                  • 14. Re: Server 16 Sleep
                                    CarlSchwarz

                                    Can you use chron or launchd to check the OSX scheduled tasks?  Maybe something is there at a lower level.  Could some schedule / task / application be on this server that has left something behind or is this a fresh build of OSX?  I think you can even attach tasks to run in the calendar

                                    1 of 1 people found this helpful
                                    1 2 3 Previous Next