Andy, Check the number of records being returned by your queries. I had this problem and no matter what you turn the JVm Heap size up to, it will not fix it. There is no good way to track this down. What I ended up doing is after every query ran, I logged the number of records returned. I discovered that one query was returning over 90,000 records everytime and the more often it ran, the more outofmemory errors I was getting. Hope this helps.
Christian -----Original Message----- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Friday, October 22, 2004 10:43 AM To: CF-Talk Subject: Re: Out of Memory Check your logs under <cfmx>/runtime/logs as well .. what are they saying? Andy On Fri, 22 Oct 2004 16:38:02 +0100, Andrew Dixon <[EMAIL PROTECTED]> wrote: > Hi Everyone. > > We noticed that our CF server service restarted itself twice today, > and then after checking the cfserver.log file, just before the start > up is logged it had the following: > > out of memory > autorestart: Restarting process > > The server has 1Gb RAM and the JVM setting under CF Admin are set to: > > Minimum JVM Heap Size (MB): 512 > Maximum JVM Heap Size (MB): 512 > > Does this error message mean that CF needed more than 512Mb, i.e. we > need to increase the value? or is there something else wrong? > > Best Regards > > Andrew. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
