5 Replies Latest reply on Mar 27, 2017 8:23 AM by airmoi

    FMS 14.0.4 crashes everyday

    airmoi

      Hi,

       

      We are facing a recurrent issue since a couple of weeks on a customer server which intensively uses CWP and ODBC trough ESS.

      Everyday (sometimes twice a day), fms process crashes with exception code 0xc0000374.

       

      Sometimes (not always), we have a dump file created in the log folder of FileMaker server.

      All those dump points to a thread that mention something wents wrong after an ODBCQuery :

      ntdll!NtWaitForSingleObject+a
      KERNELBASE!WaitForSingleObjectEx+94
      Support!Draco::ThreadPool::ThreadPool+386
      Support!Draco::WinExceptionDumper+79
      DBEngine!antlr3ExceptionNew+480cf
      msvcr120!__C_specific_handler+93
      ntdll!RtlpExecuteHandlerForException+d
      ntdll!RtlDispatchException+197
      ntdll!KiUserExceptionDispatch+3a
      Support!Draco::SCSUCompressFromUnistring::GetChar+10
      Support!Draco::SCSUCompress::BaseState+3f
      Support!Draco::SCSUCompress::CompressNextBytes2Stream+68
      Support!Draco::SwapOStream::Put+115
      DBEngine!FMODBC::ODBCQuery::GetExtendedError+7b1
      DBEngine!FMODBC::ODBCQuery::BatchResults+2ee
      DBEngine!FMODBC::ODBCQuery::Restart+d17

       

      Please see the 2 dump files in attachement for more information (the second is a bit different).

       

      Specs :

      FMS 14.0.4.412

      Windows 2012 R2 Standard with all updates

      VMWARE ESX machine

      4vCores

      8Gb RAM.

       

      Nothing was changed on the server before crashes start to occure

       

      Any help would be appreciate

        • 1. Re: FMS 14.0.4 crashes everyday
          TSGal

          airmoi:

           

          Thank you for your post.

           

          I have sent your post along with the DMP files to our Development and Testing departments for review.  When I receive any feedback, I will let you know.

           

          TSGal

          FileMaker, Inc.

          • 2. Re: FMS 14.0.4 crashes everyday
            TSPigeon

            airmoi:

             

            Per review of the DMP logs, this issue looks to be related to getting results from the ODBC Query.

            -Can you let us know what kinds of ODBC query are being performed?

            -Is there anything unusual about the results that could be coming back?

             

            TSPigeon

            FileMaker, Inc.

            • 3. Re: FMS 14.0.4 crashes everyday
              airmoi

              We are using ESS only, I can't tel you what kind of queries FileMaker does internally.

               

              Since we updated to latest Mysql ODBC drivers, crashes occurs less frequently (~1/week).

              We have also changed the way ESS data are display to user to reduce its usage (which also had an impact on crashes frequency)

              • 4. Re: FMS 14.0.4 crashes everyday
                TSGal

                airmoi:

                 

                The DMP file is because of msvcp120.dll, which comes from Microsoft Visual C++ 2013 Runtime library.  Most of the MySQL ODBC Driver issue is related to the MS Visual C++ 2013 library, and as you said, updating the driver has reduced the number of crashes.  Testing suggests reinstalling the compatible version of Microsoft Visual C++ 2013 Redistributable Package manually to check it again.

                 

                TSGal

                FileMaker, Inc.

                • 5. Re: FMS 14.0.4 crashes everyday
                  airmoi

                  Ok, I'll try this next time we have a crash.

                  For now things are going quite well with all optimization we have made and new ODBC drivers