FMS9 Repeated Crashes - Suspect Smartpill
Using FMS9 with Smartpill PPC 1.00
Machine is DUal G5 running OS X Tiger.
Recently turned on a script that is run every ten minutes by the server, and uses Smartpill. The server now crashes a few times a day - and there is often a mention of php in the stack backtrace (examples included below). Note, web-publishing and instant web-publishing are turned OFF on this server.
Is this Smartpill, and if so, any idea what is causing it?
Thread 35 Crashed:
0 com.datadirect.ddfmsoc.bundle 0x03beda54 EventProfile_Get + 4
1 com.datadirect.ddfmsoc.bundle 0x03ba1d34 SWANEVPROC_ProcessEvents + 196
2 com.datadirect.ddfmsoc.bundle 0x03b9fd50 SWANERROR_ErrorEvent + 640
3 com.datadirect.ddfmsoc.bundle 0x03ba0a48 SWANERROR_HandleError + 376
4 com.datadirect.ddfmsoc.bundle 0x03ba4174 SWANSCHED_Get + 132
5 com.datadirect.ddfmsoc.bundle 0x03b7fb60 refresh_slserver + 64
6 ...filemaker.xdbcplugin.bundle 0x0250d5ec Do_FileListChange() + 380 (ODBCPlugIn.cpp:921)
7 ...filemaker.xdbcplugin.bundle 0x0250d87c FMExternCallProc + 588 (ODBCPlugIn.cpp:1796)
8 ...ilemaker.dbengine.framework 0x01852f04 Draco::DBPlugIn::NotifyFileSharingChange() + 148
9 ...ilemaker.dbengine.framework 0x01809c44 Draco::DBFileUser::SetShareable(bool) + 2116
10 ...lemaker.EngineMgr.framework 0x01f36404 EngineOpeningThread::Main() + 1012
11 ...filemaker.support.framework 0x0153c700 Draco::Thread::RunThread() + 160
12 ...filemaker.support.framework 0x0153abf0 Draco::Thread::ThreadUnixProc(void*) + 80
13 libSystem.B.dylib 0x9002bd08 _pthread_body + 96
Crashlog example 1:
Thread 32 Crashed:
0 com.scodigo.PHP 0x098caa98 zend_do_fcall_common_helper_SPEC + 48
1 com.scodigo.PHP 0x098ca9bc execute + 520
2 com.scodigo.PHP 0x0984207c zend_eval_string + 440
3 com.scodigo.PHP 0x09813068 phpworker::Run(void*) + 356
4 libSystem.B.dylib 0x9002bd08 _pthread_body + 96
Crashlog example 2:
Thread 32 Crashed:
0 <<00000000>> 0xffff86bc __bzero + 188 (cpu_capabilities.h:187)
1 com.scodigo.PHP 0x0983d354 allocate_new_resource + 288
2 com.scodigo.PHP 0x0983d478 ts_resource_ex + 212
3 com.scodigo.PHP 0x09812f34 phpworker::Run(void*) + 48
4 libSystem.B.dylib 0x9002bd08 _pthread_body + 96
FMS9 Repeated Crashes - Suspect SmartPill
Not sure about the first example but the second and third look like SmartPill. Are you able to try our beta version (1.5)? We plan to release this very soon and it will be a free upgrade so it may be worth a try. See our downloads page under support.
Can you give me some insight into what the PHP code is doing?
Are you using PHP_Execute with the "keepMemory" param set to 1?
Regards,
Micah
The PHP code is simply
The PHP code is simply running a batch set of calls to the PHP mail() function (it's sending mails automatically from the solution).
The crashes are oddly occurring when there are no mails to send. So, the PHP code never gets called. All that gets called is the PHP_Register function as the script runs that each time to check the plug-in is loaded.
Is it possible that caling PHP_Register from the same solution once every 10 minutes might cause a crash eventually?
Have downloaded 1.5 today and will play with it.
Running a test here
I'm running a similar test here to see if I have any issues. I'm running a Windows server so it's not an ideal test but I'll see if there are any problems. The test runs a script that calls PHP_Register and then executes some code to send an email with the registration info.
One tip is that you can avoid having to call PHP_Register if you install a License.txt file on your server. See page 9 in the manual for more details.
I can't imagine that calling PHP_Register would be the issue but if you can get rid of it, that will at least reduce the number of variables.
Regards,
Micah