0 Replies Latest reply on Jan 2, 2014 9:27 AM by jnouwen

    FileMaker Server 11 crashing deep in SQL internals

    jnouwen

      Summary

      FileMaker Server 11 crashing deep in SQL internals

      Product

      FileMaker Server

      Version

      11.0.5.510

      Operating system version

      Mac OS X 10.8.5 (12F45)

      Description of the issue

      We're having periodic crashes of fmserverd relating to ODBC/SQL. It's only happened a handful of times, but has been happening with increasing frequency over the last few months.

      Steps to reproduce the problem

      Run FileMaker Server as normal and wait for the crash to happen.

      Expected result

      No crash.

      Actual result

      Kaboom!

      Exact text of any error message(s) that appear

      I have the full crash log, but here's the relevant backtrace:

      Thread 102 Crashed:
      0   libtdsodbc_new-i386.dylib          0x37d05221 SQLGetDiagField + 1598
      1   libtdsodbc_new-i386.dylib          0x37d0553c SQLGetDiagField + 2393
      2   libtdsodbc_new-i386.dylib          0x37d0d352 SQLExecDirect + 197
      3   atsqlsrv.so                        0x3860d3ff 0x38600000 + 54271
      4   atsqlsrv.so                        0x3860ddf2 0x38600000 + 56818
      5   atsqlsrv.so                        0x38630e7d 0x38600000 + 200317
      6   atsqlsrv.so                        0x38667b73 SQLExecDirectW + 1061
      7   libiodbc.2.dylib                   0x0189b208 SQLExecDirect_Internal + 392
      8   libiodbc.2.dylib                   0x0189b6dd SQLExecDirectW + 269
      9   com.filemaker.dbengine.framework     0x00610797 FMODBC::ODBCQuery::ExecuteDirect(Draco::unistring const&, long long) + 1047
      10  com.filemaker.dbengine.framework     0x0061953d FMODBC::RCODBCQuery::PerformOperation() + 2477
      11  com.filemaker.dbengine.framework     0x003f5b6c Draco::RCUploadDownload::Perform() + 316
      12  com.filemaker.dbengine.framework     0x0040ce79 Draco::RCNetworkStack::DispatchTransaction(Draco::RCConnection*, unsigned long, void*, unsigned long) + 505
      13  com.filemaker.dbengine.framework     0x0040dc7c RPO_i::Perform(unsigned long, unsigned long, OctetSeq&, OctetSeq_out) + 188
      14  com.filemaker.dbengine.framework     0x003f87c1 _0RL_lcfn_E7F0BDFD3D523DDE_70000000(omniCallDescriptor*, omniServant*) + 145
      15  com.filemaker.omniorb4.framework     0x010cc745 omniCallHandle::upcall(omniServant*, omniCallDescriptor&) + 165
      16  com.filemaker.dbengine.framework     0x003fa045 _impl_RPO::_dispatch(omniCallHandle&) + 245
      17  com.filemaker.omniorb4.framework     0x011aa36f omni::omniOrbPOA::dispatch(omniCallHandle&, omniLocalIdentity*) + 643
      18  com.filemaker.omniorb4.framework     0x011887eb omniLocalIdentity::dispatch(omniCallHandle&) + 109
      19  com.filemaker.omniorb4.framework     0x01123791 omni::GIOP_S::handleRequest() + 307
      20  com.filemaker.omniorb4.framework     0x01123e4b omni::GIOP_S::dispatcher() + 229
      21  com.filemaker.omniorb4.framework     0x0113d9f2 omni::giopWorker::real_execute() + 1406
      22  com.filemaker.omniorb4.framework     0x0113daaa omni::giopWorker::execute() + 50
      23  com.filemaker.omniorb4.framework     0x01142f28 omniAsyncWorker::real_run() + 334
      24  com.filemaker.dbengine.framework     0x003fc3a6 threadCreateInterceptor(omni::omniInterceptors::createThread_T::info_T&) + 22
      25  com.filemaker.omniorb4.framework     0x01143134 omniAsyncWorker::run(void*) + 50
      26  com.filemaker.omniorb4.framework     0x011bbd0e omni_thread_wrapper + 160
      27  libsystem_c.dylib                  0x907d65b7 _pthread_start + 344
      28  libsystem_c.dylib                  0x907c0dce thread_start + 34

      Configuration information

      FileMaker Server is running on the same machine as the Web Publishing Engine

      The only ESS source we use is a Microsoft Dynamics 2013 server running on Windows Server 2012 with MS SQL 2010.

      We do use both the ExecuteSQL script step as well as the myFMbutler DoSQL 1.4.4 plugin (both on the server and for FileMaker clients), mostly for querying the FileMaker files, but there is occasional use in querying the Dynamics tables through ESS.