Re: Synonym bug in 5.02?
Richard Ridley (rridley@sin-pss.DHL.COM) wrote: : Ben Kelley writes: : |I have been having problems with a memory leakage bug in Informix 4.1 (For : |SunOS 4.1.3, but the bug could be in other versions) where your sqlturbo : |process gradually grows, until it gets to the point where you get a : |"-208 Memory allocation failed during query processing" error message. : | : |You can demonstrate the bug by running the following pseudo program (with the : |appropriate databases set up): : | : |while true do : | open database 1 : | select some data from table 1 : | close database 1 : | : | open database 2 : | select some data from table 2 : | close database 2 : |od : We have experienced a similar problem when simply accessing data : through a view in a different tbconfig(using ISTAR) on the same : machine. Our version is 5.02.UC1, but it also happens on 5.01.UD3. : This is on an HP-UX 9.0 machine. : Our test program does the following : : declare cur cursor for select * from db2@star2:v2 : while true : foreach cur into rec.* : message num : let num = num + 1 : end foreach : end while : and the virtual memory space keeps growing till the program falls : over with the same error as yours : I would be very interested if you get any sort of reply from : Informix on this one. : Regards, : Richard Ridley : DHL Asia Pacific : (rridley@sin-pss.dhl.com) Folks, I'm getting something similar, but without the benefit of nice error messages. My turbos on my HP9000/G50 w/ 5.02 OnLine just show the turbos as "aborted" with no error message. I talked to Informix and they told me about Bug#23325 and Bug#24778, which involve memory leaks when comparing smallints with chars. Any time your code uses the automatic conversion, they malloc a variable and never release it. Also affects inserts of smallint into chars & vice versa. Informix has ***fixed*** it in 5.03UC1, but it's not available on any platform. ***grin*** Joe -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) BancTec Service Corportation 214-450-9896 Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall! ===========================================================================