RE: Virtual segments
It is indeed a memory leak:
Bug 131387(MEMORY LEAK WHEN LOADING/INSERTING VARCHAR)
This bug has been fixed in 9.21.UC3 onwards.
This bug is not reproducible in any 9.20.Ucx releases.
I ran into it with IIF 9.21.HC2 on HPUX 11.0. Upgraded to 9.21.HC4, and
that is working beautifully!! :-)
HTH,
Paul Mosser
-----Original Message-----
From: Watson, Paul [mailto:Paul.Watson@aggregate.com]
Sent: Thursday, February 01, 2001 6:32 AM
To: 'The Siebrands'; informix-list@iiug.org
Subject: RE: Virtual segments
> Hi,
>
> An interesting problem.
>
> I have an app which has mulitple connections to the database
> (IIF9.21 on
> Soaris 5.7), depending upon which service the app is
> runining, via JDBC
> using shared connection pools. All is good and well until we start
> proccessing orders via the app(java) involves inserts and
> updates to two
> tables. The inserts and updates contain started varchar, etc
> and xml into a
> smart blob. For each order proccess the vistual memory used
> increases by
> 250 to 320 blocks, while the no of connections to the database remains
> constant. However, at no point is the virtual memory
> released back.
This is the way it works, you need to do an onmode -F to release
shm segments that are empty, but I suspect your additional segments
have have contents and therefore can't be released.
> The number of virtual segments keeps increasing unitl all
> available memory on the server is used or it reaches SHMTOTAL.
>
> Does anyone have any ideas of how to try and track down this
> small problem, as I have ran out of ideas.
You have a memory leak. We have a similar problem under 9.20,
and we have still not been able to trace to a particular process.
We connect via 4gl, directly from apache, and via the cgi webdriver
and one of these is giving us problems. The favourite is the
cgi webdriver but we been unable to prove it
>
>
> Regards,
>
> Hans
>
> --
> Hans Siebrand
> Senior Database Administrator
> Westfield Limited
> PH: +61 2 9358 7731
> hans.siebrand@westfield.com.au
>
>