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!
Please compare what you are experiencing to this previously logged report and let us know if it looks like the same issue or not: FileMaker Server
This is one of many acknowledged bugs that can be found in the Known Bug List here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: http://www.4shared.com/file/8orL8apk/FMP_Bugs.html
Also, FileMaker released an ODBC/JDBC updater that is supposed to cure "some memory leaks" (though not the above issue.) Have you downloaded and installed it? (Not part of the v3 updater, it's a separate download.)