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.

Log a problem with technical support then. "rkusenet" <rkusenet@sympatico.ca> wrote in message news:<c35iff$251mmi$1@ID-75254.news.uni-berlin.de>... > "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.