AnsweredAssumed Answered

SQL memory leak makes FileMaker unusable!

Question asked by J.VanDen on Feb 24, 2011
Latest reply on May 27, 2011 by maartenvanthof

Summary

SQL memory leak makes FileMaker unusable!

Product

FileMaker Pro

Version

11.0v2 and 11.0v3

Operating system version

Windows Server 2008 R2

Description of the issue

Our application features a calendar (Fusion calendar plugin) which polls FileMaker via SQL for updated appointment information. Even just opening the program without any other activity, this results in a continuous increase in memory usage. Active use of the system accelerates the memory usage. Our application is hosted on a server and individual users increase their memory usage from 150 MB to over 1 GB sometimes within 1-2 hrs. This results in errors, application crash and finally server crash. I have seen other reports on the forum about this memory leak in FileMaker when using SQL going back to May 2010! We now have a very serious and untenable situation with not just unhappy, but angry custumors who depend on the application for their daily work schedule as well as financial administration and billing. Help is needed ASAP!!!

Steps to reproduce the problem

See other posts. Apparently, just running an sql query will do this. In our case, this is done by the Fusion calendar plugin.

Exact text of any error message(s) that appear

No error message at first. Everything works fine, except memory usage increases continuously. This then results in slowdown, a variety of errors and crash.

Workaround

Stopping the database and restarting purges the memory. This is not even a workaround, but an emergency measure. Not a workable situation!

Outcomes