RE: memory leak in sessions

This is your application requesting more connection memory to the Engine. What is your application written in? We have similar issues with long running jobs (fourjs) and simply need to stop and restart the process withing a couple of days. Find out from Tech Support what ralloc and opentable memory pools are and this may assist you locating the issues in your application. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of rkusenet > Sent: Tuesday, 16 March 2004 1:44 p.m. > To: informix-list@iiug.org > Subject: Re: memory leak in sessions > > > "scottishpoet" <dryburghj@yahoo.com> wrote in message > news:81714288.0403131259.47567580@posting.google.com... > > 9.21.UC4?? > > > > Loads of memory leaks in that one!! > > > > Latest 9.21 is UC7 and has a load of memory leaks fixed, but 9.21 > > stops being supported at the end of June. > > Ur answer is not good enuf. Loads of memory leaks of what type?? > > I spent the whole day today simulating memory leaks under various > conditions. I have concluded that memory leaks do not happen if > cursors are closed and freed properly and also prepare statement > are freed. Reusing cursor without closing them, or not freeing > prepared statment and reusing them definitely results in memory > leak. > > Now the big problem is how to find who is causing the leak. > I believe in 9.30 there is an onstat command onstat -g stm > which tells all prepared statements of that session. Is there > something similar for poor 9.21.UC4 folks?? I doubt it though. > The complexity is added by the fact that all sessions are multiplexed > via connection manager which pools all sessions. > > This session on Mar 11 at 14.50 hrs > > Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line -- > Up 08:04:30 -- 2394112 Kbytes > session #RSAM total used > id user tty pid hostname threads memory memory > 2491 gui - -1 whflxsnp 1 4517888 4342832 > > tid name rstcb flags curstk status > 2855 sqlexec 88dfb428 Y--P--- 1648 88dfb428 cond wait(netnorm) > > Memory pools count 1 > name class addr totalsize freesize #allocfrag #freefrag > 2491 V 76d38020 4517888 175056 8062 249 > > name free used name free used > overhead 0 1648 mtmisc 0 600 > scb 0 96 opentable 0 641248 > filetable 0 5520 ru 0 224 > blobio 0 15240 log 0 2152 > temprec 0 19272 blob 0 2152 > keys 0 62776 ralloc 0 3293576 > gentcb 0 1256 ostcb 0 2520 > sort 0 56 sqscb 0 96152 > sql 0 40 rdahead 0 1600 > hashfiletab 0 280 osenv 0 1304 > sqtcb 0 54464 fragman 0 125584 > sapi 0 7520 udr 0 152 > > Same session 4 days later. > > > Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line -- > Up 4 days 12:44:24 -- 2765824 Kbytes > > session #RSAM total used > id user tty pid hostname threads memory memory > 2491 gui - -1 whflxsnp 1 30556160 29320456 > > tid name rstcb flags curstk status > 2855 sqlexec 88dfb428 Y--P--- 1648 88dfb428 cond wait(netnorm) > > Memory pools count 1 > name class addr totalsize freesize #allocfrag #freefrag > 2491 V 76d38020 30556160 1235704 58902 2664 > > name free used name free used > overhead 0 1648 mtmisc 0 800 > scb 0 184 opentable 0 4336640 > filetable 0 12160 ru 0 224 > blobio 0 15240 log 0 2152 > temprec 0 19272 blob 0 2952 > keys 0 348888 ralloc 0 > 22334488 > gentcb 0 1256 ostcb 0 2520 > sort 0 56 sqscb 0 576376 > sql 0 40 rdahead 0 1600 > hashfiletab 0 280 osenv 0 1304 > buft_buffer 0 2136 sqtcb 0 352600 > fragman 0 1027792 sapi 0 138848 > udr 0 424 > > > Used memory has grown 7 times in 4 days. Something is definitely > wrong !!!! > Any pointer by anyone will be very helpful. > > thanks. > > sending to informix-list