Re: IS NULL memory leak
In article <695604$a20@camel19.mindspring.com>, Barry Leb <barryleb@atl.mindspring.com> writes >jregep@venus.vrx.vhi.com (John Regep) wrote: > > >>Hi All! > > >>Any one heard of this? > >>STATS: >>HP 9000 T600 & K450 >>HP/UX 10.2 >>Informix ODS 7.23 >>Informix 4GL 6.X > >>When using the "IS NULL" clause in a prepared select statment, then executing >>the statment, a memory leak is created. Comment? > >>We are trying to move to this new platform and this is a major stumbling block. > >>Informix keeps saying they will fix it in 2 or 3 weeks but its been 6 already. > >>Thy say its not on their known bug list, I can't believe that we are th only >>ones with this problem. Anyone else seen this? > >>Thanks a lot, >>John Regep >>Director Retail Development >>Value Rx, Inc. >>regepj@venus.vrx.vhi.com > >>PS Please respond to be directly as I am no longer on the general news group. >>PSS To all my Informix freinds out there... hope you have a great new year. >>See you in Seattle! > >Have Informix research bug id 85816, and see if it pertains to you. >It's a recent bug that was assigned within the last 45 days that we >came across on our system and involves a very specific type statement >involving null on an indexed column. Fortunatley or unfortunately for >us, it brought our system to it's knees. However, this allowed us to >treat it as a down system and we received a patch within a couple of >days. > >By the way, our system specifics are as follows: > >Sun Sparcenter 2000e >Solaris 2.6 >Informix 7.14ud5x3(2 patches incorporated specific to us) > >Two final notes. Apparently this bug has been around forever, going >back as far as version 5 engines. However, it did not impact us until >we upgraded our operating system from Solaris 2.4 to 2.6. > >Second, we are also seeing a potential memory leak on an different >system. This system is also running informix 7.14ud1(unpatched) on an >HP k400 running HPUX 10.01. The system is running a PeopleSoft HR >application. What we see are sessions that continually grap memory as >user do data entry. The memory does not free until they log off. The >specific memory type is ralloc. We have not identified the leak yet, Same here using 7.13 on a DRS/NX box. ralloc can go up to 15MB or more per session! >but there are some similarities with the bug mentioned above. >Fortunately, we have 1 gig of memory on this system, and the system >has handled the leak so far. > >Barry Leb > >National Linen Service >1420 Peachtree Street >MS #314 >Atlanta, GA 30309 > >(404) 853-6119 >(404) 853-6485 fax >e-mail: barryleb@mindspring.com > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care