BJ Freeman, After reading your solution for several times in a day,
I got the solution as follows. I created a Dynamic view entities using aggregate on orders count and grand total sum for given time period. This solved my problem. On Fri, Jul 17, 2009 at 10:30 PM, Kumaraswamy nandipati < [email protected]> wrote: > 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. > -- Thanks, Kumaraswamy.N 91-9866805250.
