BJ Freeman, I am sorry to say that, I didn't understand what you did in your solution , could you please explain me in brief or, update me with sample data how you achieve this(even that script file passed to me, that will be helpful to understand).
On Wed, Jul 15, 2009 at 6:16 AM, BJ Freeman <[email protected]> wrote: > i changed the order stats so only the current day is pulled in and > summed. Then the others are updated after the current day is calculated. > I used this practice on all reports that span over time. > > > Andrew Zeneski sent the following on 7/14/2009 9:45 AM: > > This could very well just be limited to the order stats page. Looking > > at the code it loads a lot of data in memory to get the calculations. > > With a lot of orders, I could see this throwing an out of memory > > error. We should look at refactoring this to get counts instead of > > pulling large lists of records. > > > > Andrew > > > > > > > > On Thu, Jul 9, 2009 at 9:07 AM, BJ Freeman<[email protected]> wrote: > >> I remember a discussion about a month ago where there would be memory > >> leaks where new code, written, that uses transactions did not close the > >> transaction properly. > >> > >> BJ Freeman sent the following on 7/8/2009 7:10 PM: > >>> I saw Adam heath in the dev list mention something. > >>> However as I said before I don't see my memory allocation creeping up > >>> and I have been running ofbiz 9.04 since it was released. > >>> so if there is a memory leak, I have not used the portions that have it > >>> or there is non. > >>> That is the best I can say. > >>> > >>> > >>> > >>> Kumaraswamy nandipati sent the following on 7/8/2009 7:05 PM: > >>>> BJ Freeman, > >>>> > >>>> As a technical person, > >>>> > >>>> I am curious to know what are the memory leaking areas in ofbiz? > >>>> (API methods, classes, etc.,) so, I can stop using them. Any > information > >>>> will be appreciated. > >>>> > >>>> > >>>> > >>>> On Thu, Jul 9, 2009 at 3:26 AM, BJ Freeman <[email protected]> > wrote: > >>>> > >>>>> an added information > >>>>> using swap file, called virtual memory in windows is many times > slower > >>>>> than using real memory. This because you are using disk access times > >>>>> instead of real memory access times. > >>>>> So do everything you can not get into the virtual memory. > >>>>> > >>>>> Kumaraswamy nandipati sent the following on 7/8/2009 1:54 PM: > >>>>>> Thanks for your reply BJ Freeman & Henning. > >>>>>> > >>>>>> You people gave new dimention of solutions. I have to look into > them. > >>>>>> > >>>>>> > >>>>>> By the way, I am using Debain server to host my ofbiz application. > May be > >>>>>> its time to concentrate on memory leaks. > >>>>>> > >>>>>> thanks once again for showing way to success(I feel). > >>>>>> > >>>>>> I am novise to linux script coding. My another question *is Is there > a > >>>>>> autoScheduler which will identify whether a ofbiz instance is > running or > >>>>>> not. If not, it will schedule(start) ofbiz automatically*. Because > of my > >>>>>> existing server condition(memory leaks), I need to use that > scheduler > >>>>> till > >>>>>> fix the memory leaks. Because, my ofbiz application was shutting > down at > >>>>> any > >>>>>> time of clock. > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> On Wed, Jul 8, 2009 at 9:43 PM, Henning <[email protected]> > wrote: > >>>>>> > >>>>>>> Btw.: There is a great memory analyzer tool available for eclipse > - a > >>>>> real > >>>>>>> life saver. > >>>>>>> > >>>>>>> See www.eclipse.org/mat. > >>>>>>> > >>>>>>> As your configuration will have given you heap dumps, why not let > that > >>>>> tool > >>>>>>> have a look at those? There is a "leak suspects" analysis available > that > >>>>>>> quite often leads to the hot spot. > >>>>>>> > >>>>>>> Henning > >>>>>>> > >>>>>>> -- Urspr. Mitt. -- > >>>>>>> Betreff: Re: Auto scheduler to start ofbiz instance required. > >>>>>>> Von: BJ Freeman <[email protected]> > >>>>>>> Datum: 08.07.2009 18:03 > >>>>>>> > >>>>>>> I run ofbiz and it only takes 700K I have 2 megs memory and never > use > >>>>>>> swap file. There is not memory leaks that I can see, my server has > been > >>>>>>> up for 14 days since my last restart to add code. > >>>>>>> as side note: > >>>>>>> if your using windows and a swapfile extensively, you system will > hang. > >>>>>>> So I would start by having a server with one instance to verify > that it > >>>>>>> is ofbiz or a modification you have done. Then work back. > >>>>>>> > >>>>>>> > >>>>>>> Kumaraswamy nandipati sent the following on 7/8/2009 8:42 AM: > >>>>>>>> Hi., > >>>>>>>> > >>>>>>>> I am using Ofbiz for my ecommerce application. Due to memory > issues > >>>>>>> server > >>>>>>>> geting shutdown. > >>>>>>>> > >>>>>>>> My ofbiz server hosted with memory information as follows > >>>>>>>> Primary memory : 4GB( 50% as swap) > >>>>>>>> > >>>>>>>> here is memory information in startup script: > >>>>>>>> > >>>>>>>> MEMIF="-server -Xverify:none -Xms1024M -Xmx1536M > -XX:MaxPermSize=1024M > >>>>>>>> -XX:+HeapDumpOnOutOfMemoryError -XX:+UseParNewGC > >>>>>>>> -XX:+CMSClassUnloadingEnabled -XX:+UseAdaptiveSizePolicy" > >>>>>>>> > >>>>>>>> > >>>>>>>> My application has two instances on two different machines for > load > >>>>>>>> balancing called *Frontend* and *Backend*(all other modules except > >>>>>>> ecommerce > >>>>>>>> module). both are different ofbiz instances for my website > synchronized > >>>>>>> at > >>>>>>>> apache level. > >>>>>>>> > >>>>>>>> I am having 2 issues > >>>>>>>> 1.P) When I open order stats page, backend ofbiz was getting down > for > >>>>>>> some > >>>>>>>> times because of out of memory issue. In orderstats page, its > trying to > >>>>>>>> travel each and every order in current year for stat information. > Till > >>>>>>> now > >>>>>>>> in current year, my application had 10K orders, This may holds > huge > >>>>>>> memory I > >>>>>>>> think. > >>>>>>>> > >>>>>>>> 2.P) My application(ecommerce module i.e Frontend) was running > fine for > >>>>>>> 4-5 > >>>>>>>> days, after that, it is shutting down because outOfMemory issue. > >>>>>>>> > >>>>>>>> In both ofbiz instances, I am using cache management for certain > things > >>>>>>> upto > >>>>>>>> 3 hrs of cacheing. > >>>>>>>> > >>>>>>>> Seriously these are two issues pointing me > >>>>>>>> > >>>>>>>> Before find a solution for this, I want to use a scheduler/cron > which > >>>>>>> will > >>>>>>>> identify server down and restart the server automatically and in > >>>>>>> meanwhile I > >>>>>>>> has to fix this issue. > >>>>>>>> > >>>>>>>> Any suggestions are appriciated towards this. > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>> -- > >>>>>>> BJ Freeman > >>>>>>> http://www.businessesnetwork.com/automation > >>>>>>> http://bjfreeman.elance.com > >>>>>>> > >>>>>>> > >>>>> > http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro > >>>>>>> Systems Integrator. > >>>>>>> > >>>>>>> > >>>>>>> > >>>>> -- > >>>>> BJ Freeman > >>>>> http://www.businessesnetwork.com/automation > >>>>> http://bjfreeman.elance.com > >>>>> > >>>>> > http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro > >>>>> Systems Integrator. > >>>>> > >>>>> > >> -- > >> BJ Freeman > >> http://www.businessesnetwork.com/automation > >> http://bjfreeman.elance.com > >> > http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro > >> Systems Integrator. > >> > >> > > > > -- > BJ Freeman > http://www.businessesnetwork.com/automation > http://bjfreeman.elance.com > > http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro > Systems Integrator. > > -- Thanks, Kumaraswamy.N 91-9866805250.
