AnsweredAssumed Answered

FileMaker Server 11 crashing deep in SQL internals

Question asked by jnouwen on Jan 2, 2014

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.

Outcomes