SQL memory leak makes FileMaker unusable!
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.
Stopping the database and restarting purges the memory. This is not even a workaround, but an emergency measure. Not a workable situation!