1 2 3 Previous Next 31 Replies Latest reply on Feb 19, 2015 12:03 PM by disabled_ntaylor

    Server Scripts- Server stop

    UrsLandis

      Title

      Server Scripts- Server stop

      Your post

      Hi

      At night we have several scripts running, part of them run up to 40 Minutes. Since 13.05 they crash after several minutes. No problems until 13.04

       

      at the console  "Unerwartet abgebrochen"

      Tue Jan 27 23:19:14 CET 2015    Server-Ereignisse    Warnung    Client "Diff kalkulieren (FileMaker Script)" antwortet nicht mehr; Verbindung geschlossen. (51)
      Tue Jan 27 23:17:18 CET 2015    Server-Ereignisse    Informationen    Zeitplan "Diff kalkulieren" für 28.01.2015 23:15 eingeplant.
      Tue Jan 27 23:17:18 CET 2015    Server-Ereignisse    Fehler    Der Prozess FileMaker Script Engine wurde abnorm beendet.
      Tue Jan 27 23:17:18 CET 2015    Server-Ereignisse    Fehler    Zeitplan "Diff kalkulieren" abgebrochen; FileMaker-Scripts können nicht ausgeführt werden, da der FileMaker Script Engine (FMSE)-Prozess angehalten wurde. Verwenden Sie den Befehl "fmsadmin start fmse", um den FMSE-Prozess zu starten.
      Tue Jan 27 23:15:00 CET 2015    Server-Ereignisse    Informationen    Zeitplan "Diff kalkulieren" hat das FileMaker-Script "Diff übertragen" gestartet.
      Tue Jan 27 23:15:00 CET 2015    Server-Ereignisse    Informationen    Zeitplan "Diff kalkulieren" wird ausgeführt.
      Tue Jan 27 23:00:36 CET 2015    Server-Ereignisse    Informationen    Zeitplan "Datenbank Check" fertig ausgeführt.
      Tue Jan 27 23:00:36 CET 2015    Server-Ereignisse    Informationen    Zeitplan "Datenbank Check" für 28.01.2015 23:00 eingeplant.

       

      Mac Mini 2GHz i7, 4 GB RAM mit OS X 10.10.1, since today 10.10.2, nothing changed

       

      regards

       

      Urs

        • 1. Re: Server Scripts- Server stop
          UrsLandis

          No one?

          • 2. Re: Server Scripts- Server stop
            UrsLandis

            Tonight i reinstalled fms, this time in english...

            Same problem:

            Script ends with status:

                                                                             
                           
            Aborted unexpectedly
                           
                           

             

                           

             

                           

             Fri Jan 30 08:15:12 CET 2015    Server Events    Information    Client "Diff (FileMaker Script)" no longer responding; connection closed. (51)
            Fri Jan 30 08:13:14 CET 2015    Server Events    Information    FileMaker Script Engine process has terminated abnormally.
            Fri Jan 30 08:13:14 CET 2015    Server Events    Information    Schedule "Diff" aborted; FileMaker scripts can't be run because FileMaker Script Engine (FMSE) process is stopped. Use the command "fmsadmin start fmse" to start the FMSE process.
            Fri Jan 30 08:11:17 CET 2015    Server Events    Information    Schedule "Diff" run now by "admin".

            regards

            Urs

            • 3. Re: Server Scripts- Server stop
              Markus Schneider

              What does that script? 

              Just a dumb question: Without that scheduled script, the server runs fine, no crashes?

              • 4. Re: Server Scripts- Server stop
                UrsLandis

                Thanks for your answer!

                It's not just one script. We have problems with all scripts that rns for several minutes.

                That scripts for exmple, replace one numberfield with an calcultionfield. 28'000 records.

                In normal work the server runs fine, no problems.

                 

                There is one case i can crash the server, if i search in the same calculation field. The server stop without any errors in the log.

                regards

                 

                Urs

                • 5. Re: Server Scripts- Server stop
                  Markus Schneider

                   

                  I wrote a looong posting here, just to realize that this super forum software kicked me out as I wanted to save it... I was thinking that this bug was solved...

                  • 7. Re: Server Scripts- Server stop
                    Markus Schneider

                    was a stressy day, wasted a lot of time with some xml interface. Seems to run now..

                    My orphaned posting, AFAIR:

                    -> it works well on a local copy, according to the discussion on the german section

                    therefore:

                    - rename a COPY of Your solution with FileMaker Advanced

                    - turn the index of that field of, close the solution, reopen it and turn index on

                    - install that renamed copy on the server, take care that no users can log on - and test it

                    - You can run the recover command on that COPY and check for error messages..

                    Since the server log are telling You that the virtual user was no longer responding: Isn't there a setting to turn that off?

                     

                    maybe there were other things I mentioned )-:

                     

                    ** Sorry for typing mistakes - but it's impossible to edit postings on iPad 

                    • 8. Re: Server Scripts- Server stop
                      UrsLandis

                       

                      Thanks for your answer!

                       

                      Local on my mac it runs fine. Only the ODBC Connections to our webserver are missing at the local copy, but this field and script has nothing to do with the ODBC.

                      On the calculation field i can't set the index, i tried to disable the index on the other field, tried on the server, nothing changed

                      At the recover are no errors at all....

                      Max running time is set to 60 minutes

                      Process:               fmserverd [212]
                      Path:                  /Users/USER/*/fmserverd
                      Identifier:            fmserverd
                      Version:               ???
                      Code Type:             X86-64 (Native)
                      Parent Process:        launchd [1]
                      Responsible:           fmserver_helperd [45]
                      User ID:               502

                      Date/Time:             2015-01-31 09:07:03.456 +0100
                      OS Version:            Mac OS X 10.10.2 (14C109)
                      Report Version:        11
                      Anonymous UUID:        46117CCF-2C02-C80B-907C-D4BC542B9C30


                      Time Awake Since Boot: 340 seconds

                      Crashed Thread:        47

                      Exception Type:        EXC_BAD_ACCESS (SIGBUS)
                      Exception Codes:       KERN_PROTECTION_FAILURE at 0x00000001088b8de4

                      VM Regions Near 0x1088b8de4:
                          MALLOC_LARGE           00000001086b6000-00000001088b8000 [ 2056K] rw-/rwx SM=PRV  
                      --> STACK GUARD            00000001088b8000-00000001088b9000 [    4K] ---/rwx SM=NUL  stack guard for thread 47
                          Stack                  00000001088b9000-000000010893b000 [  520K] rw-/rwx SM=COW  thread 47

                      regards

                      Urs

                      • 9. Re: Server Scripts- Server stop
                        UrsLandis

                        No one??

                        • 10. Re: Server Scripts- Server stop
                          Markus Schneider

                          if non of the TS' chimes in: Call support by phone )-:

                          • 11. Re: Server Scripts- Server stop

                            Urs Landis: 

                             

                            Thank you for the post.

                             

                            Depending on what these scripts are doing, a great deal of system resources are used by the process that is crashing. Since the script engine process is crashing, then the most likely cause is insufficient resources. 

                             

                            Since this computer is running the minimum recommended requirements for a Database Server only at 4 GB of RAM, if the server is doing any web publishing at all, then the machine is running below specifications. The very first suggestion would be to increase the total to 8 GB and see if the issue persists. 

                             

                            System Requirements for FileMaker Server 13

                             

                            TSFalcon

                            FileMaker, Inc.

                            • 12. Re: Server Scripts- Server stop
                              UrsLandis

                              now with 16Gb of RAM and 2048 MB of cache still the same problem.

                               

                               

                              regards

                               

                              Urs

                              • 13. Re: Server Scripts- Server stop

                                Urs Landis: 

                                 

                                Thank you for the reply.

                                 

                                If the issue persists after increasing the resources, then some additional questions to assist with narrowing this down:

                                 

                                1. The FileMaker Server 13.0v5 was previously uninstalled and reinstalled with the full v5 installer? 

                                2. Was the FileMaker Server folder (Macintosh HD/Library/FileMaker Server) removed or renamed prior to reinstalling? 

                                3. The script engine process crashes everyday when the schedules are run?

                                4. How many schedules are running at the peak?

                                5. What tasks are the schedules performing?

                                6. If a new backup schedule is created and only that schedule run, does the crash still occur?

                                 

                                Additionally, check your inbox at the top of this page for the instructions on how to submit your System Information file and FileMaker Sever logs.

                                 

                                TSFalcon

                                FileMaker, Inc.

                                • 14. Re: Server Scripts- Server stop
                                  UrsLandis

                                  Thanks for your answer!

                                   

                                  1. The FileMaker Server 13.0v5 was previously uninstalled and reinstalled with the full v5 installer? 

                                  The server was completly reinstalled, but with fms 13.01.224 -> 13.03.300 -> 13.05.520

                                  2. Was the FileMaker Server folder (Macintosh HD/Library/FileMaker Server) removed or renamed prior to reinstalling? 

                                  Yes, removed

                                  3. The script engine process crashes everyday when the schedules are run?

                                  Yes, everyday and evertime

                                  4. How many schedules are running at the peak?

                                  1

                                  5. What tasks are the schedules performing?

                                  put the Value from a calculation field to a text field for about 28'000 records

                                  6. If a new backup schedule is created and only that schedule run, does the crash still occur?

                                  No, backup schedules works without problems.

                                   

                                  regards

                                   

                                  Urs

                                  1 2 3 Previous Next